Symbols and percentage of
I need your help to show status as Red, Green or Yellow using this criteria:
Green - 91-100
Yellow - 51 - 90
Red = 0-50
Tags:
Best Answer
-
Hi @jezright
Try this and let me know if it works for you:
=IF(Percentage@row > 0.9, "Green", IF(Percentage@row > 0.89, "Yellow", IF(Percentage@row > 0.5, "Yellow", "Red")))
https://www.linkedin.com/in/zchrispalmer/
Answers
-
Hi @jezright
Try this and let me know if it works for you:
=IF(Percentage@row > 0.9, "Green", IF(Percentage@row > 0.89, "Yellow", IF(Percentage@row > 0.5, "Yellow", "Red")))
https://www.linkedin.com/in/zchrispalmer/
-
Thank you so much. This worked
-
I'm happy this worked for you!
https://www.linkedin.com/in/zchrispalmer/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!