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 of https://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...