Free Project Tracker for Project Managers — AI-Built

Ask a project manager where Friday afternoon went and the answer is always the same: status reports. Five projects, five formats, five stakeholder groups — each wanting the same information arranged slightly differently, and each pinging you on Tuesday anyway because the report is "probably out of date."

The enterprise fix is a PPM platform, which means a procurement cycle, an IT ticket, a license true-up, and — six months later — a tool so heavy you keep your real tracking in a spreadsheet anyway. The lightweight fix is Asana or Monday at ten dollars a seat, except now your five projects live on five separate boards and the cross-project view you actually need sits behind a higher tier.

Here's the version that costs nothing and requires nobody's approval: one spreadsheet holding every project, with AI building the roll-up, the blocker flags, and an always-current status page on top of it.

Step 1: Start With One Sheet for All Projects

Resist the one-tab-per-project instinct. A single table with a Project column is what makes a portfolio view possible:

The Blocker/Risk column is your RAID log in miniature — free text, but any text at all means attention required.

Step 2: Create the Free Account

Sign up at lovespreadsheets.com. It's free to build and operate the tracker; paid options — logins for team members, hosting on your own domain — can wait until stakeholders start asking about access.

Step 3: Explain Your Portfolio

Choose the Project Tracker template and describe how you actually manage:

• "Every task belongs to a Project and a Workstream; Project is the top-level grouping everywhere."
• "If Blocker/Risk has anything in it, treat the task as red regardless of its status."
• "% complete is the owner's estimate, refreshed weekly. A due date slipping more than a week needs a reason in the row."

Then make the three requests that give you your Fridays back:

• A portfolio roll-up — every project on one screen with its status mix, average % complete, and a count of open blockers
• Blocker flags — flagged tasks surfaced at the top and filterable, with an email nudge when a blocked task blows past its due date
• An auto-updating status page — a view-only link per project, plus one for the whole portfolio, that stakeholders check instead of emailing you

AI Optimize will tighten a rambling description, the AI may come back asking how workstreams nest, and the build finishes in the 15-to-20-minute range.

Step 4: "Where Are We?" Becomes a Link

You get a web app with the portfolio up top and each project one click deep. Owners update their own tasks in the app; the sheet underneath records every change, and edits you make directly in the sheet flow back up instantly. That two-way sync matters more than it sounds: task owners get a clean interface they'll actually use, while you keep working in the grid you're fastest in, and neither side ever waits on the other for the latest numbers.

When a stakeholder asks for status, you send a URL once — after that, they stop asking. The blocker list doubles as your steering-meeting agenda, already sorted by what's on fire.

The Friday report doesn't get faster. It disappears.

Why Project Managers Keep the Sheet

No procurement, no IT ticket. It's your existing Google Sheet plus a free account — nothing to install, nobody to convince, no license to justify at renewal time.

The portfolio view is native, not premium. Because all five projects share one table, rolling them up is just a grouping — not an enterprise-tier feature you have to budget for.

Your methodology fits. Waterfall milestones, agile-ish sprints, or the pragmatic hybrid every working PM actually runs — the columns are yours, so the tool argues with nobody.

Common Questions from Project Managers

Can stakeholders break anything? No — their links are view-only. Editing stays with you and the task owners.

Where do risks and issues live? In Blocker/Risk to start. Add separate Risk and Mitigation columns whenever RAID-lite stops being enough, and ask for them to be flagged the same way.

What do I do with a finished project? Give its tasks a Closed status or move them to an archive tab. The roll-up filters it out while the sheet keeps full history for lessons-learned.

Build Yours

Consolidate your projects into one sheet this afternoon, hand it to lovespreadsheets.com, and describe how you run them. By the end of the week you'll have a portfolio dashboard, flagged blockers, and a status page doing your reporting — and Friday will finally belong to you.