Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Symbols not changing based on the value in another cell.
I entered: =IF(%3 > "0%", "Red", IF(%3 > "50%", "Yellow", IF(%3 > "85%", "Green"))) and all the cells are red. Not sure why the formula is wrong! . The icon is in the column "Indicator" and the value is in the column "%". Any help much appreciated
Comments

Richard,
try this: =IF(%3 > 0.5, IF(%3 > 0.85, "Green", "Yellow"), "Red")
If you really need it to be plain if the value is 0, then use it this way:
=IF(%3 <> 0, IF(%3 > 0.5, IF(%3 > 0.85, "Green", "Yellow"), "Red"), "")
[both for the 3rd row in the column called "%"]
hoping it helps,
Atus

Thanks Atusi'm making progress and really appreciate your help. I used
=IF(%3 <> 0, IF(%3 > 0.5, IF(%3 > 0.85, "Green", "Yellow"), "Red"), "")
However when the value is between .5 and .84the symbol doesn't change to yellow. Make sense?

ATUSwhen i applied the formula into my master sheet (I was using a test sheet to play around with) IT WORKED!
THANK YOU THANK YOU THANK YOU! Hope I can return the favor someday!

Happy to help.