[email protected] +1 303 779 0344

Home How-To

Smartsheet Gantt Chart

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

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

Smartsheet Gantt chart created in OnePager Bundle. Smartsheet is a leading collaborative work management (CWM) platform.

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.

If the simple example above looks like a good starting point for your project, download a free trial and follow either of the two sets of instructions below to get started:

1. Easy Method: Direct import of Smartsheet data
2. Legacy Method: Import of Smartsheet data through Excel

Direct Smartsheet Method

OnePager can connect directly to Smartsheet and import the data from your project, making it easy to create a Gantt chart very quickly. Here's how:

  1. Start with your project plan in Smartsheet. We 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 Gantt chart, and which you don't. To add this column, right-click on any existing column, and choose Insert Column Right. We can create a Checkbox column called "Add to OnePager":

    Add a checkbox field to Smartsheet

  2. 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. Once you've finished selecting rows, don't forget to save your Smartsheet project.

  3. Now, go to your desktop or Windows Start menu, and launch OnePager:

    Launch OnePager from your desktop.

  4. When the OnePager start screen appears, click on New to start building a new Gantt chart from Smartsheet:

    OnePager start screen.

  5. On the import wizard, choose Select > BROWSE Smartsheet:

    Browse Smartsheet projects from OnePager.

  6. If you've never logged into Smartsheet from OnePager before, Smartsheet will ask you for your username and password:

    Log into Smartsheet from OnePager.

    After logging in, Smartsheet will ask you whether you want to Allow OnePager to access your Smartsheet data. Once you click Allow, OnePager should be able to log into Smartsheet automatically going forward so that you don't have to keep entering your username and password each time.

  7. Now, select the project that you want to import from Smartsheet and click OK:

    Import from Smartsheet into a OnePager Gantt chart.

  8. With your Smartsheet project selected, give your Gantt chart a name, and click Next:

    Name the Gantt Chart that you're about to create from Smartsheet.

  9. Double-check that the Smartsheet columns OnePager has selected are the ones that you want to use, then click Create new chart:

    Chose which columns from Smartsheet you want to use in your Gantt Chart.

    In this example, we chose the Assigned To field for color-coding, but you can use whichever field you like.

  10. OnePager will import the selected rows from your Smartsheet project, and create a chart that looks like this:

    Simple Gantt Chart created in OnePager from Smartsheet.

  11. From here, you can go to Home > Chart Properties to customize colors and layouts, maybe changing your task shapes, adjusting the font, and adding a shadow, like this:

    Smartsheet Gantt Chart created in OnePager Bundle.

It's that easy! Check out our advanced features to learn more about how OnePager works with Smartsheet, or download a free trial if you're ready to try it out yourself.

15-Day
Free Trial

Excel Method

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 Chart 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.

15-Day
Free Trial

Advanced Features

The following articles provide more information on how to utilize OnePager's more advanced features with Smartsheet:

Last Updated: June 20, 2024