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!
Tags:
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!