Conditional Formatting on Booleans

[tabendroth]

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,

[NoahJ]

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]

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.

[stefan.godfrey@barbicaninsurance.com]

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

[JaredDolich]

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

[nick_barker]

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.

[Tiffany.Rice]

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]

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

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

[Miran]

Hi@M.Kierepka,

These ideas have been merged.

[alexpavel]

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

[PuneetKumar]

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

[m.angeles11]

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]

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