A way to calculate hours over timeframes

Marc Carden
Marc Carden ✭✭✭
edited 08/04/21 in Formulas and Functions

I don't have a portfolio management software where I work, but I am still trying to do a little portfolio management.

I want to figure our hour estimates by month for different resources. For example in my attached picture, i want to see how many hours IT will work on projects per month. Is there someway to automatically look at the requested start and end date of a project, then how many hours IT has, and divide it by month into the requested timeframe? The goal is to know how many hours each department is working on projects by month. Then combine all the estimates to say for example, that in January, IT is committed to 100 hours of project work.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!