Nest IF statement with an AND embedded for RYG
Best Answer

Try something like this...
=IF([Finish Date]@row>TODAY(3), IF([% Complete]@row<.6, "Red", IF([% Complete]@row<.75, "Yellow", "Green")), "Green")
Answers

Try something like this...
=IF([Finish Date]@row>TODAY(3), IF([% Complete]@row<.6, "Red", IF([% Complete]@row<.75, "Yellow", "Green")), "Green")

That appeared to get it!! You are awesome! thanks


I tried to copy the formula again, but it is not working.. The reason was, I working with it and anything less than 60% regardless of the date was red....

Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!