Free · Works in FLYNT Sheets

Project Tracker Template

A task tracker for a small project — who owns what, what state it's in, when it's due, and how far along it is — with overall progress calculated automatically from each task's individual progress.

Design mockups — Alex — In Progress60%
Client review — Jordan — Not Started0%
Development — Sam — Not Started0%
Launch — Alex — Not Started0%
Overall Progress15%

Green rows calculate automatically from the values above them — change any number in FLYNT Sheets and they update.

Who it's for

Small teams and freelancers running a project without dedicated project-management software — a client project, an internal initiative, or anything with more than a couple of moving parts.

Key features

  • One row per task — task name, owner, status, due date, and progress
  • Overall progress calculated automatically from every task's individual progress
  • Plain-text status column, so it matches whatever stages your team actually uses
  • Add or reorder tasks freely — it's a real spreadsheet, not a fixed board

How to use it

  1. Click "Use this template" to open it in FLYNT Sheets
  2. Replace the example tasks with your project's real tasks, owners, and due dates
  3. Update each task's progress as work happens
  4. Review the automatically calculated overall progress
  5. Add rows for new tasks as the project grows

What's included

  • A working task table with 4 example rows to start from
  • An overall-progress formula already wired up

Common use cases

  • Tracking a client project's tasks and deadlines in one place
  • A lightweight alternative to full project-management software for a small team
  • A weekly check-in tool — update progress, see the overall number move

Frequently asked questions

Is the project tracker template free?
Yes — it's available on FLYNT's free plan, no credit card required.
Can I change the status options?
Yes — status is a plain text column, not a fixed dropdown. Use whatever stages match how your team actually works.
Does this handle task dependencies or a Gantt-style timeline?
No — it's a straightforward task list with progress rollup, not a full scheduling tool. For dependency-heavy scheduling, dedicated project-management software is the better fit.