Harvey Ball

You can see in this formula the Status (harvey ball) column defaults to Blue. It changes colors to Green, Yellow and Red with conditions from the Risk Rating Level column and it works perfect.
However, I want the harvey ball to turn Red if the Risk Rating Level is Extreme even if the Complete checkbox is checked.
=IF(Status@row = "Complete", "Blue", IF([Risk Rating Level]@row = "", "Green", IF([Risk Rating Level]@row = "Low (Okay to proceed)", "Green", IF([Risk Rating Level]@row = "Extreme (Put event on hold)", "Red", "Yellow")))))
Best Answer
-
Have you tried just changing the order of the tests? It should respond the way you want if you test first for the Extreme Risk Rating….
Answers
-
Have you tried just changing the order of the tests? It should respond the way you want if you test first for the Extreme Risk Rating….
-
Thanks Todd, worked perfect; it's been day…
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!