Leave Parent Rows out of a Report

System

This discussion was created from comments split from: How do I change the columns on a task rollup report?.

Paul Newcome

@francisca.bacho If you only want the child rows, you would use something like this in a checkbox column:

=IF(COUNT(CHILDREN([Primary Column]@row)) = 0, 1)

Then include a filter in the report to only show rows that are checked.

francisca.bacho

Hi, Is there away to leave out the parent rows, since they are not really tasks?

Adam Costello

This is what I do:

Make a helper text column named "Levels" with a column formula :

=COUNT(ANCESTORS([Primary Column]@row))

This will tell you have many parents/ levels a row has. From there you can use this column to filter out different levels/parents and apply conditional formatting based on tier.

Genevieve P.

Hi @francisca.bacho

Just sending you an @mention to make sure you saw the response above 🙂

francisca.bacho

Thank you. I actually hadn't seen this message. Thanks @Adam Costello I'm still not to sure how that would work. In the example below, there are tasks and parent rows that have the same amount of parents, so how would I filter levels without filtering the tasks?

Thanks!

Paul Newcome

@francisca.bacho If you only want the child rows, you would use something like this in a checkbox column:

=IF(COUNT(CHILDREN([Primary Column]@row)) = 0, 1)

Then include a filter in the report to only show rows that are checked.

francisca.bacho

This worked great! Thanks

Paul Newcome

Happy to help. 👍️