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
Miran
Community Manager
 
Status changed to: Your support is needed
NoahJ
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.

adam_bimson_5
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.

 

 

JaredDolich
Master Anaplanner/Community Boss

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

nick_barker
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.

Miran
Community Manager
 
Status changed to: Your support is needed
Tiffany.Rice
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 

M.Kierepka
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 )?

Miran
Community Manager

Hi @M.Kierepka,

 

These ideas have been merged.

alexpavel
Certified Master Anaplanner

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

PuneetKumar
New Contributor

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

m.angeles11
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. 

nick_barker
Certified Master Anaplanner

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

 

Users Online
Currently online: 133 members 426 guests
Please welcome our newest community members: