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
------------------------------
Original Message:
Sent: 03-04-2020 15:39
From: Johnny DeVilla
Subject: Formula adding fields, but leaving one out if a certain word
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
------------------------------