Project Management Tracker (Pro) — Google Sheets + Excel with Auto Gantt, Task Health & Progress Rollup

Run every project and every task from one place — and see what's slipping before it does. A complete project management system for teams, agencies and freelancers: log tasks with owners, priorities and dates, watch a Gantt timeline draw itself, and let each task flag its own health. Works in Google Sheets and Excel.

6 connected tabs:

• Dashboard — total tasks, completed, overdue, % complete, due-this-week and blocked counts, tasks by status and workload by assignee, with charts.
• Tasks — one row per task; enter project, owner, priority, status, start & due dates and % done, and duration, days-left and a health flag (🔵 On track · 🟡 Due soon · 🔴 Overdue · ✅ Done) calculate automatically.
• Projects — per-project task counts, completed count and a live progress bar.
• Gantt — set one timeline-start date and conditional-formatting bars line up from each task's start and due dates across a 20-week view.

Statuses, priorities, assignees and projects are all editable on the Lists tab; the dropdowns follow. Every number is a live formula — health, progress and the Gantt recalculate the moment you change a date. Delivered as an .xlsx: open in Excel, or import to Google Sheets via File ▸ Import ▸ Replace spreadsheet.