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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!