Why track employee time per project?
Most HR departments and small business owners have the challenge of tracking employee time per task. However, this mission is critical in order to allocate costs to tasks and budget for future projects. Us at Sheetgo love automation and connecting spreadsheets. We develop real solutions that we use in our business, and then we share them with you. So you use our tools as effectively as possible. We have created an easy-to-implement, customizable timesheet template that allows you to track the hours and progress on tasks of multiple employees.
Let’s get you started
Step 1: Install the timesheet template
It is requested to sign in with your Google account and after authorizing a few steps, your Sheetgo account is also automatically created. Consequently, you are redirected to the Sheetgo web app from which you can easily install the timesheet template for Google Sheets.
Step 2. Open all spreadsheets
Start using the template by clicking the spreadsheet icons. The different timesheets are stored in the “Colleagues” folder and consolidated into the master spreadsheet “Timesheet management”, as you can see on the Network View below.
Step 3: Share the timesheets with your colleagues
You can find the master sheet “Timesheet Management” and 3 “Colleague #” spreadsheets. Access this folder in your Google Drive Folder >
The “Timesheet Report” tab is the tab where each colleague registers all the work done per project and task. The data in the master spreadsheet automatically generates the project and task names meaning that each colleague should align with the manager whether or not their tasks and projects are up-to-date.
Step 4: Input Projects and Tasks
Open the Manager Sheet “Timesheet Management”. This template consists of an Instructions tab, a tab to fill out all the Projects and Tasks, and the Timesheet Report coming from the separate Colleague spreadsheets. Above all, it creates a dashboard that gives you a clear overview of the hours worked on each task and per colleague. To start, fill out the “Projects and Tasks” tab. This data then simultaneously populates into the colleagues’ spreadsheets. As a result, each colleague can choose their projects and tasks from a dropdown.
Step 5: Update the Timesheet Report and Dashboard
Further, we want to update the connection that consolidates each colleague’s Timesheet Report to the Timesheet Management spreadsheet. To do so, go to the
Step 6: Manager consults the timesheet dashboard
The manager now automatically receives the Timesheet Reports of all colleagues. On the dashboard, he can therefore easily consult the projects and tasks per colleague, how far in the process they are and how much time it takes.
That’s it! You’ve now set up your timesheet template in Google Sheets. This template allows you to assign projects to collaborators and collaborators report their daily hours to you. The system is now yours. Feel free to customize it as you see necessary.