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?