Running job to date hours on a project per task code?
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!