How do I show health based on end date & % complete?
I'm trying to show health of a project based on how far out from End date + how much of the work has been completed.
100% complete before or on End date
70-99% and today is < 1 range of End Date
<69% and date within 2 days of End Date
<69% and today is <1 range of End Date
This was what I wrote, and I keep getting "Unparseable"
=IF([%Complete]@row=1, "Green", IF((OR(AND[% Complete]@row<1, [%Complete]@row>.69, TODAY(-1)<[End Date]@row), (AND[%Complete]@row <.7, TODAY(-2)<[End Date]@row) ,"Yellow", "Red")