IF/OR Functions

Options

=IF(OR(AND([Column2]@row = "yellow", [Column4]@row <> ""), IF(AND([Column2]@row = "green", [Column4]@row <> ""))), true)


Hi everyone,

I want my column to be checked, when either yellow or green is appeared in [Column2] and when [Column4] is empty in both cases.

Can someone tell me what I am doing wrong?

Thanks!

Aspa

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!