How do I get a report to show both the parent row and child row for a task?

Sara Ross

I set up a report to show tasks completed, but only the child row is showing up. I would like the parent row to be included to provide more context. Do I need to change something on the sheet or report to implement this change and how?

Paul Newcome

I would suggest inserting a checkbox column and inserting this column formula:

=IF(COUNT(ANCESTORS(Status@row)) <> 0, IF(Status@row = "Complete", 1), IF(COUNTIFS(CHILDREN(Status@row), @cell = "Complete") > 0, 1))

This will check the box on child rows that are complete and on parent rows where at least one child row is complete. Then you can build you report to show rows where this column is checked.