Automate RYGGrey
jlr67
✭
I need help with a formula to automate my RYGGrey. Here are the rules:
If status = complete, grey
If status is in progress or not started and finish is in the past, red
If status is in progress or not started and finish is today + 5 days (within the next 5 days), yellow
If status is in progress or not started and finish is greater than 5 days out, green
Comments
-
Give this a go...
=IF(Status@row = "Complete", "Gray", IF(Finish@row < TODAY(), "Red", IF(Finish@row < TODAY(5), "Yellow", "Green")))
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!