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

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

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
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!