Health Bubble Turn Colors when Status is Updated
Hello,
I am new to Smartsheet. I am trying to get when I change my Status to "Not Started" I want the Health bubble to automatically turn grey. And when I change my Status to "In Progress" the Health bubble will turn yellow, etc.
So far I have: IF(Status1 = "Not Started", "Gray", " ").
I want it to change color for each value change. Thanks!
Edit: I figured it out.
Best Answer
-
You will need a nested IF formula:
=IF(Status@row="Not Started", "Gray", IF(Status@row="In Progress", "Yellow", IF(Status@row="Complete", "Green")))
Just add more IF Statements like above for what you need. Put all ) at the very end. Then you can turn it into a column formula by right clicking the cell the formula is in and selecting column formula.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Answers
-
You will need a nested IF formula:
=IF(Status@row="Not Started", "Gray", IF(Status@row="In Progress", "Yellow", IF(Status@row="Complete", "Green")))
Just add more IF Statements like above for what you need. Put all ) at the very end. Then you can turn it into a column formula by right clicking the cell the formula is in and selecting column formula.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!