Balls Changing Colors

Lea722 · 02/14/25

Hello,

Why is the signal status color column populating a color when I have nothing in the value column? How do I stop this?

My current formula is

=IF(Value@row >= 90, "Green", IF(Value@row <= 84, "Red", IF(Value@row < 90, "Yellow")))

Thanks!!

Carson Penticuff · 02/14/25

The blank cells are likely returning true as being less than or equal to 84… treated as 0. Try this:

=IF(ISBLANK(Value@row), "", IF(Value@row >= 90, "Green", IF(Value@row <= 84, "Red", IF(Value@row < 90, "Yellow"))))

Carson Penticuff · 02/14/25

The blank cells are likely returning true as being less than or equal to 84… treated as 0. Try this:

=IF(ISBLANK(Value@row), "", IF(Value@row >= 90, "Green", IF(Value@row <= 84, "Red", IF(Value@row < 90, "Yellow"))))

Lea722 · 02/17/25

Worked like a charm!! Thank you!!!!

Carson Penticuff · 02/17/25

Happy to help!

Formulas and Functions