Formula to Count Children

I have a column with quite a few children, for example:

parent

Children

Children 1

I'm trying to create a formula to count the number of children under the main parent that has "File Loaded". I was looking at the sheet formula examples but could not figure out a solution. I tried =COUNTIF(CHILDREN (CHILDREN ([TASK NAME]:[TASK NAME],"File Loaded")) but was getting #UNPARESABLE.

I am a 3-6month user of Smartsheets so I am still learning. I appreciate any feedback.

Thanks

Reggie

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Reggie Andaya

I hope you're well and safe!

You'd use DESCENDANTS instead of CHILDREN.

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Reggie Andaya

hi Andree,

I attempted your suggestion but was still getting #UNPARSEABLE.

Here is what I tried - =COUNTIF (CHILDREN (DESCENDANTS([Task Name]:[Task Name],"File Loaded"))

Andrée Starå

@Reggie Andaya

Try this.

=COUNTIF(DESCENDANTS([Task Name]:[Task Name],"File Loaded")

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Reggie Andaya

@Andrée Starå

Unfortunately still didn't work for me as I'm still seeing #unparseable. Just to visually show you what I'm trying to get to, the count of "File Loaded".

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.