Red, Yellow, Green, Gray automation formula help needed for numerical ranges

lovelyemy

I have a column called "Resource Totals" and I am trying to create conditions for the status column (Already made it a symbols column) for Red, Yellow, and Green

Green = 0.9-1.1

Yellow= 1.2-1.3

Red = >1.3

=IF([Resource Totals]@row = "0.9-1.1", "Green", IF([Resource Totals]@row = "1.2-1.3", "Yellow", IF([Resource Totals]@row > 1.3, "Red")))

No color is populating😟 for Green or Yellow but Red works just fine. Am I doing something wrong?

Supplemental Information:

My current values for my "Resource Totals" column are: 1.2, 1, 1.1, 1.3, 1.5 (only this one is red)

Ipshita

Hi @lovelyemy Yes, there is a small error in your formula -

Use this instead - =IF([Resource Totals]@row <= "0.9-1.1", "Green", IF([Resource Totals]@row <= "1.2-1.3", "Yellow", IF([Resource Totals]@row > 1.3, "Red")))

Hope this helps, don't forget to mark my response as "Awesome" if it does ;)

Cheers!

Ipshita

lovelyemy

Hi there, your formula works for everything except when I have any 1.3 values. Instead of it being yellow, it's just blank.

Genevieve P.

Hiya! Just jumping in here.

It looks like all you need to do is add an = sign after the > sign, like so:

IF([Resource Totals]@row >= 1.3,

Cheers,

Genevieve