Keep your Smartsheet sheets. Retire the roll-up sheet.

Smartsheet is fast because it works the way a spreadsheet works, and every PMO that runs on it eventually builds one more sheet: the roll-up. It breaks the moment someone inserts a column. PPM Express reads your sheets into an enterprise portfolio with capacity, financials and risk attached, so the roll-up stops being a sheet somebody maintains.

No migration, no template rollout, no cross-sheet formulas to repair — and no lock-in: Smartsheet sits alongside Jira, Azure DevOps, Microsoft Project, Planner and monday.com in the same portfolio.

PPM Express portfolio dashboard built from Azure DevOps data
Microsoft logo
Customer logos: Microsoft and Bob Evans Farms
Customer logos: Evoqua Water Technologies and Fortescue
Customer logos: Evoqua Water Technologies and Fortescue
Customer logos: AHEAD and Hendrix Genetics
Customer logos: AHEAD and Hendrix Genetics
Customer logos: Sonesta and Green Thumb Industries
Customer logos: Sonesta and Green Thumb Industries
Customer logos: Nicolet National Bank and Messer
Customer logos: Nicolet National Bank and Messer
Customer logos: DHL and imec
Customer logos: DHL and imec

Smartsheet can hold a project. The portfolio is where it starts costing you.

Every sheet is its own design, which is what makes Smartsheet quick to adopt and impossible to add up. So somebody builds a roll-up sheet with cross-sheet formulas, and it works until a project manager inserts a column, renames a status or archives a sheet. Then the roll-up quietly reports the wrong number, and the person who built it becomes the only one who can fix it.

Every sheet is its own design

Columns, statuses and formulas are invented per sheet. Fifty sheets are fifty conventions, and no two of them answer the same question the same way.

The roll-up is a sheet too, and it breaks

Cross-sheet references and cell links hold the portfolio together until somebody inserts a column, renames a status or archives a sheet. The number keeps reporting, which is worse than breaking loudly.

A RAID log is not a capacity or cost engine

You can build a risk sheet and a budget sheet, and many PMOs have. What a sheet cannot do is calculate whether the people exist across every project at once, or compare investments on the same terms.

A portfolio layer that leaves every sheet as its owner built it

PPM Express reads Smartsheet work data only — sheets and rows with their owners, dates and status. No column is added, no formula is rewritten and no template is imposed on a project manager who already has one that works. Identity runs through Microsoft 365 or Okta SSO, so nobody manages another credential.

Supported

Smartsheet sheets and rows. Connect as many sheets as the portfolio needs and leave the rest to the teams that own them.

Never accessed

Your sheet structure. Nothing is written back, no column is created and no formula or cell link is touched by the connection.

Identity

Microsoft 365 or Okta SSO, with central user management and granular permissions.

The plan

Three steps, and none of them change how your teams work.

1. Connect the sheets that represent real projects

Smartsheet multiplies quickly — every project, every request log, every tracker. Choose the sheets that represent funded work and leave the rest alone. Connecting takes minutes and changes nothing your teams see.

2. Replace the roll-up sheet with a real portfolio

Map each connected sheet to a project inside a portfolio or program, and attach what a sheet cannot calculate: budget and forecast, benefits, strategic score, risks and issues, and the people who have to deliver it. No cross-sheet formula holds it together, so nothing breaks when a column moves.

3. Run the portfolio without changing how anyone works

Prioritise, fund and sequence in PPM Express, and test the result against the capacity you actually have. Your project managers carry on in Smartsheet and never see the machinery above them.

Leadership sees a portfolio, not a folder of sheets

Connected sheets become projects inside portfolios and programs, described in the same terms whoever built them. Every project carries its status, timeline, budget, capacity and risk in the same row, so a portfolio review reads as one table rather than a folder somebody has to open sheet by sheet.

One structure above many sheet designs

Portfolios, programs and projects above sheets that never agreed on a column name.

One row per initiative

Status, dates, budget, forecast, benefits, capacity and risk, lined up so initiatives can be compared rather than described.

Access for people who should not need a licence

Read-only access for executives, sponsors and finance partners — without licensing each of them in Smartsheet to look at sheets they will never edit.

Progress rolls up without a single formula

Progress is read from the rows your project managers are already updating: owner, dates and status. No cell links, no cross-sheet references and nothing to repair when a sheet is restructured.

Accurate without maintenance

The roll-up reflects what the sheets say now, and nobody has to own the formulas that used to make that true.

You are told when something moves

If dates or completion change after you have built an analysis, PPM Express shows exactly what changed and asks whether to take it, instead of absorbing it silently.

Status reports written from the data

AI-written summaries drawn from live plan data, so project leads stop writing updates about work the system can already see.

PPM Express project dashboard rolling up progress, key dates and task status from the connected delivery tool

One timeline across sheets that never shared one

A sheet has a Gantt view of itself. What it cannot show is the dependency between your project and the one two folders away. PPM Express puts every connected sheet on one timeline with the dependencies and milestones between them, so the portfolio has a schedule even though each project manager plans their own way.

Every connected sheet on one timeline

Projects and tasks on a single Gantt, with dependencies drawn between work that lives in separate sheets.

Milestones with owners and dates

Milestones, owners and due dates in one place, updated once and reflected everywhere.

Roadmaps that survive re-planning

Built from live plan data, so when the work moves the roadmap moves with it instead of being redrawn.

The capacity, cost and risk engine a sheet cannot be

An assigned-to column tells you who owns a row, not whether that person is already committed on four other sheets. PPM Express adds resource capacity and utilization calculated across every connected project, budgets and forecasts against benefits, and a risk and issue register that rolls up — none of which a spreadsheet can hold honestly at portfolio scale.

Resource capacity and utilization

Allocate people to initiatives in hours or percentage FTE, and read the pool as a table or a histogram before anything is committed.

Budgets, forecasts and benefits

Cost and forecast per initiative, tracked against the benefit it was funded to deliver — the conversation Planner cannot have.

Risks and issues with an owner

A register per initiative, rolled up to the portfolio, so problems are visible before they are history.

Enterprise reporting across Smartsheet and everything else

Work managed in Smartsheet is reported next to everything else the enterprise delivers. Where other teams run Jira, Azure DevOps, Microsoft Project, Planner or monday.com, those roll into the same portfolio and the same reports — nobody migrates, and no team is told to abandon the tool that suits it.

200+ Power BI reports

Portfolio and project health, risks, issues, costs and capacity, ready to use rather than waiting to be built.

One portfolio across six tool families

Smartsheet alongside Jira, Azure DevOps, Microsoft Project, Planner and monday.com.

Decision-ready dashboards

For executives, sponsors and external stakeholders — the same numbers, without a rebuild for each audience.

Simple to connect. No formulas to maintain. Nothing to lock you in.

The usual way to get portfolio reporting out of Smartsheet is to standardise every sheet on a template and link them together. It works until people edit their sheets, which they will. PPM Express reads the sheets as they are, builds the comparable layer above them, and if a team later moves to Jira or Microsoft Project, the portfolio does not change — only the connection behind it does.

One-way: Smartsheet into the portfolio

Sheets and rows are read into PPM Express and nothing is written back. Smartsheet stays the single source of truth for the work, and the portfolio layer observes rather than intervenes — which is also the shortest path through a security review.

Nothing changes inside Smartsheet

No new column, no cell link, no template forced on a project manager who already has one that works. If you disconnect tomorrow, every sheet is exactly as you left it.

You choose which sheets join the portfolio

Not every sheet is a project. Promote the ones that represent funded work and leave request logs, trackers and personal sheets where they are.

What the connection uses

Sheet data only: sheets and rows with their owners, dates and status. Nothing is written back to Smartsheet, and no column, formula or cell link is altered by the connection.

Security & Trust

PPM Express security overview: EU and US data residency, GDPR and CCPA compliance, SSO and SAML with Okta, audit logs, data isolation, encryption at rest and in transit, and role-based access control

Enterprise-grade security. And it only ever reads your sheets.

PPM Express reads Smartsheet work data only — sheets and rows with their owners, dates and status. Nothing is written back, and no column, formula or cell link is altered by the connection.

We offer US and EU data residency, full GDPR compliance, and custom DPAs to meet strict regulatory requirements. Need app availability in your region or country to meet data residency requirements? We can provide.

Microsoft 365 and Okta SSO ensure secure identity management, while centralized user management, advanced permissions, detailed audit logs and strict data isolation protect sensitive enterprise data.
Try PPM Express in Action
Arrow Right Icon

Light tools for the teams. Enterprise governance for the portfolio.

Enterprises rarely run on one tool, and they should not have to. PPM Express lets Smartsheet stay what your project managers chose it for — fast, familiar, spreadsheet-shaped project management — while the portfolio above it carries programs, capacity, financials, risk and reporting at enterprise scale.

No migration project, no retraining, no vendor lock-in — and no argument with the teams about giving up a tool that works for them.

Keep the sheets your PMs built

Adoption is the hardest part of any PPM rollout. Nobody has to be persuaded to give up a sheet they designed themselves.

Gain what Planner never offered

Portfolio and program management, resource capacity, financials, benefits, risks and issues, and reporting that does not depend on anyone maintaining a formula.

Stay free to change your mind

If a team outgrows Smartsheet and moves to Jira or Microsoft Project, the portfolio stays put. Only the connection behind it changes.

What changes in the first quarter

Before

The portfolio depends on one person’s formulas

Cross-sheet links hold the roll-up together, and only the person who built them knows why it broke.

Capacity, cost and risk live nowhere

Availability is guessed, budgets sit in a finance spreadsheet, and risks are recorded in a sheet nobody rolls up.

Standardisation is the only proposed fix

Every attempt starts with a template rollout and ends when project managers edit their sheets again.

After

The roll-up sheet is retired

Leadership reads the portfolio directly, and the monthly assembly job disappears.

Capacity, cost and risk have a home

Availability is calculated, budgets and benefits are tracked per initiative, and risks have an owner and a date.

Nobody leaves Smartsheet

The only people who need a PPM Express account are the ones asking portfolio questions: the PMO, sponsors, finance partners and leadership. Project managers stay in their sheets.

Learn More

Last updated 20 August 2026

What Smartsheet teams ask before connecting

Frequently asked questions

PPM for Smartsheet, answered.

Can Smartsheet be used for portfolio management?

Up to a point, and usually by building a roll-up sheet. Smartsheet is excellent at an individual project, but a portfolio assembled from cross-sheet formulas breaks whenever a sheet is restructured, and it still cannot calculate capacity across projects or compare investments on common terms. PPM Express provides that layer while the sheets stay where they are.

Do we have to standardise our sheets on a template?

No, and that is the point. Sheets keep their own columns and formulas. PPM Express reads the sheets you choose to connect and maps each one to a project in the portfolio, so the comparable layer is created above the sheets instead of imposed on the people who own them.

Is the Smartsheet integration one-way or two-way?

One-way. Sheets and rows are read into PPM Express and nothing is written back to Smartsheet. Your sheets stay the single source of truth for the work, which keeps the connection simple to approve and impossible to disrupt.

Does this lock us into one tool?

The opposite. The portfolio layer is deliberately separate from the tool the work sits in, so different teams can use different tools and a team that outgrows Smartsheet can move to Jira, Azure DevOps, Microsoft Project, Planner or monday.com without the portfolio being rebuilt. Only the connection behind it changes.

What happens to our existing roll-up sheet?

You can retire it. The portfolio view is generated from the connected sheets themselves, so there are no cross-sheet references to maintain and nothing to repair when a project manager inserts a column or archives a sheet. Most PMOs keep the old roll-up running for a cycle, compare the two, and then stop updating it.

What Smartsheet data does PPM Express use?

Sheet data only: sheets and rows with their owners, dates and status. Nothing is written back, and no column, formula or cell link is changed. Identity runs through Microsoft 365 or Okta SSO.

Some teams use Smartsheet and others use Jira or Microsoft Project. Does that work?

That is the normal case, and it is a common reason enterprises adopt PPM Express. Smartsheet, Jira, Azure DevOps, Microsoft Project, Planner and monday.com are all supported connections and roll into one portfolio. No group of teams migrates, and nobody maintains a sync layer between tools purely to produce a leadership report.

Do our teams have to learn PPM Express?

No. Project managers stay in their sheets and never open PPM Express. Accounts are for the people asking portfolio questions: the PMO, sponsors, finance partners and leadership. A portfolio tool that makes delivery teams maintain a second set of records is a portfolio tool holding stale data by the end of the quarter.

We have hundreds of sheets. How do we stop the portfolio filling with noise?

You decide which sheets are promoted into the portfolio. Request logs, trackers and personal sheets stay where they are; the ones that represent funded projects are connected and given an owner, a budget and a place in a program.

Does this work at enterprise scale?

Yes. PPM Express is used by enterprises running hundreds of projects across multiple portfolios, with delivery spread across Smartsheet and other tools. Leadership works from live progress, capacity, cost and risk, with reporting automated across every portfolio rather than assembled for each review.

Our sheets say one thing and the roll-up says another. Why?

Usually because a cross-sheet reference is pointing at a column that moved, a row that was deleted or a sheet that was archived. The link keeps returning a value, so nobody notices. Reading the portfolio directly from the sheets removes that failure mode entirely, and when something changes upstream after you have built an analysis, PPM Express tells you what moved rather than absorbing it silently.

Related

Sheets in one division, boards in another — both roll into the same portfolio. monday.com portfolio management

Detailed schedules in Microsoft Project, reporting into the same portfolio. Microsoft Project portfolio management

Capacity across every sheet and every schedule, calculated in one place. Resource capacity planning and utilization

Every system PPM Express connects to, and what each connection reads. All PPM Express integrations

Hosting, identity, permissions, and the data PPM Express never touches. Security and trust

Our Trial process is Fast and Simple as 1-2-3:

Step 01/
Discovery

Quick, 15-20 minutes call to understand your objectives, requirements, expectations.

Step 02/Demo

Personalized, 60-minutes demo of PPM Express to show how it can support your use cases.

Step 03/Trial / Pilot

30-day long, supervised FREE Trial / Pilot to experience PPM Express firsthand. + Free Onboarding
The PPM Express trial path in three steps: a short discovery call, a personalised demo, then a supervised 30-day pilot
What Our Clients Say
We implemented and used PPM Express as our Portfolio Management Platform. The reports and Dashboards provide valuable consolidated information at different levels, and the beauty of this is that it’s just connecting information we already have and getting all the possible value from it.
Paola Bobbio
Invatron Systems Corp.
Senior Project Manager
Arrow right
Arrow right
With PPM Express our customers have a clear view of what is my next key date and my next milestone, and with active automated alerts on key dates approaching we make them more aware continuously looking at what’s next.
Marc de Graaf
Head of PMO
100 hours Saved
per PM per year
250 Customers
use our software daily
EU & US residency
encrypted in transit and at rest, with SSO, audit logs and tenant isolation. No customer data used to train AI models.
100K+ Projects
managed on PPM Express Platform