Formula to Count Children

Reggie Andaya

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

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".