Conditional Formatting with Boolean Fields for OnePager for Version 7.1
Contents
Introduction
Illustrations used in this article are from OnePager Pro using data from Microsoft Project but the feature's function, controls, and manual edits apply equally to other OnePager editions that import from data sources like Microsoft Excel, Smartsheet, and Oracle Primavera P6.
Overview
The overall capability of OnePager's Conditional Formatting Rules feature is explained in detail at: Conditional Formatting Overview
Further, the reconfiguration of the Conditional Formatting Rules form and the procedure for adding rules to the Conditional Formatting Rules form are covered in the first two sub-sections in the article at: Adding Conditional Formatting Rules
The purpose of this article is to focus on conditional formatting involving Microsoft Project Boolean fields (e.g., Flag1 through Flag20, etc.) whose field values are confined to Yes or No, or alternatively, 1 or 0.
Example
Microsoft Project Source Plan
As an example, suppose we have the Microsoft Project source plan shown below which consists of three phases and four resources consisting of Team 1, Team 2, Team 3, and Team 4.
-09252019.png)
In the Microsoft Project source plan above, the field titled Team Available is actually Flag1.
Unformatted OnePager Pro Chart
Creating a simple chart without Conditional Formatting rules produces this:
-06092020.png)
Now suppose you want to represent any team that is Available (with Flag1=Yes), regardless of the team name with a different task bar shape.
Proposed Conditional Formatting Rule
This can be done by creating the following Conditional Formatting Rule by accessing the Chart Properties form at its Task Bars tab and clicking the Manage Rule... button at the bottom of the form to access the Conditional Formatting Rules form filled out as shown below:
-01072022.png)
Chart With Conditional Formatting Rule Applied
When the Conditional Formatting Rules are in place and the chart is created it looks like this:
-06092020.png)
OnePager applies the Conditional Formatting Rule created through the Conditional Formatting Rules form, adjusts the Legend’s Title, and provides a Legend Item to reflect the rule applied. You can manually change the legend title text and legend item text as required.
For more information on editing the Legend Title and/or Legend Items, please see the article at: Legend Editing Controls for OnePager
Updating the Microsoft Project Source Plan
Should you later go back and change the Flag1 field data in the Microsoft Project source plan, the next snapshot reflects the change by continuing to apply the rule. Suppose that the situation has changed in terms of Team Available as shown below:
-09252019.png)
Second Snapshot Using the Updated Microsoft Project Source Plan
You can now create another snapshot the normal way and the chart now looks like this:
-06092020.png)
Note that the task bar shapes with the new shape configurations are all associated with Teams that are now available. OnePager retains the color associated with Teams for the new task bar shape since the Color Action column in the Conditional Formatting rule is not involved in rule.
Related Links
Conditional Import Filters (Portal)
Manual Editing Task/Milestone Shapes and Text Labels (Portal)
Changing Individual Task/Milestone Properties (Color, Shapes, Labels, etc.)
Modifying Decorations on Tasks/Milestones (Portal)
Editing with the Chart Properties form (Portal)
Microsoft Project Fields Available to OnePager Pro
Oracle Primavera P6 Columns Available to OnePager
Gallery of Gradient and Hash Fill Patterns
Gallery of Dynamic Shapes and Emoji Symbols
Conditional Formatting Tutorial Video
Blog-Display Certainty in Your Plan by Using Conditional Formatting
Using Microsoft Project Flag Fields with OnePager Pro's Conditional Formatting Rules
(11.5.1-71)
