1

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.

Thanks

Jennifer

 

Functionality
Department

Comments

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!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting