Why won't my yellow indicator show up?

Options

I'm evaluating a field to see if it's greater than 5 days..

=IF([S1-W0]@row > 6, "Red", IF(AND([S1-W0]@row = 5, [S1-W0]@row < 5), "Yellow", "Green"))

This is the formula I'm using. It will show red and green but if it's = 5 days, it still shows green.

Would someone please show me what I'm doing wrong.

Thanks

Michelle

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 07/14/21
    Options

    Hi @Michelle Barnett 

    Hope you are fine, please try the following formula

    =IF([S1-W0]@row > 6, "Red", IF([S1-W0]@row <= 5, "Yellow", "Green"))
    

    but please note that your formula will show Green only when [S1-W0] = 6


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Michelle Barnett
    Michelle Barnett ✭✭✭✭
    Options

    Hi Bassam,

    Thank you for getting back to me. I got an unparseable error, when I entered the formula, but I see that it worked for you in the example above. I just cut and pasted it, I'm not sure why it doesn't work.

    Michelle

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    @Michelle Barnett

    Please check your column type, and if you like share me as an admin on a copy of you sheet after you remove any sensitive data.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!