Hi Everyone--I am trying to create a multiple IF statement that is coming an "or" and a "contains" .

This is what I have. It works independently as single statements but combined I get the dreaded UNPARSEABBLE.

=IF(OR(temp@row = “Ambient”, Temp@row = “None Required”), “WIP”), IF (Temp@row = "2-8c cooler", "COL"), IF(CONTAINS(Temp@row, "Freezer"), "FRE")

This is my ask:

If the column TEMP (in this row) says "Ambient" or "None Required" the result is WIP, IF the Temp (in this row) is "2-8c Cooler" the result is COL, IF the TEMP(in this row) contains the word "Freezer" the result is FRE.

Any help is appreciated!

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Once you fix the parenthesis issue, the syntax should be correct.

    The problem then becomes some of your quotes...

    See the slanted ones? Those are called "Smart Quotes" which (ironically enough) Smartsheet does not recognize as a valid character in formulas. You are going to need to retype them either here in the community, in Smartsheet directly, or in a text editor such as Notepad (not Word).


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!