Formula Stops after first IF statement.
I have a Formula that has multiple IF statement, but after the formula processes the first IF statement, it will not continue to the other IF statements. I have tried a "," after every IF statement a...
Forum Discussion
Try this
List(" ",
If(Contains([Field1],"Value 1"), ToText("|Value 1:") & " " & [Field 2]),
If(Contains([Field1],"Value 2"), ToText("|Value 2:") & " " & [Field 3]),
If(Contains([Field1],"Value 3"), ToText("|Value 3:") & " " & [Field 4]),
If(Contains([Field1],"Value 4"), ToText("|Value 4") & " " & [Field 5))
Note that you can simplify this syntax here
ToText(" |Value 4")
with just
" |Value 4"
The List function will separate any non empty results of the IF with, in my example, a space, but you can use any string in the Quotes as the separator.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark, you are the man!
I have learned something new today. Thank you for the help!
------------------------------
Russell Hansen
------------------------------
