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 Atus--i'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 .84--the symbol doesn't change to yellow. Make sense?
-
ATUS--when 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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives