Finding the child rows of a parent row

shecodesit
shecodesit ✭✭
edited 12/09/19 in Formulas and Functions

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!

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!