Reduce IF formula with OR condition
Hello everybody!
Hope you are doing well.
I am creating a board for a project that we are about to start and I want the symbol identifiers to be auto-populated based on statuses and blocks/defects.
I was able to put together the formula below, which works, but I am sure I can reduce it with an OR condition, but I am not sure how to accomplish that.
=IF(Blocked@row = 1, "Red", IF([Defect Identified]@row = 1, "Blue", IF(Status@row = "Backlog", "Yellow", IF(Status@row = "Done", "Green", IF(Status@row = "Next", "Yellow", IF(Status@row = "Analysis", "Yellow", IF(Status@row = "Building/Redacting", "Yellow", IF(Status@row = "Review", "Yellow"))))))))
There are several statuses for which I will want the identifier to be yellow, but when I try to enter OR I get an error.
Any help is appreciated.
-Josue
Best Answer
-
=IF(Blocked@row = 1, "Red", IF([Defect Identified]@row = 1, "Blue", IF(Status@row = "Done", "Green", IF(OR(Status@row = "Backlog", Status@row = "Next", Status@row = "Analysis", Status@row = "Building/Redacting", Status@row = "Review"), "Yellow"))))
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!