Automated symbol isn't switching

LJK
LJK ✭✭
edited 06/30/22 in Formulas and Functions

Hi everyone,

I am trying to automate symbols. The logic should be if the specific cell is below 90% then mark it as a red symbol, if it is greater than 90% mark it as yellow if it is greater or equal to 100% mark it green.

This is what I got:

=IF([Actual vs. Target Sq ft. Produced]@row < 0.9, "Red", IF([Actual vs. Target Sq ft. Produced]@row > 0.9, "Yellow", IF([Actual vs. Target Sq ft. Produced]@row >= 1, "Green")))

The symbol doesn't turn green when over 100%. Yellow and Red are working.

Thank you for the support.

Best Answer

  • Jacinta
    Jacinta ✭✭
    Answer ✓

    A value of 1 would also be true for the condition you have written for Yellow, so the IF statement stops there. swap the green and yellow ones arounds so the if statement encounters the Green condition first and only moves on if it is rejected.

    You could also remove the yellow condition entirely and put "Yellow" as the value if both other if statements are false.

Answers

  • Jacinta
    Jacinta ✭✭
    Answer ✓

    A value of 1 would also be true for the condition you have written for Yellow, so the IF statement stops there. swap the green and yellow ones arounds so the if statement encounters the Green condition first and only moves on if it is rejected.

    You could also remove the yellow condition entirely and put "Yellow" as the value if both other if statements are false.

  • LJK
    LJK ✭✭

    Great, thank you! That makes sense

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!