using OR and multiple expressions


I created this statement using OR and CONTAINS to select a value between 2 expressions - Stage 1 or Stage 2:

=IF(OR(CONTAINS("Stage 1", Function@row), CONTAINS("Stage 2", Function@row)), IF([Example Result]@row >= -30, 1))

This works fine for recognizing and providing results for Stage 1 & 2 logical expressions.

I want to add a 3rd logical expression (Stage 3) but I am getting INCORRECT ARGUMENT SET errors:

=IF(OR(CONTAINS("Stage 1", Function@row), CONTAINS("Stage 2", Function@row), CONTAINS("Stage 3", Function@row), IF([Example Result]@row >= -30, 1)))

I thought i was able have more than 2 logical expressions using the OR statement.

Appreciate any help and thanks.


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @Rick Girard

    It looks like a parenthesis is missing to close off the OR statement.

    =IF(OR(CONTAINS("Stage 1", Function@row), CONTAINS("Stage 2", Function@row), CONTAINS("Stage 3", Function@row)), IF([Example Result]@row >= -30, 1))

    Will this work for you



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!