Automated symbol isn't switching

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.

  • Great, thank you! That makes sense