Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Sum hours from multiple sheets based on date ranges

A. DuBose
A. DuBose
edited 12/09/19 in Archived 2017 Posts

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



  • Shaine Greenwood
    Shaine Greenwood Employee
    edited 06/27/17

    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.

  • 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.



This discussion has been closed.