Counting children rows which matches a criteria

Sidnei · 11/22/21

I am trying to count all children rows in a task, which matches a criteria. For example count all subtasks of task ABC which are with Status = Pending. I tried the solutions already answered here in the community but none of them seem to do the trick. Thanks for any help.

Kelsey Hayden · 11/22/21

Hi Sidnei,

Thanks for reaching out! Here is an example of what that formula might look like: =COUNTIF(CHILDREN([email protected]), "Pending")

You'll want to use the COUNTIF function to count the number of cells in the range (Status column) that meet a criterion (e.g. "Pending"). More information on the COUNTIF function can be found here: https://help.smartsheet.com/function/countif

I've also included some screenshots below to show you how to set this up.

Screen Shot 2021-11-22 at 3.48.32 PM.png

Screen Shot 2021-11-22 at 3.48.42 PM.png

Hope this helps!

Kelsey Hayden · 11/22/21

Hi Sidnei,

Thanks for reaching out! Here is an example of what that formula might look like: =COUNTIF(CHILDREN([email protected]), "Pending")

You'll want to use the COUNTIF function to count the number of cells in the range (Status column) that meet a criterion (e.g. "Pending"). More information on the COUNTIF function can be found here: https://help.smartsheet.com/function/countif

I've also included some screenshots below to show you how to set this up.

Hope this helps!

Sidnei · 11/23/21

Hello @Kelsey Hayden , that worked nice. Thanks a lot. Any chance this could also be possible to do in the sheet summary? as in that way I would not need to create hidden columns. In any case your answer already helped me a lot. Have a good day!

Explore. Ask. Answer.

User Groups

Counting children rows which matches a criteria

Best Answer

Answers