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
Comments
-
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.
-
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.
-
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.
-
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
-
Thanks, I will try this setup.
-
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
-
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
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives