Count Children Rows

I'm adding formulas to the sheet summary to count the rows per parent on a sheet. I have the below working:

=COUNT(CHILDREN(Region163))

=COUNT(CHILDREN(Region184))

However the number of rows under each parent may change and so I cant rely on row 163 or 184 being the parent rows. So I tried the below:

=COUNT(CHILDREN([Region], "Central"))

=COUNT(CHILDREN([Rows], "East"))

However these are not working…hoping someone can help with the above formula!

Thanks

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/141411/count-children-rows

Hi,

I hope you're well and safe!

You can select the Parent rows, and then the formula will automatically update as the parent row moves.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Angela Logie

Andree,

Thanks for your quick response. So I think then the 1st formula's above would work?

Thanks

Ang

Andrée Starå

https://community.smartsheet.com/discussion/comment/491153#Comment_491153

Happy to help!

Yes, it should work.

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Angela Logie

Perfect, thank you for your help…once again :)

Andrée Starå

https://community.smartsheet.com/discussion/comment/491254#Comment_491254

I'm always happy to help!

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.