Finding the child rows of a parent row

shecodesit

We keep track of team projects on 1 smart sheet.  Projects are in parent rows. Task related to these projects are in children rows.  We also have ongoing tasks (newsletters, etc) that have a due date of 12/31/19.  

Here is the formula to determine the number of ongoing projects:  COUNTIFS({Project List Range 1}, "Project", {Project List Range 2}, DATE(2019, 12, 31)).  How could I use the Children function to find the number of tasks/child rows that have a due date with a particular month? 

Thanks!

Alejandra

Hey shecodesit!

To count the number of child rows with a due date in a particular month you'll want to try something like this:

=COUNTIF(CHILDREN([Due Date]1), MONTH(@cell) = 7)

Here are a few help center articles on the functions above:

• MONTH: https://help.smartsheet.com/function/month
• @cell: https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell
• CHILDREN: https://help.smartsheet.com/function/children