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,

10 Comments
Community Manager
 
Status changed to: Needs Community Support
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: Needs Community Support
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.

Users Online
Currently online: 161 members 810 guests
Please welcome our newest community members: