Way to tell a report to include the parent row info for child tasks?

Jessica Takata

I'm creating a report to display all tasks assigned to certain users, but it's difficult to tell what some of the child tasks are when divorced from their parent task. Is there an easy way to tell the report to also pull in the parent row info.?

Genevieve P.

Hi @Jessica T.

The way I would personally do this is to set up a "helper column" in the source sheet (which you can hide in the sheet if you don't need to see it).

This column would house a column formula to return the name of the Parent row, like so:

=PARENT([Task Name]@row)

Then when you create the Report you can include in this helper column to identify the row's parent task. You can even use this to Group the report, if you wanted!

Let me know if this will work for you.

Cheers,

Genevieve

Genevieve P.

Hi @Jessica T.

The way I would personally do this is to set up a "helper column" in the source sheet (which you can hide in the sheet if you don't need to see it).

This column would house a column formula to return the name of the Parent row, like so:

=PARENT([Task Name]@row)

Then when you create the Report you can include in this helper column to identify the row's parent task. You can even use this to Group the report, if you wanted!

Let me know if this will work for you.

Cheers,

Genevieve

Tessa B

Thank you so much, I saw similar advice but couldn't quite grasp it until I saw this! @Genevieve P.

Genevieve P.

No problem at all, @Tessa B! I'm glad I could help.