Formula to evaluate child statuses to determine the parent status
I have different milestones in a project and want the parent milestone level to show a general "temp" based on the statuses in the child tasks below it. The thought is, if any of the child tasks contain a status of "delayed, on hold, blocked, requires update" the status cell on the parent Milestone row should turn yellow.
Is this possible?
I'm currently using this:
=IF(COUNTIFS(STATUS64:STATUS71, "Complete") = COUNT(STATUS64:STATUS71), "COMPLETE", IF(COUNTIFS(STATUS64:STATUS71, "Not Started") = COUNT(STATUS64:STATUS71), "Not Started", "In Progress"))
This shows when a whole section is complete.
Or, maybe a better way to ask: What's a better way to gauge the subtasks at a glance to see visually see potential project risk?
Help Article Resources
Check out the Formula Handbook template!