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.

Counting of hours

Tim Abernathy
edited 12/09/19 in Archived 2016 Posts

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

Comments

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

     

    sum children.PNG

    sum children.PNG

  • J. Craig Williams
    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
    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
    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

This discussion has been closed.