Project Health Formula
I am facing some difficulty to get a formula for the logic below:
Actual Start Date is blank AND Today () < Target Start Date
Actual Start Date < Target Start Date AND status “in progress”
Target End Date – Actual End Date >=0.1 * Duration planned AND Target End Date – End Date <=0.3 * Duration planned
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?
Help Article Resources
Check out the Formula Handbook template!