# Automated symbol isn't switching

Options
✭✭
edited 06/30/22

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.

• ✭✭
Options

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.

• ✭✭
Options

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.

• ✭✭
Options

Great, thank you! That makes sense

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!