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.
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 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