Counting of hours

Tim Abernathy

To All,

 

   I am trying to build the Smartsheet as a service schedule. One of the may problems i have right now is trying to add up hours that the technician has worked. Im looking to count the number of hours thats been assigned and providing how many hours to date (Just for the week) that has been worked by the employee

Tomasz Giba - Fabmet

Something like this?

 

https://app.smartsheet.com/b/publish?EQBCT=9998f764738f474f9a435d7d2188b5d8

Jeremy Myers

One solution: build a calendar for the year, one day for each row, one sheet per tech, use the summary row above each week's days and use the <sum children> function to do the math - you can do additional math on columns inserted to the right (week total all hours, for example) .  Conditional formatting for day = toaday lights up purple.  (today is the date in the 2nd column).  You have avaialble two levels of row indents below any main row, so you can sum by week, month, year.

 

J. Craig Williams

I tried something similar to that in my previous life.

My problem was I was tracking projects by project code and project - worst case, I'd have 20 columns or more for me and my more swamped engineers.

I didn't try one sheet per though - maybe that would have helped.

 

Nice work Jeremy.

 

Craig

Jeremy Myers

The worst part is building the yearly calendar outline, but I just set aside an hour and bull through it.  I am using the <flag> to both pull together multiple sheets into a report and to limit the date span.  Everyone knows to flag the current month only, so no issues.  I still need to create a report that doubles as a client invoice - but that seems simple enough.

J. Craig Williams

Lots of people fail to realize how long any tool (like Smartsheet) takes to set up -- but once it is set up - saves time and energy later.

 

Craig