Count If Children

Tony Barthelemy · 08/09/19

Good Day All:

I am trying to count the Children and grandchildren in my Status Column that meet a specific criteria. Currently its counting the parent and grandparent in that column

Current formula: =COUNTIF(Status:Status, "Ahead")

Thanks

Andrée Starå · 08/10/19

Hi Kam,

Have you tried the new DESCENDANTS function?

More info: https://help.smartsheet.com/function/descendants

Try this.

=COUNTIF(DESCENDANTS(), "Ahead")

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Tony Barthelemy · 08/10/19

That worked, thanks!

=COUNTIF(DESCENDANTS(Status1), "Complete")

Andrée Starå · 08/10/19

Ok.

Can you maybe share the sheet(s) or some more screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Tony Barthelemy · 08/10/19

I found the error and it worked perfectly.

Thanks

Andrée Starå · 08/10/19

Excellent!

Happy to help!

Count If Children

Comments

Help Article Resources

Categories