What’s new in OnePager 7.2: Conditional Formatting of Swimlane and Text Column Colors

If you make use of OnePager’s swimlanes or text columns today, you know that you can use the paint bucket to manually adjust the background colors of individual cells, or to extend that striping horizontally across your entire chart.

Beginning in OnePager 7.2, you can now use conditional formatting to dynamically control the background colors in your chart, including:

  • An entire swimlane
  • Only the swimlane cell on the left
  • An entire row
  • Only the text column cell on the left
Continue reading

What’s new in OnePager 7.2: Statistical Columns

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:

Continue reading

What’s new in OnePager 7.2: Symbol Columns in a Timeline Layout

In our two most recent posts, we’ve been looking at symbol columns, which are one of the new capabilities of OnePager 7.2. Specifically, we learned how to assign symbols based on status and how to use Harvey Balls to display percent complete.

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:

Continue reading