Counting children rows which matches a criteria

11/22/21
Accepted

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.

Best Answer

  • Kelsey HaydenKelsey Hayden Employee
    Answer ✓

    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!

Answers

  • Kelsey HaydenKelsey Hayden Employee
    Answer ✓

    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!

  • 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!

Sign In or Register to comment.