How to get a report or list of items that have subtasks (children) but including the parent row?

Paola Barlow, PMP

Hi SS team,

I'm using the card view to synthesized a large data set in a sheet. In the card view, It will reflect what is parent task they're assigned to. I need that information in a report.

The problem I'm having is that in any report that I create it will bring the other rows that are not linked to the child row.

For example:

"Parent 0, Child 1", the report will bring all other rows with "0" in the hierarchy relationship.

Card View will reflect in small letters on top of the card the Parent task and the sub-task that is linked to. I need to extract this information, how?? Please.

Paul Newcome

I would suggest a checkbox column in the sheet that has a formula to check off the child rows if they meet the report criteria. You can then use a formula to check off the parent row if any child row is checked and have the report pull based on this column.

Paola Barlow, PMP

Hi Paul,

What is the formula you're suggesting that will help me identify the parent attached to the child row?

Paola Barlow, PMP

Thanks for your help

Paul Newcome

The formula for the parent rows could be something along the lines of...

=IF(COUNTIFS(CHILDREN()), 1) > 0, 1)

The formula in the child rows could vary depending on your criteria.

Paola Barlow, PMP

Thanks so much Paul,

I'll try this one.

L_123

You could simplify this down to a single formula that could be made into a column formula and therefore applied to all cells in the column that's even smaller.

=count(parent())

Note: this will also check single lines that aren't children, which could be a positive or negative.