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.

Time Sheet to keep track of time

Van Johnson
Van Johnson ✭
edited 12/09/19 in Archived 2015 Posts

I need to add a column for each task for the following purpose:

When I assign a technician a task I need to be able to track the amount of time (hours) they spent per day working on that task or if they did not on the assigned day.   Please send ideas.  

Tags:
· Share on FacebookShare on Twitter

Comments

  • Stephanie Q
    Stephanie Q ✭

    There are options when you create a new column and choose "Auto-Number/System" and then "Created (Date)" and also another column "Modified (Date)"

     

    The "Created Date" Column will time stamp with the exact time and day that the row was created. The "modified date" Column will keep a log of every single time the row has been modified, the time it was modified, and by who. 

     

    So far this is the best way I have been able to keep track of time. 

    · Share on FacebookShare on Twitter
  • Van Johnson
    Van Johnson ✭
    edited 07/01/15

    Thanks for the response.  I was looking more for a way to keep track of time on the task.  For example "worked on task July 1 for 4 hours". Sort of like a time sheet.  

    · Share on FacebookShare on Twitter
  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭
    edited 07/01/15

    Smartsheet is releasing the ability to set durations in hours/minutes/seconds in a couple weeks. Once this is available you will be able to show the time a user spent on a task/day. There is also a resource management feature which allows you to allocate users to tasks. It will allow you to see how they are allocated across all projects and sheets. 

     

     

    http://help.smartsheet.com/customer/portal/articles/1346969-resource-management-allocation-team-enterprise-only-

    · Share on FacebookShare on Twitter
  • Data Solution Consultant
    Data Solution Consultant ✭

    Let me know if following data represents your question.

     

    Sheet has columns

    Contributor Project          NumberOfHours DateOfWork           project

    John                                4                          Jun-1-2015             Project-A

    John                                1                         Jun-2-2015             Project-A

    Robert                             2                          Jun-1-2015             Project-A

    John                                3                          Jun-4-2015             Project-A

    John                                5                          Jun-5-2015             Project-A

    If you have sheet which logs the data like the above then reports can be used to find out

    e.g. John did not work on June-3-2015.

    With Reports you can also find out that John worked

    4 add 1 add 3 add 5 = 13 hours during Jun1-2014 - Jun-5-2015

     

    Thanks

    · Share on FacebookShare on Twitter
  • Van Johnson
    Van Johnson ✭

    Thanks, I will try this setup.

    · Share on FacebookShare on Twitter
  • Travis
    Travis Employee

    I am happy to announce the ability to set partial day duration (hours, minutes, and seconds) is here! Check out my announcement for more information and to ask questions: https://community.smartsheet.com/announcement/new-smartsheet-critical-path-and-duration-minutes-hours-and-weeks

    · Share on FacebookShare on Twitter
  • Abdul Khan
    Abdul Khan ✭

    I am using this feature of smartsheet in my tracker, I need help with issues in system columns.

     

    1. Modified - Date and time stamp for the row will fill all the rows below. I want only the row updated to get stamped not any rows below it which should remain blank. Is there a way I can achieve this.

     

    2. Modified By - Stamps with email id of the person updates for the row and all the rows below, as I have the issue with Date and time. Is it possible to have Name instead of email id and again to have all the rows below remain blank.

     

    Thanks

     

    · Share on FacebookShare on Twitter
  • Cadsolutions - Paul Johnson
    Cadsolutions - Paul Johnson ✭✭✭
    edited 07/14/16

    How to I schedule daily timesheet inputs into a new row daily on a sheet. I tried update requests but that over writes a row info, Webforms a re ideal but I cant see a way of scheduling a reminder to employees to use the webform, other than sending them a scheduled email reminder. 

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories