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:
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:
- 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:
- On the Insert Column screen, select Auto-Number/System on the left and Auto-Number on the right:
Notice that the Name of this column is "Row ID". We recommend leaving this name as it is and not changing it.
- After clicking OK, you will see the Row ID in your Smartsheet project plan:
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.
- 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":
- Once the "Add to OnePager" column has been inserted, check the box for any rows that you want 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.
- The final step in Smartsheet is to export the project plan to Excel. To do this, go to File > Export > Export to Microsoft Excel:
- Open your Excel file that you just exported from Smartsheet, go to Excel's Add-Ins tab, and click the OnePager Express button:
When OnePager's start screen appears, click NEW to build a new Gantt chart.
- On the import wizard, give your Gantt chart a name, filter your rows based on the Smartsheet checkbox field, and then click Next:
- 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:
- OnePager will import your Smartsheet data and give you a Gantt chart that looks like this:
Build your Smartsheet Gantt chart today by downloading a free trial of OnePager Express.15-Day
Last Updated: July 22, 2019