Skip to main content
Question

Formula adding fields, but leaving one out if a certain word

  • March 4, 2020
  • 0 replies
  • 35 views
Forum|alt.badge.img+3
I have a formula to name records in one of my tables that is something like:
List(" - ",[Field1],[Field2],[Field3],[Field4],[Field5])

This works quite well for us, but when Field2 is selected as None I don't want None in the output. How would I write this so that when None it reads it as blank?

------------------------------
Johnny DeVilla
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+3
my solution was to pull from another field that has this formula and works well
List(", ",


IF(Contains(ToText([Field2]), "Hedge Hogs"), "Hedge Hogs"),
IF(Contains(ToText([Field2]), "Pink Ribbons"), "Pink Ribbons"),
IF(Contains(ToText([Field2]), "None"), ""))

------------------------------
Johnny DeVilla
------------------------------
Terms & ConditionsAccessibility statement