Remove health from Project Level row

Christine Brown (SAI)

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!!

Kelly Moore

Hey @Christine Brown (SAI)

Try this

=IF(OR(ISBLANK(Status@row), Hierarchy@row=0), "", IF(AND([Due Date]@row < TODAY(), Status@row <> "Complete"), "Red", IF(Status@row = "Not Started", "Gray", IF(Status@row = "Blocked", "Yellow", "Green"))))

cheers

Kelly Moore

Hey @Christine Brown (SAI)

Try this

=IF(OR(ISBLANK(Status@row), Hierarchy@row=0), "", IF(AND([Due Date]@row < TODAY(), Status@row <> "Complete"), "Red", IF(Status@row = "Not Started", "Gray", IF(Status@row = "Blocked", "Yellow", "Green"))))

cheers

Christine Brown (SAI)

@KDM That is perfect, thank you very much!