Conditional Formatting on Booleans

Conditional Formatting on Booleans

As a model Builder I would like to use Booleans as a Basis for Conditional formatting. 

 

For example. I have a Boolean/ Checkbox which indicates that not all fields in a new Item/ setting has been filled. I would like to be able to use that boolean directly instead of reverting to a number. 
The advantage would be to save on workspace size,

14 Comments
Community Manager
 
Status changed to: Your support is needed
Contributor

I agree with this request, as a boolean would lend itself nicely to a 2 color formatting rule (eg. true = green, false = blue) and it would avoid having to having to create an essentially duplicate line item (IF bool THEN 1 ELSE 0) solely for the conditional formatting. I have found myself wishing for it often.

Occasional Contributor

I was just about to request this.  This would be really useful as there are instances where you have to start to create line items with a large cell count to achieve it.

 

I would suggest that we still need to be able the minumum/mid-point/maximum inputs so that we can have a bit of control over the exact coloiur associated with a true or false. 

I agree with this request. Having to have a dummy line item for such a simple use is a massive waste of space.

 

 

Master Anaplanner/Community Boss

Ditto. I'm sure Booleans are more efficient too.

Certified Master Anaplanner

Currently if you want to apply a conditional format based on a Boolean value you have to create an additional line item which you then have to put an if statement to test whether it is true or false and return a numeric value more often than not a 1 or 0. It would be more efficient if you could apply a conditional format to a boolean using the underlying 1 or 0 based on the TRUE or FALSE result of the tick box. This would be a great extension to the NUX capabilities which are a significant improvement in terms of look over the classic dashboard.

Community Manager
 
Status changed to: Your support is needed
Certified Master Anaplanner

I've often through this!!!  Much of our use of conditional formatting is TRUE/FALSE based so it would greatly simply setup for us if using Booleans was an option.   I think it would also help with auditability.  Thanks for suggesting @nick_barker 

Certified Master Anaplanner

Hi, thumbs up for idea, it would reduce complexity, space usage, and development time, as well as speed up of the models.

 

Possible duplicate of https://community.anaplan.com/t5/Idea-Exchange/Conditional-Formatting-on-Booleans/idi-p/39299, can we have it merged ( @Miran )?

Community Manager

Hi @M.Kierepka,

 

These ideas have been merged.

Master Anaplanner/Community Boss

Agree. It would avoid creating a numeric format Line-item with formula If Boolean then 1 else 0... 

Certified Master Anaplanner

+1 for this,  would really be helpful in reducing the size

Certified Master Anaplanner

Great idea. 

 

There have been so many times that I've had to create number formatted line items even though a Boolean flag exists just to be able to use conditional formatting.  This would not only save on space but also save module development time for modellers.  

 

I think one of the product development goals should be to try and automate or make more efficient the mundane modelling tasks so that model builders can remain focussed and engaged on the more important, interesting, and challenging aspects of model building. 

Certified Master Anaplanner

What is the tipping point for support before development pick the idea up and investigate?

 

Users Online
Currently online: 75 members 342 guests
Please welcome our newest community members: