Weekly Time Sheet per Project - what to do with year end coming.
We are rolling out "time sheets" for each employee that they will track their time per week per project. I used a template (although I can't remember which one) to setup the time sheet. What would be the best approach when starting a new year?
Give new sheets for 2021? Thus creating new roll-up reports for managers that will include all years? Add columns for the new year into existing sheet?
I also will need to create a reference table so that I can accurately report Q1, Q2, etc.... So changing the date from 1/6 to 1/6/2020. Right?
Best Answer
-
Since you are not tracking time by actual date, I would just add a year column. In the long run you may want to look at time year-over-year and it's much easier to have it all in one place.
However, keep in mind that the sheet row limit is currently 20,000 rows. So depending on how many employees you have, you may run into limits at some point.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
Since you are not tracking time by actual date, I would just add a year column. In the long run you may want to look at time year-over-year and it's much easier to have it all in one place.
However, keep in mind that the sheet row limit is currently 20,000 rows. So depending on how many employees you have, you may run into limits at some point.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Thank you! That helped.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives