Google Sheets Project Tracker: Build One That Actually Works

You started with a clean spreadsheet. One tab, a few rows, maybe some color-coding. Then the projects multiplied. Deadlines started blurring together. Now you're opening five different files just to answer the question: what's actually due this week?

If that sounds familiar, you don't need a new tool — you need a better system inside the tool you already use. Here's how to build a Google Sheets project tracker that gives you real visibility into your work without becoming a maintenance burden.

---

Why Ad-Hoc Spreadsheets Break Down on Real Projects

The typical freelancer's first project tracker is a table they built in 20 minutes and kept patching ever since. A new column here, a color code there, a tab that somehow became the "real" one.

The problem isn't that Google Sheets is the wrong tool. It's that without a consistent structure, every project gets tracked differently. You start adding status notes in the wrong column. You stop updating because it takes too long. The whole thing becomes a liability instead of an asset.

A good project tracker has exactly one job: tell you, in under 30 seconds, what's happening across every project you're working on. Everything you add to it should serve that goal.

---

The 6 Columns Every Project Tracker Needs

Here's the minimum viable structure. These six columns give you everything without overwhelming you:

1. Project The name of the project. Keep it short — you're not writing a brief, you're labeling a row. "Website Redesign — Acme" is better than "Complete overhaul of Acme Co. website."

2. Client Especially important if you're juggling multiple clients. This column also lets you filter quickly when a client asks for a status update.

3. Status Use a fixed set of values: Not Started, In Progress, Waiting, Complete. Resist the urge to add more. When you have 8 status options, you spend more time deciding which one applies than actually updating the tracker.

4. Due Date One date per row — the final delivery date or the next hard deadline. If a project has multiple milestones, track those in a separate tab (more on that below).

5. Priority High, Medium, or Low. This is what you sort by when everything feels urgent.

6. Notes One cell for context. A link to the brief, a reminder to follow up, a blocker. Anything that helps you pick up where you left off.

That's it. Resist adding more columns until the six aren't working for you.

---

Making It Actually Usable: Views, Filters, and Formatting

A spreadsheet full of data is just a list. A good project tracker shows you what matters right now.

Filter by Status Use Google Sheets' built-in filter views (Data → Create a filter view) to create one view for "In Progress" projects and one for "Waiting" items. Switch between them with a click. You're not hiding data — you're focusing your attention.

Sort by Due Date Sort your main view by Due Date ascending so the most urgent projects always float to the top. When you open the tracker, the first thing you see is what's due next.

Conditional Formatting for Overdue Items This is the one that actually saves you. Select your Due Date column, then go to Format → Conditional formatting. Set a rule: if the date is less than =TODAY() and Status is not "Complete," highlight the row in red.

Set it up once and you'll never miss an overdue project again. When you open your tracker and see red rows, you know immediately where to focus.

---

Want a free Notion template instead? Grab our free Notion starter kit — includes a project tracker, weekly planner, and habit tracker — at notioncraft.madethis.app/free.

---

The Weekly Review Ritual (15 Minutes Every Friday)

A tracker is only as good as how often you update it. The trick is making updates a ritual, not an afterthought.

Every Friday afternoon, before you close your laptop, spend 15 minutes on this:

1. Scan every "In Progress" row. Is the status still accurate? Did anything move to "Complete" or get pushed to "Waiting"?
2. Update due dates. Did anything slip this week? Update the date and note why.
3. Check for overdue items. If something's been red for two weeks, it either needs immediate attention or needs to be renegotiated with the client.
4. Add next week's priorities. Anything starting next week should already be in the tracker with a status of "Not Started."

That's it. Fifteen minutes. When Monday morning hits, you open the tracker and you already know where to start.

---

Level Up: Linked Budget Tab and Milestone Tracker

Once your core tracker is solid, two additions make it significantly more powerful:

Linked Budget Tab Create a second tab called "Budget." For each project, add a row with the project name, agreed fee, expenses, and hours logged. In your main tracker, use VLOOKUP to pull the current budget status into a "Budget %" column. Now you can see at a glance which projects are on budget and which are creeping.

Milestone Tracker For larger projects with multiple deliverables, create a third tab called "Milestones." Add columns for Project, Milestone Name, Due Date, and Status. Link back to your main tracker with VLOOKUP so you can see how many milestones are complete per project.

This gives you a three-layer view: the summary (main tracker), the financial health (budget tab), and the delivery detail (milestones).

---

Get a Pre-Built Template — Ready in 5 Minutes

Building this from scratch takes a few hours and a lot of formula debugging. If you want to skip straight to a working system, our Monthly Budget Planner gives you a fully built Google Sheets setup that includes project tracking, budget management, and financial visibility — all in one clean spreadsheet.

Monthly Budget Planner (Google Sheets) — $19

A ready-to-use Google Sheets template for freelancers and small teams. Track projects, manage budgets, and stay on top of what you're owed — without building formulas from scratch.

Get the Monthly Budget Planner →

One-time purchase. Works in Google Sheets. Duplicate it and start using it today.