Finding the child rows of a parent row

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!
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:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!