#### 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

Options
edited 12/09/19

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)

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

• Options

JDigrazia,

Try adding ,0 right after 1. So it will look like this.

=IF(OR([Status6] = "Red", [Status6] = "Yellow"), 1, 0)

Hope this does the trick.

• Options

Didn't work.  Doh!  Basically if the status is a red or yellow harvey ball (which works with the red formula) then I wan the flag to turn on.  To turn it on, I need the "1" to enable the flag.  Not sure what the 0 does here but I think it's with the [ ] and [ ].

• Options

Didn't work.  Doh!  Basically if the status is a red or yellow harvey ball (which works with the red formula) then I wan the flag to turn on.  To turn it on, I need the "1" to enable the flag.  Not sure what the 0 does here but I think it's with the [ ] and [ ].

• Options

Woohoo fixed it

=IF(OR(Status6 = "Red", Status6 = "Yellow"), 1)

• Options

Boom fixed it myself.

=IF(OR(Status6 = "Red", Status6 = "Yellow"), 1)

• Options

Oh yeah that's my bad. Looks like it will work with or without the 0.

I think your are right with the []. In your example is the name of the column "Status" and the row you are referring to 6? Try putting the ] in front of the number.

• Options

NVM. Looks like you figured it out.

This discussion has been closed.