Flag Parent Row if Child Task Meets Condition
I am looking for a way to count the children of a parent row, but only if the children have a particular attribute that is true. I'll then use that count to set up an CountIF to flag the parent row when the count is greater than one.
The way my sheet is set up, I have parent rows and child rows. Milestone tasks are denoted by a checkbox where the checkbox is checked if the task is a milestone. I want to create a flag that indicates the parent row has at least 1 child row where the child is a milestone.
So put another way: Flag the parent row if any of the children are milestones.
Any thoughts? I can only seem to get as far as counting the children of the parent row regardless of whether they're milestones or not.
Help Article Resources
Check out the Formula Handbook template!