Health ball question

C.Beaudoin · 04/22/24

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!

Nic Larsen · 04/22/24

=IF(Status@row = 0, "Green", IF(Status@row <= .5, "Yellow", "Red"

Just update column name in formula to match your needs.

KPH · 04/23/24

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"))

C.Beaudoin · 04/23/24

https://community.smartsheet.com/discussion/comment/432403#Comment_432403

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.

KPH · 04/23/24

Wonderful, glad you got there!

Health ball question

Answers

Help Article Resources

Categories