Count If Children

Tony Barthelemy

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å

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

That worked, thanks!

 

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

Andrée Starå

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

I found the error and it worked perfectly.

Thanks

 

Andrée Starå

Excellent!

Happy to help!