Count Child Row for Multiple Weeks

I have an activity sheet set up by weeks. Meaning the same rows/sections are duplicated multiple times throughout the sheet. As the user fills in the names of their "Appointments" , what formula can I use to count that throughout the sheet?

image.png

Hope that makes sense. Maybe I just need to know how to capture child rows that are not blank?

Answers

  • Hi @TSP ,

    If you create a new "Totals" column (Text/Number type), then you could create a formula that counts all the child rows under the parent row for "Appointments", like so:

    =COUNT((CHILDREN([Task Name]@row)))

    The COUNT function will already only count rows that are not blank.


    Screen Shot 2020-01-22 at 6.23.35 PM.png


    If you have multiple sections of Appointments in your sheet, and you have this formula next to each of those rows, you could then create a SUMIF formula in a Sheet Summary field to Sum all of these entries together, like so:

    =SUMIF([Task Name]:[Task Name], ="Appointments", Totals:Totals)

    Screen Shot 2020-01-22 at 6.25.51 PM.png


    Let me know if this would work for what you're looking to do!

    Cheers,

    Genevieve

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions