Count Total Children Rows of 1 Parent Row

JamesS · 03/12/25

I'm trying to create a sheet summary field that will hold a total count of Children under a specific Parent, regardless of the status of the child.

I've tried to use the following, but I get #UNPARSABLE:

=COUNT(CHILDREN([Parent])

I presume I need to somehow callout Key Tasks column, but I'm struggling.

Thanks, in advance for any assistance offered 😊

Paul Newcome · 03/12/25

Try

=COUNT(CHILDREN([Key Tasks]5))

Paul Newcome · 03/12/25

Where exactly are you putting this formula?

JamesS · 03/12/25

The Sheet Summary…. panel on the right of the sheet: (New Item, Text/Number)

Paul Newcome · 03/12/25

Try

=COUNT(CHILDREN([Key Tasks]5))

JamesS · 03/13/25

Works perfectly @Paul Newcome - Thank you 👍️

Paul Newcome · 03/13/25

Happy to help. 👍️

Best Answer