I want to show Parent rows in a filtered Report

emilyc

I have a column with an IF/AND formula to flag whether a "Milestone" is "At Risk" based on a series of conditions. I have a report that then filters on this Flag column to show such "Milestones". However, I would like this report to also pull in the Parent row of any "Milestone" rows that appear - which I call "Phase" rows, so there is some context/organization to the report. Similar to how a filter view in the source sheet project plan allows you to show Parent rows.

Is this possible?

My hierarchy is this:

Parent = Phase

Child = Milestone

Grandchild = Task

Paul Newcome

You would need to update the formula so that it will also flag the parent row if any of the children are flagged.