Health ball question
I tried to search how to do this formula, and I feel like I'm really close, however it just isn't right.
I am looking to write a formula where it will show the "health" of an error percentage.
0% is green; 1<50% is yellow; 50%< is red
Where 0% is green; 1-50% is yellow and over 50% is red.
Thank you!
Answers
-
=IF(Status@row = 0, "Green", IF(Status@row <= .5, "Yellow", "Red"
Just update column name in formula to match your needs.
-
I think the platform has deleted part of Nic's formula (it doesn't like us using < symbols!). You need two closing parentheses.
=IF(Status@row = 0, "Green", IF(Status@row <= .5, "Yellow", "Red"))
-
I appreciate you both for responding, I was driving myself crazy! It took me a bit to figure out I also had the "Restrict to symbol values only" turned on. Once I turned that off it worked perfectly.
-
Wonderful, glad you got there!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!