Balls Changing Colors

Lea722

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

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

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

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

@Carson Penticuff

Carson Penticuff

Happy to help!