Sum hours from multiple sheets based on date ranges

I'm looking to determine how many hours are assigned to specific stage for a given week. Goal being I have "X" number of man hours available for a given week and if I've assigned 300% of that this week but 25% of it next week I need to know I've got shift resources or tasks around.

I've got report that shows me all the tasks, hours, dates, etc. I just can't "sumifs" on a report.

TIA - Adam

Find more posts tagged with

Calendar View

Comments

Shaine Greenwood

Hi Adam,

To accomplish this, you'd need to cell link your values over to a single "master" sheet, then SUMIFs on that sheet. Details on cell linking in the Help Center.

Our Product team is working on cross-sheet formulas functionality so you can reference cells from another sheet in your formulas—we're targeting later this year for that functionality.

A. DuBose

This would be an extremely tedious and time consuming method and it wouldn't inevitably be immediately out of date. If I insert a new task on any given sheet then I have to then create a linked cell to the new task? Am I missing something? I'd think for forecasting hours required there would be a better method.