How do I display a different symbol based on multiple values?


I've searched the community and tried multiple formulas but I cannot seem to get this scenario to work.

I have a '% Not Achieved' summary field, and depending on the % I want Green, Yellow or Red to display.


0% = Green

1% - 10% = Yellow

11% and over = Red

This is the formula I'm currently using. I get the Green and Yellow to show but not the Red. What am I doing wrong?

=IF(OR([% Not Achieved]# = 0), "Green", IF(OR([% Not Achieved]# >= 1, [% Not Achieved]# <= 10), "Yellow", IF(OR([% Not Achieved]# >= 11), "Red",)))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!