Why won't my yellow indicator show up?

Michelle Barnett

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

Bassam Khalil

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

Michelle Barnett

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

@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.