Hi! Is there a way for me to pull only the parent details in my report without having the subtasks?

Rikap

Hello!

I am trying to create a report and pull only the parent task details- is there a way to do that? could you help me with a formula?

KPH

You could add a helper column (that you can hide and ignore) with a column formula that counts the number of children

=COUNT(CHILDREN())

Then in your report filter on only those where the count of children is greater than 0.

Rikap

Thank you - is there a way I can pull this to another report with the same formula linking the sheets?

KPH

I'm not sure I understand the question. The formula needs to go into the sheet (or sheets). You can use the result of the formula to filter your report.

In the report click on filter and set it up like this, where "New Column" is the column that contains the formula =COUNT(CHILDREN()).

This will include only the parent rows in the report.

Rikap

Thank you :)