Follow the steps below to see how easy it is to build a project budget report in OnePager using your project data from Smartsheet. If you don’t already have OnePager, you can download a 15-day free trial to see how it works.
-
In Smartsheet, we have a project with a column for the budgeted cost, the actual cost, and the variance in cost between budget vs. actual:
-
Launch OnePager using the desktop icon:
-
On the Start screen, click NEW to start building a new OnePager chart from Smartsheet:
-
To connect OnePager to Smartsheet, go to Select > Browse Smartsheet
If you haven't connected to Smartsheet through OnePager in the past, Smartsheet will ask you to confirm your username and password.
-
Select the Smartsheet project that you want to import into OnePager, and click OK
If you haven't connected to Smartsheet through OnePager in the past, Smartsheet will ask you to confirm your username and password.
-
Give your report a name, and decide whether you want to select all of the rows from Smartsheet, or just a few.
In this example, our Smartsheet project is pretty small, so we will import all of the rows from Smartsheet. If your project is larger, you can use a checkbox field to decide which Smartsheet rows to include, and which to exclude.
-
Click Next and then Create New Chart. OnePager will import your project from Smartsheet and give you a Gantt chart that initially looks something like this:
-
Our next step is to show the three budget columns from Smartsheet in our report. To do this, go to Home > Chart Properties > Rows/Swimlanes. For each of the three cost columns, turn on a Text Column in OnePager and format it to show currency:
-
Click OK, and OnePager will import your cost information from Smartsheet so that it displays like this:
-
The final step is to use conditional formatting to color-code the chart so that tasks are red when over budget and green when under budget. To do this, go to Home > Chart Properties > Task Bars and click the Manage Rules button. Here, we've set up a few rules that look at the Cost Variance field as the basis for color in the Gantt chart:
When the task is over budget, we'll color it red. When the task is on or under budget, we'll color it green. We also have a rule that assigns a different font and bar size to parent rows from Smartsheet.
-
Once the conditional formatting rules are applied and legend turned on, the final budget report looks like this:
Get started today by downloading a free trial, complete with our world-class customer support.
15-DayFree Trial