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
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!