Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

IF(OR) Help needed

edited 12/09/19 in Archived 2017 Posts

Hi All - 


I'd like to use a formula to evaluate status of red OR yellow then flag if red or yellow. I think I'm close but it's not working, please help.  Here is what I have:

=IF(OR([Status6] = "Red", [Status6] = "Yellow"), 1) (doesn't work) angry

=IF((Status7 = "Red"), 1 (this works for red and sets the flag on for reporting purposes) 


This discussion has been closed.