Remove health from Project Level row
Hi! I'm trying to remove the health function from the upper hierarchy/project level row in my project plan. The way I have it set up will give a health of Red if the due date is past and I only want health at the phase and task levels.
Do you have any suggestions for how to edit the formula?
=IF(ISBLANK(Status@row), "", IF(AND([Due Date]@row < TODAY(), Status@row <> "Complete"), "Red", IF(Status@row = "Not Started", "Gray", IF(Status@row = "Blocked", "Yellow", "Green"))))
Thank you very much!!
Help Article Resources
Check out the Formula Handbook template!