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.

Options
edited 12/09/19

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

Tags:

• ✭✭✭✭✭✭
edited 06/10/16
Options

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

• edited 06/10/16
Options

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?

• Options

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!

• ✭✭✭✭✭✭
Options

Happy to help.

This discussion has been closed.