[email protected] +1.303.779.0344

Smartsheet Gantt Chart

Create a Gantt chart of your Smartsheet project plan in OnePager Express.

If you use Smartsheet for project management, you need a good way to visualize the key tasks and milestones in your project plan. OnePager Express can import your Smartsheet project plan through Excel, and create an easy-to-read Gantt chart like this:

Smartsheet Gantt chart created in OnePager Express.

This is a basic Gantt chart created from a very simple Smartsheet project plan as an quick example. If you need more powerful Gantt charts or timelines from Smartsheet that include swimlanes, color-coding, resource information, or multi-project reporting, the bottom of this article has links to those more advanced features.

OnePager Express takes an Excel export from Smartsheet to create Gantt charts of your Smartsheet project plan. If you don't already have OnePager, download a free trial and follow these simple steps:

  1. Start with your project plan in Smartsheet. For best results, it's a good idea to include Smartsheet's Row ID column in your Excel export. To do this, right-click on any existing Smartsheet column, and choose Insert Column Right:

    Insert a new column into Smartsheet

  2. On the Insert Column screen, select Auto-Number/System on the left and Auto-Number on the right:

    Insert the Row ID column as an Auto-Number in Smartsheet.

    Notice that the Name of this column is "Row ID". We recommend leaving this name as it is and not changing it.

  3. After clicking OK, you will see the Row ID in your Smartsheet project plan:

    Smartsheet Row ID.

    Notice that the Row ID is not the same as the row number. For example, row #5 is actually row ID #9. This is because Smartsheet keeps your Row IDs the same throughout the life of your project, so when you insert a new row in the middle of your project plan, the Row IDs aren't renumbered. This is good and helps ensure consistent reporting, so don't worry if your Row IDs are out of order, since they're supposed to be.

  4. We also want to add a filter column in Smartsheet so that you can decide which rows from your project plan you want to include in your OnePager Express Gantt chart, and which you don't. To add this column, right-click again on any existing column, and choose Insert Column Right again. This time, we'll insert a Checkbox column called "Add to OnePager":

    Insert a checkbox column into Smartsheet.

  5. Once the "Add to OnePager" column has been inserted, check the box for any rows that you want to include in your Gantt chart:

    Select the Smartsheet rows to include in your Gantt chart.

    In this case, we've chosen to select child rows and not parent rows, but you can select a mixture of both if you like.

  6. The final step in Smartsheet is to export the project plan to Excel. To do this, go to File > Export > Export to Microsoft Excel:
    Export Smartsheet to Microsoft Excel.
  7. Open your Excel file that you just exported from Smartsheet, go to Excel's Add-Ins tab, and click the OnePager Express button:

    Smartsheet Export in Excel.

    When OnePager's start screen appears, click NEW to build a new Gantt chart.

  8. On the import wizard, give your Gantt chart a name, filter your rows based on the Smartsheet checkbox field, and then click Next:

    Configure Smartsheet Gantt Chart in OnePager Express.

  9. This screen lets you decide which columns from Smartsheet you want to use in your OnePager gantt chart. Most of the time, OnePager will auto-detect the correct fields, but it's important to make sure that OnePager's Unique ID is mapped to Smartsheet's "Row ID". Once things look good, click Create New Project View to build your Gantt chart:
    Map Smartsheet columns into your OnePager Gantt chart.
  10. OnePager will import your Smartsheet data and give you a Gantt chart that looks like this:
    Smartsheet Gantt Chart created in OnePager Express.

Build your Smartsheet Gantt chart today by downloading a free trial of OnePager Express.

Free Trial

Last Updated: July 22, 2019