Beyond Smartsheet: when a spreadsheet stops being a plan

Let’s start with the honest part: Smartsheet is good at what it does. It’s flexible, familiar, quick to stand up, and genuinely collaborative — a spreadsheet that learned to track work. A huge number of teams run their projects on it and are perfectly happy. If that’s you and it’s working, this isn’t a cue to switch.

But there’s a moment — most PMOs hit it — when you stop tracking tasks and start being accountable for a portfolio. That’s where a grid, however clever, starts to strain. Not because the tool is bad, but because a spreadsheet is built for cells, and a portfolio is built from things cells don’t natively understand.

Where the grid hits its ceiling

• Earned value. A grid will happily hold a “% complete” column. What it won’t do is turn budget, baseline and actual cost into an honest CPI and SPI. You end up with columns that look like metrics but can be whatever the last editor typed.
• Capacity across projects. Each sheet is an island. The moment a person works across five of them, no single sheet can see their real load — so over-allocation hides in the gaps, and “why are we slow?” has no answer in the data.
• Governance. Change control, approvals, a living RAID log, baselines and variance — a spreadsheet can mimic these with enough columns and discipline, but it can’t enforce or audit them. “Who approved this, and against which baseline?” is a formula you’ll be maintaining forever.
• Roll-ups. Portfolio health across dozens of sheets becomes a fragile web of cross-sheet references and a “master” rollup that one person quietly babysits. It works right up until the day it doesn’t.

The tell

You don’t need a maturity model to know when you’ve crossed the line. You feel it. There’s a lattice of linked sheets nobody fully understands. A formula breaks and three reports go blank. Onboarding a new PM takes a week just to explain “how we’ve set it up.” The spreadsheet has stopped being a view of the work and become the work. At that point every hour you spend is overhead, not delivery.

What purpose-built PPM adds

A tool built for portfolios computes the things you were maintaining by hand. Earned value is derived from budget, progress, baseline and logged time — not typed into a cell. Capacity is read across every project at once, so over-allocation surfaces before it becomes a slip. Change control and baselines are first-class, with an audit trail instead of a column. And portfolio roll-ups just are, because the data lives in one model rather than fifty sheets stitched together.

So: keep it, or graduate?

Keep Smartsheet for what it’s great at — flexible, ad-hoc, collaborative tracking where a spreadsheet genuinely fits. Reach for a purpose-built PPM when you’re on the hook for the portfolio: real earned value, capacity you can defend, governance that holds up in an audit, and reporting leadership trusts. The spreadsheet got you here. It just isn’t the thing that scales you from here.