Row and Sum calculations for Capacity Management

So, until we get 10k feet, I am trying to figure out how much of our team's capacity is spent on projects or operations work.

In the sample below, I'd like to know how much time teams and sub teams spend on Projects, Operations, Enhancements, and Admin. There may be muliple project, operations, or enhancement rows.

I'm currently doing =SUM(CHILDREN())/number of team members on team for overall capacity by team, sub team


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!