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
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)
Comments
-
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.
-
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 [ ].
-
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 [ ].
-
Woohoo fixed it
=IF(OR(Status6 = "Red", Status6 = "Yellow"), 1)
-
Boom fixed it myself.
=IF(OR(Status6 = "Red", Status6 = "Yellow"), 1)
-
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.
-
NVM. Looks like you figured it out.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives