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.

Richard C
Richard C ✭✭
edited 12/09/19 in Archived 2016 Posts

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:

Comments

  • Atus Bartal
    Atus Bartal ✭✭✭✭✭✭
    edited 06/10/16

    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

     

     

  • Richard C
    Richard C ✭✭
    edited 06/10/16

    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!

  • Atus Bartal
    Atus Bartal ✭✭✭✭✭✭

    Laughing

    Happy to help.

This discussion has been closed.