Formula Stops after first IF statement.

Question

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 and "&amp;" after every IF statement, but that has not working. The Formula is looking at the output of a Multi-select Text field. Here is an example of my Formula.&nbsp;If(Contains([Field1],"Value 1"), ToText("|Value 1:") &amp; " " &amp; [Field 2],If(Contains([Field1],"Value 2"), ToText(" |Value 2:") &amp; " " &amp; [Field 3],If(Contains([Field1],"Value 3"), ToText(" |Value 3:") &amp; " " &amp; [Field 4,If(Contains([Field1],"Value 4"), ToText(" |Value 4") &amp; " " &amp; [Field 5))))What's happening is that if&nbsp;Field 1 outputs "Value 1" and Value 4 then only the First IF statement will ToText and not the Fourth IF statement as well.&nbsp;The desired output should be "|Value 1 Field 2 |Value 4 Field 5"
------------------------------Russell Hansen------------------------------

markshnier__you · Answer

Try this
List(" ",
If(Contains([Field1],"Value 1"), ToText("|Value 1:") &amp; " " &amp; [Field 2]),If(Contains([Field1],"Value 2"), ToText("|Value 2:") &amp; " " &amp; [Field 3]),If(Contains([Field1],"Value 3"), ToText("|Value 3:") &amp; " " &amp; [Field 4]),If(Contains([Field1],"Value 4"), ToText("|Value 4") &amp; " " &amp; [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.&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

russellhansen · Answer

Mark, you are the man!&nbsp;I have learned something new today. Thank you for the help!------------------------------Russell Hansen------------------------------

Forum Discussion

Formula Stops after first IF statement.