Project Health Formula

Hey guys!

I am facing some difficulty to get a formula for the logic below:


Green

Actual Start Date is blank AND Today () < Target Start Date

Actual Start Date < Target Start Date AND status β€œin progress”

Β 

Yellow

Target End Date – Actual End Date >=0.1 * Duration planned AND Target End Date – End Date <=0.3 * Duration planned

Β Β 

Red

Actual Start Date is blank AND Today () > Target Start Date

Actual Start Date > Target Start Date

Today () > Actual Start Date + 1.3* Duration Planned


Please, could yo help me?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!