Business Ops

Project & Task Tracker

Everything your team is working on, in one place. No $15/seat project management software, no learning curve, no migration headache. Just projects, tasks, owners, due dates, and a view that shows each person exactly what they need to do today.

What's Inside

Projects — One row per project. Project name, owner, start and target end dates, status (Not Started / In Progress / On Hold / Complete), priority (High / Medium / Low), and overall completion percentage calculated from tasks. Your portfolio view.
Tasks — One row per task, linked to a project. Task name, assigned to, due date, status, priority, and notes. Dropdowns for status and priority keep the data clean. This is where the daily work lives.
My Tasks — A filtered view that shows only the current user's tasks, sorted by due date. Overdue items surface to the top. Each team member can look at this tab and know exactly what they need to focus on.
Dashboard — Projects by status, tasks due this week, overdue tasks count, team workload by assignee, completion trends over time, and a breakdown of tasks by priority. The manager's view.

Key Features

Project completion auto-calculated from task status — no manual updating
"My Tasks" filtered view gives each team member a personal to-do list
Overdue task highlighting makes missed deadlines impossible to ignore
Priority-based sorting so the most important work surfaces first
Team workload distribution shows who's overloaded at a glance
No per-seat pricing — share with your whole team for free

Sample Formulas

Here are some of the formulas powering this template:

Project completion from tasks

=COUNTIFS(Tasks!A:A,A2,Tasks!E:E,"Complete")/COUNTIF(Tasks!A:A,A2)

Overdue tasks for a team member

=COUNTIFS(C:C,H2,D:D,"<"&TODAY(),E:E,"<>Complete")

Tasks due this week

=COUNTIFS(D:D,">="&TODAY(),D:D,"<="&TODAY()+7,E:E,"<>Complete")

Get this template free

Enter your email and we'll give you instant access to copy this template into your Google Drive.

You're in.

Click below to copy this template into your Google Drive. Check your email for setup instructions.

Make a Copy

Need a custom project management system?

We build tailored project trackers with automated status updates, Slack notifications, and time tracking — all inside Google Sheets, no SaaS subscription required.

Start a build