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
Answers
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!