Import your Smartsheet project as a Swimlane slide

Follow

Overview 

Office Timeline Pro can import your Smartsheet plan into PowerPoint and automatically turn it into a beautiful Swimlane slide. To do this, you'll first need to tweak your sheet a little, like we did in this sample here:

smartsheet-sample-import-as-swimlane-office-timeline.png

Read on for a step-by-step guide on how to set up your Smartsheet plan and import it as a PowerPoint Swimlane.

 

Steps

  1. For classic Gantt charts and timelines, all Office Timeline needs from Smartsheet are the Task Name, Duration, Start and Finish columns. To import your project as a Swimlane, add an extra column in your sheet and name it – you guessed it – "Swimlane". It should be just a simple Text/Number column.

    add-swimlane-column-smartsheet.png

  2. Now enter the name of the Swimlanes you want your tasks or milestones to be placed in when importing the data. Items that have the same Swimlane name will be added to the same lane on the visual.

    add-swimlane-names-smartsheet-office-timeline-import.png
    Note: You can also make a mix between a Swimlane and a classic timeline. To keep items linked directly to the timeband like on a regular timeline or Gantt chart, just leave their corresponding Swimlane fields empty in your sheet.
    empty-swimlane-fields-for-timeband-items.png

  3. Once done, click Import on the Office Timeline ribbon in PowerPoint and connect to Smartsheet to bring in your data.import-from-smartsheet-into-office-timeline.png

    Quick tip: You can even import your Smartsheet project directly into a Swimlane template. To do so, go to New on the Office Timeline ribbon, choose a design you like, and then select Import.
    import-from-smartsheet-into-swimlane-template.png

  4. After you follow the simple steps in the Smartsheet Import Wizard, you'll get a presentation-ready Swimlane slide that you can easily style further or update as you please.simlane-made-from-smartsheet-data.png

 

Notes:

  • If you want to import milestones from Smartsheet, remember to make sure their duration is set to 0 days; otherwise, Office Timeline will import them as tasks by default.

  • You can also choose to import 1-day (or less) tasks as milestones. Click Settings on the Office Timeline Ribbon and then go the Import tab to activate this option.

 

 

Have more questions? Submit a request

Comments