Previously, we looked at how to use statistical functions with conditional formatting to determine which symbols should appear in a column when there is more than one task in a single row. Statistical functions aren’t limited to symbol columns, though. In fact, beginning in OnePager 7.2, you can use a similar set of statistical functions to drive the text that appears in a column as well. We call these Statistical Columns.
Let’s return to our earlier example where we have a project with multiple phases and several tasks in each phase:
Both of these examples used a Gantt chart layout with one task per row, making it very straightforward to determine which symbol to apply because each symbol only represents one task. When you have a timeline layout, there are multiple tasks in each row, and they all share a single symbol. In other words, your rules will need to look at all of the tasks in a row before assigning a symbol.
To illustrate this concept, let’s return to Harvey Balls. OnePager’s conditional formatting rules are already set up to assign a specific Harvey Ball based on a range of percent complete values. If you have multiple tasks in a single row, you can ensure that your rules have a Function that first computes the Average percent complete of all of the tasks before assigning the symbol:
In our most recent blog post covering the new features in OnePager 7.2, we looked at how to assign symbols in a column to track the status of individual activities. We’ll continue our look at symbol columns in this article with another very popular use case: using Harvey Ball symbols to represent percent complete.
Let’s begin with the same project that we used earlier, noting the different percent complete values for each task:
Last month, we announced the release of OnePager 7.2. In the coming weeks, our blog will explore many of the new features that are available in this latest version. We’ll kick things off by taking about Symbol Columns, which as the name implies, enable you to place symbols into columns instead of text, as you may have done in the past.
Symbol columns are driven by conditional formatting, meaning that you can write a handful of rules to automatically decide which symbols appear where and when. To get started, let’s assume that we have a basic Gantt chart like this:
This Gantt chart displays percent complete as a progress bar, and also color-codes the tasks based on their status. For example, green tasks are complete, while red tasks are late. We can use symbol columns to display both percent complete and status, either in addition to or in lieu of the formatting in the body of the chart itself.
We’re excited to announce the release of OnePager version 7.2 to the general public. We’d also like to extend special thanks to our Alpha and Beta testers who provided us with invaluable feedback over the last few months. OnePager is a better product because of you!
Our team has been hard at work on OnePager 7.2 and is pleased to announce it will be ready for broader testing before too long. A lot of users have already reached out and asked to be a part of our Alpha program for version 7.2. But if this is the first that you’re hearing about it, you can still join the Beta, which will be starting soon.
While there are hundreds of improvements between versions 7.1 and 7.2, these are the major enhancements that you will see across all three editions (Pro, Express, and Bundle) of OnePager:
Advanced Conditional Formatting of Tasks & Milestones: Conditional formatting now goes beyond colors and shapes. Now you can control the formatting of percent complete, baselines, and other decorations.
Conditional Formatting of Rows & Swimlanes: For the first time, the formatting of your swimlanes and rows can also be controlled by conditional formatting. Automatically color a row red when it contains late tasks, or set up a custom color scheme for the different phases of your project.
Stoplight Charts (Symbol Columns): Text columns can now be repurposed to display colorful symbols, again, all based on the data in your project plan.
Statistical Columns: Text columns can also summarize information about multiple tasks when they are grouped together into a timeline layout. Find the earliest start date or the average cost of all of the tasks in a single row.
Change Tracking: Visually compare two versions of the same project to determine when dates have slipped.
Presentation Mode: Present your live project without exporting to PowerPoint.
Time Cursor Upgrades: The time cursor can now be extended into the time axis, can include shading that follows it as time progresses, and can also feature a pointer at the top to make it more visible.
Visual Effects: New task bar styles can help your chart really pop.
In addition, we’re thrilled to offer integrations with four new PPM and CWM partners:
Planisware Enterprise (Available in OnePager Bundle)
Project for the Web (Available in OnePager Pro & OnePager Bundle)
Asana (Available in OnePager Bundle)
Wrike (Available in OnePager Bundle)
If one or more of these new features or new integrations sound exciting to you, then we’d love to have you as one of our 7.2 Beta testers. If you’d like to participate, please e-mail [email protected] and let us know which features or integrations you are most interested in. Based on your request, we’ll help you determine eligibility and next steps.