Weekly Time Sheet per Project - what to do with year end coming.

Julie Fleming

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?

Ramzi K

@Julie Fleming

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 K

@Julie Fleming

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

Julie Fleming

Thank you! That helped.