Row and Sum calculations for Capacity Management

Molly Sudmeier

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

Peter Harink

Hi Molly,

Maybe you could have a quick look at this link below to see some of our add on solutions. The 4th one is an advanced resource planning overview which might answer your needs. Please contact me if you like to know more about this.

https://app.smartsheet.com/b/publish?EQBCT=2369462e4ccd456e8e5ff521ad9506fe

Kind regards,

Peter Harink | 4EF.nl | Consultant & Managing Partner | peter.harink@4ef.nl