I would like to create a formula that measures the health of a project (Red, yellow, green) with missing dates:


Expected Date (June 6, 2019)- I assign that date to the vendor

Scheduled Date (this is expected within 5 days of assigned expected date)- this is filled in by vendor

Completed Date (this is expected within 5 days of scheduled expected date)- this is also filled in by vendor


What I would like to have the health colors change when the vendor hasn't placed the dates in to call out the health of that task (also highlighting that it's late).

I am assuming that I would have to have a few health titles; ie. Beginning Project Health, Completing Project Health, etc.







Hi Jennifer,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Have a fantastic weekend!


Andrée Starå

Workflow Consultant @ Get Done Consulting