We’re excited to announce that beginning with OnePager version 7.1, specifically the OnePager Bundle edition, we now support a direct connection to Smartsheet. If you’re a long-time OnePager user and are thinking of switching to Smartsheet, now you can. If you’re already using Smartsheet and have been making do with an Excel export, you now have a much more streamlined path.
Watch this short video to see how easy we make it to connect OnePager to Smartsheet:
When creating a schedule in an Excel spreadsheet, you will have a Start date and Finish date. But there is also a time associated with those dates, and if you don’t set it, your tasks may appear to finish earlier than expected. In the example below, both tasks finish on the seventh day, but the blue task finishes at 12:00 a.m. and the red task finishes at 11:59 p.m., almost a full day later. Paying attention to the times associated with your dates in Excel will help you ensure that a task is scheduled correctly.
This blog will go over an addition to make to the formula in your Excel spreadsheet to change the time of your task Finish date.
OnePager’s baseline display is a great way to compare your original project plan to the way things are now. But what if you want to only show baselines where there has actually been a change in the underlying schedule? This blog article will show you how to conditionally display Baseline Markers when there is variance between Start/Finish and Baseline Start/Baseline Finish.
To display Baseline Markers conditionally, we first need to have our data set up correctly in our Microsoft Project file. We assume you already have a Task Name with Start/Finish dates. You will also need to have Baseline Start and Baseline Finish entries.
With a Gantt chart, you can display Start/Finish dates that show exactly when a task starts and finishes. However, in this blog, we will be creating a dateless chart to show a graphical representation of your schedule without any specific dates displayed.
We will start at the top of the chart with the Time Axis representing different tic units. In the example, we utilize the Month and Week units of the Time Axis.
In Microsoft Project, a field called Finish Variance shows how many days there are between the Finish and the Baseline Finish fields. Using this data can be helpful when trying to determine if your tasks are finishing on, before, or after their planned finish dates.
If you want to use the Finish Variance field in your OnePager Conditional Formatting Rules to show visually if your tasks are late, you’ll run into an issue: Microsoft Project treats Finish Variance as a string field instead of a number.
We are excited to announce that we’ll be releasing a beta of our new OnePager version 7.1 in the next few weeks. A lot of users have already reached out and asked to be a part of our beta program for version 7.1, but if this is the first that you’re hearing about it, there is still room for you to join.
The Estimated field in Microsoft Project lets you identify tasks for which dates aren’t yet set in stone:
Simply place a “Yes” next to tasks that are estimated, and leave everything else alone. If you want to make a distinction between estimated and firm tasks in your OnePager chart, you can do so with conditional formatting.
To launch conditional formatting, go to Home > Chart Properties > TaskBars, and then click the Manage Rules button in the bottom. We’re starting out with some conditional formatting rules that assign different colors based on the Status field:
Click OK to close the Conditional FormattingRules screen, and then click OK again to close Chart Properties. Your chart will update so that all estimated tasks appear with a dotted black border, while still retaining their main colors that are based on status:
Those of you who are seasoned users of OnePager know that you can show deadline markers in your OnePager chart, which appear (hopefully) to the right of your main task bars:
Traditionally, deadline symbols don’t appear without their associated task, and even if they did, their formatting options are pretty limited, since they’re not something that is controlled by conditional formatting, or even really very easy to edit by hand.
Microsoft began releasing 64-bit versions of Office, including Project, back in 2010. Eleven years later, we still see that a lot of our users still haven’t switched from 32-bit Project to 64-bit Project, even though they’re continuing to upgrade their Microsoft Project versions from 2010 to 2016, then to 2019 and onward.
Believe it or not, 66% of OnePager Pro users are still using 32-bit Project. The vast majority of these 32-bit users are running a relatively modern version of Microsoft Project like Project 2016 or Project 2019. On top of that, almost all of these users are on 64-bit Windows 10.
You read that correctly: people who have a blazing-fast computer with the highest-powered version of Windows available are still running a lower-horsepower version of Microsoft Project. It’s a common misconception that if you have 64-bit Windows that you will automatically have 64-bit Project, but the reality is that most 64-bit Windows users are still on 32-bit Project.
A few weeks ago, we confirmed OnePager’s support for Office 2021 and Project 2021. Now, on the heels of that certification, we are pleased to announce that OnePager also supports Windows 11.
As you are probably aware, Microsoft announced the pre-release of Windows 11 in late June and begin shipping preview builds on June 28th. We immediately commenced our testing efforts to ensure that any of our users who take an early release of Windows 11 will be in good shape when it comes to OnePager.