A SharePoint list is the quickest way to give a team somewhere to log their hours. This guide walks through building one, and what to plan for as your team grows. If you’d rather skip the setup, start from our free SharePoint timesheet template. It has the columns below already in place.
1. Decide what you need to track
Most teams need the person, the date, the project, the task and the hours. Add a billable flag if you invoice clients, and a notes column so people can explain unusual days. Keep it short at first. Every extra column is one more thing people skip.
2. Create the list
In your SharePoint site, select New, then List, then Blank list, and name it Timesheet. Add a Date column, a Number column for Hours, Choice columns for Project and Task, a Yes/No column for Billable, and a multi-line Notes column. SharePoint records who created each entry in Created By, so you don’t need a separate Employee column unless people log time for others.
3. Add views people will actually use
Create a My time view filtered on Created By equal to [Me]. Then create a manager’s view grouped by Created By, with a total on Hours. Add a filter on Date so it shows the current week.
4. Decide who can see whose time
By default, everyone who can open the list can read every entry. In the list’s advanced settings you can limit people to reading only the items they created. Managers then need to be site owners, or have their own access, to see the team’s time.
5. Add approvals
SharePoint has no built-in timesheet approval. Teams usually build a Power Automate flow that asks a manager to approve each submission and writes the result back to the list. Plan for the cases that need care: a rejected week, a week changed after approval, and a manager who changes teams.
When to use an app instead
A list is a good start. Once you need weekly submission, approvals that hold up, locked approved weeks and reports for payroll, the list and its flows become a small software project of their own. Timesheet for SharePoint gives you all of that on a SharePoint page, with the data still in your site. It has a free 30-day trial.