OnePager is the timeline tool that makes it easy to create Smartsheet status reports in just a few easy steps. Follow either set of instructions to get started:
1. Easy Method: Direct import of Smartsheet data
2. Legacy Method: Import of Smartsheet data through Excel
Direct Smartsheet Method
OnePager connects directly to Smartsheet and imports task and status information so that you can create a RAG report very quickly. Here's how:
-
Start with your project plan in Smartsheet, where we have a handful of tasks, each with a status. Since this is a simple project, we'll plan to import all Smartsheet rows into our report, but if your project is larger or has multiple stakeholders collaborating, you can add a checkbox column that will filter which tasks should appear in your report:
-
From your desktop or Windows Start menu, launch OnePager:
-
When the OnePager start screen appears, click on New to start building a new RAG status report from Smartsheet:
-
On the import wizard, choose Select > BROWSE Smartsheet:
-
If you've never logged into Smartsheet from OnePager before, Smartsheet will ask you for your username and password:
After connecting, Smartsheet will ask you whether you want to Allow OnePager access to your Smartsheet account. Once you click Allow, OnePager will connect Smartsheet automatically going forward.
-
Next, choose the project that you want to import from Smartsheet and click OK:
-
Give your status report a name, and decide how you want to filter rows from Smartsheet. In our example, we're choosing to select everything since the project is pretty simple, but if you added a checkbox field, you can add it as a filter here. When you're ready, click Next:
The template we've selected here, Status (RAG) View for Smartsheet is pre-configured to assign colors based on the Status field in Smartsheet. If you decide to use your own template, we'll show you how to set up the color-coding in a few steps.
-
Double-check that the Smartsheet columns OnePager has selected are the ones that you want to use, then click Create new chart. OnePager will import the selected rows from your Smartsheet project, and create a chart that looks like this:
-
The chart above has been simplified a little, eliminiating swimlanes, which aren't necessary for smaller projects. It also makes use of OnePager's patented conditional formatting to assign colors to tasks based on their status. To review the default conditional formatting rules or make adjustments, go to Home > Chart Properties > Task Bars and click on the Manage Rules button:
That's it! If you're ready to try it for yourself, download a free trial and get started building RAG status reports from Smartsheet.
15-DayFree Trial
Excel Method
If you prefer to export your Smartsheet project to Excel, you can then import it into OnePager Express. Follow these instructions 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-DayFree Trial