Count Children If



I am trying to create a formula to count the current providers I have in each office location. So I have a "Locations" column with each office location, and each office location have child rows that indicate a provider per row. I also have a column called "Start Date" that indicates when a provider has started with the company. I am trying to figure out a formula that would count the children rows of each office location IF the provider has already started (date in Start Date column is in the past from TODAY)

I'm issues with my syntax and nesting the conditions:

=COUNT(CHILDREN(Locations@row, IF([Start Date (Training)]@row, <TODAY())

Thank you in advance


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!