Running job to date hours on a project per task code?

Options

How can I have a running total of Job hours to date per task code display on a sheet that shows actual hours vs estimated hours?

The problem I am running into is: I have a weekly time sheet that is filled out for the employees on a particular project. The time has to be separated out by Straight Time, Over Time, Double time, and Quantity for each different Task Code on the project.

Where I am struggling to find a solution is when a week goes by, a new sheet is created for the next weeks hours, but I want to keep a running total of hours from the previous weeks time sheet. I want that running total for the number of hours and the running total of number of hours per task code to be displayed on a separate sheet. I would like to have formulas trace the number of hours from the time card sheets and funnel all the different hours to the Job to Date hours sheet. The first image is the time sheet example and the second it the sheet I want to see the total job to date hours per task code in.


Answers

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    Options

    The only way I can think of is to set up an automation on the weekly sheet to move it to a combined sheet of all the data. Otherwise you will have to constantly update and expand your formula every week.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!