Why won't my yellow indicator show up?
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.
Help Article Resources
Check out the Formula Handbook template!