How to include Count Collect formula with Parent Row Count Formula?

Andrew Watts

Hey there,

I'm trying to add a 'Count Parent and other rows' formula to my existing count collect formula. See existing formula below.

=COUNT(COLLECT({Row ID}, {Category}, $Label@row))

It is counting specific fields from the intake sheet and placing in a newly created sheet. To update it I want to exclude child rows from the count.

Can anyone help me to do this?

Thanks

Michael Culley

I would make a parent column with this formula:

=IF(COUNT(CHILDREN([row ID]@row)) >= 1, 1, 0)

Then use that in your collect formula

Michael Culley

Then do this:

=COUNT(COLLECT({Row ID}, {Category}, $Label@row,{parentrow},1))

Andrew Watts

Hey Michael,

Thanks for helping out! All is working!

Would it be possible to add to the first formula so it also counts rows without child rows automatically?

Thanks

Andrew Watts

Hey @Michael Culley. Just wondering if you saw my last message?

Thanks for the help.