Counting Parent rows AND rows without children

Dan Kadushin

So I'm working on collecting metrics from a projects page. Most projects exist on their own row with no indented children lines. However a few of the projects have sub-projects associated with them, but I don't want to count the metrics associated with the sub-projects. I can't seem to find how to count both the parent rows and the rows without children. Anyone have any ideas?

Thanks in advance!

Darren Mullen

Dan,

I have the same in my sheet, I only count Parent rows. The most straightforward way is to have a checkbox column named "Parent" or similar and then if the row is a Parent, have it checked, if not, leave it unchecked. Then you can use this column as a condition to only count metrics if the "Parent" column is checked.

The Parent checkbox can be checked manually or formulaically depending on your preference and application.

Darren Mullen

Dan,

I have the same in my sheet, I only count Parent rows. The most straightforward way is to have a checkbox column named "Parent" or similar and then if the row is a Parent, have it checked, if not, leave it unchecked. Then you can use this column as a condition to only count metrics if the "Parent" column is checked.

The Parent checkbox can be checked manually or formulaically depending on your preference and application.

Dan Kadushin

Ahh, that's an interesting work-around. Thanks for the advice!

Dan Kadushin

For anyone else running into this, here's the formula I ended up using in the Parent check box column:

=IF(COUNT(PARENT([Task Name]@row)) > 0, 0, 1)