How do I generate the same information that is entered in the parent, into the children?

Gabriel Barrera

I am trying to create a report that displays the parent and the children rows, but the criteria is only based off the parent. For example, each parent and children have statuses. But the parent row is the deciding status, the status that matters. I want to show all projects that have a certain PM assigned, AND if the parents' row status is "X". I want it to ignore what the childrens' status is, but still pull it in the report, and have it under the respective Parent row. I am unsure if I need to create a helper column in the sheet I'm referencing, or if there is a trick to do this within the report configuration.

I hope this makes sense.

Paul Newcome

You would need to create a helper column with a formula along these lines:

=PARENT(Status@row)

Paul Newcome

You would need to create a helper column with a formula along these lines:

=PARENT(Status@row)

Gabriel Barrera

@Paul Newcome wow... I feel like such a noob. Thank you!!

Paul Newcome

No worries. Happy to help. 👍️