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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!