1

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!

Functionality

Comments

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: