I am having hard time to have a formula to obtain the health color for the task
I have 3 columns: End Date, Circuit Quote% Status and Quote Health
IF(AND( [Circuit Quote % Status]@row <=0.5, [End Date]@row <= Today (7)), “Red”
IF(AND([Circuit Quote % Status]@row >=0.51 , [Circuit Quote % Status]@row<=0.95, [End Date]row, <=TODAY(7)),”yellow”
Now…… IF(AND([Circuit Quote % Status]@row >=0.95, [Circuit Quote % Status]@row<=0.1, [End Date]row, <=TODAY(7)),”green”
IF Circuit Quote % Status is not 100% and finishes after the End Date stay RED
IF Circuit Quote % Status has “N/A” the health is Grey
I really appreciate any help
Thanks
Rob😀