Automate RYGGrey

jlr67
jlr67
edited 12/09/19 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!