PMO Pilot

Smartsheet to PowerPoint timeline with baselines and dependencies

Smartsheet exports look a lot like Project: Primary Column, Start Date, End Date, Predecessors, Assigned To, % Complete, Baseline Start and Baseline Finish. PMO Pilot reads all of them and draws a native PowerPoint timeline, so the monthly review slide stops being a screenshot.

Free Importing a file is in the free plan. Updating an existing slide from a new file is Pro.

A Plan vs Actual slide built in PowerPoint from a Smartsheet export
What the import looks like on the slide (the Plan vs Actual look). Every bar, label and arrow is a native PowerPoint shape.

From Smartsheet to the slide

  1. In Smartsheet, open the sheet (Gantt view is fine) and choose File → Export → Export to Microsoft Excel.
  2. In PowerPoint, open PMO Pilot → Create with AI → Upload Excel / CSV and pick the .xlsx (or copy the rows and paste).
  3. Check the review screen: parent rows without dates become swimlanes; predecessors by row number become arrows.
  4. Press Insert on slide.

Which columns PMO Pilot reads

Column in the Smartsheet exportOn the slide
Primary Column / Task Namethe bar's label
Start Date / End Datethe bar; one date becomes a milestone
Assigned To / Contactthe owner (email addresses become names)
Status / Healththe bar's color
% Completethe filled portion
Predecessors (3, 3FS+2d)dependency arrows
Baseline Start / Baseline Finishghost bars (plan vs actual)
Row ID / Row numberwhat predecessors refer to

No column mapping step: headers are matched by name, in any order, and the review screen shows exactly what was read before anything touches the slide.

Worth knowing

  • Hierarchy is read from parent rows: a parent with no dates groups its children as a swimlane.
  • Keep the export to the rows you want on the slide; a 300-row sheet is a report, not a slide.

Questions

Does PMO Pilot read Smartsheet's baseline?

Yes. Baseline Start and Baseline Finish columns become ghost bars behind each task, and a slip shows as the difference with a '+14d' label.

Can I go the other way?

Download CSV in the Edit tab writes the plan to a file Smartsheet can import.

Get PMO Pilot free