Nested IFs- mutually exclusive

I have a nested IF formula to change the status ball colors as values are entered down the line. They usually get entered one at a time. If column A gets filled then it turns green, then if B gets filled it turns yellow, etc..
Column A | Column B | Column C
Green | Yellow | Red
X | X | X
But sometimes we will skip over some columns and only have a data point at the end, in which case we still want it to turn the same color as it would if we had filled in all the other data points.
The way the nested IF formula is built currently, everything must be filled in as we go down the line.
Is there a way to make this still work? Seems like what I'm looking for in a IFS formula, which doesn't exist in smartsheet...
Column A | Column B | Column C
Green | Yellow | Red
| | X
(right now will only turn Red if only A and B are filled out as well)
Comments
-
Build it right to left instead of left to right
(check red, then check yellow, then check green)
Craig
-
I will try that. Thank you J
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!