Health status formulas and automation

Hi, is anybody able to help with automation formulas for the Health column? I'm very new to Smartsheet and struggling a bit! I'm trying to do the following:

Green - Status='In Progress' and more than 1 week before end date, or status= 'Complete'

Yellow - Status= 'In Progress' but end date 1 week away

Red- Start date is before today and status='Not started',or end date has passed and status is 'Not started' or 'In Progress', or status='On Hold'

Grey - Status='Not started' and today is before start date

Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!