Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
Something like this?
https://app.smartsheet.com/b/publish?EQBCT=9998f764738f474f9a435d7d2188b5d8
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.
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
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.
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.
