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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!