OnePager Express is a timeline tool for Excel that makes it easy to create Smartsheet status reports in just a few easy steps. Simply export your Smartsheet plan to Excel and bring it into OnePager to get started.
Start with your project plan in Smartsheet. Here, we have a simple project with different statuses of Complete, In Progress, and Not Started for each task:
Right-click in your Smartsheet chart and choose the Insert Column Left option. We are going to insert an Auto-Number/System called Row ID:
Save your project, and Smartsheet will automatically number each task in your plan.
Your Smartsheet plan is now ready to be exported to Excel. In Smartsheet, go to File > Export > Export to Microsoft Excel:
Now it's time to bring your project plan into OnePager. Open the Excel file that you just created, go to the Add-Ins tab, and click the OnePager Express icon:
On the start screen, click NEW to start building a new status report. On the import wizard, give your chart a name, and ensure that you are importing all tasks from Excel/Smartsheet into OnePager. Click Next:
On the next screen, tell OnePager that you want to assign colors based on the Status field, and then click Create New Chart:
OnePager will import the tasks from your Smartsheet project and give you a status report like this, which colors are assigned based on the status of each task:
Here, each different status value gets its own color. The progress of each task, or percent complete, is also shown as a yellow progress bar.
If you'd like to change which colors assigns to each status, go to Home > Chart Properties > Task Bars > Manage Rules and customize the different colors that represent each status:
Click OK twice, and OnePager will update your chart to reflect the new colors that you assigned to each status, and will also update the legend to reflect those colors automatically:
This status report takes the status data from your Smartsheet project plan and automatically assigns color so that you can quickly identify which Smartsheet tasks are in good shape, and which ones are in trouble.
Get started today by downloading a free trial.15-Day