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

Options
lovelyemy
lovelyemy ✭✭
edited 02/17/23 in Smartsheet Basics

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)

Tags:

Answers

  • Ipshita
    Ipshita ✭✭✭✭✭✭
    Options

    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

    Ipshita Mukherjee

  • lovelyemy
    Options

    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.
    Genevieve P. Employee Admin
    Options

    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