Boolean fields in Formulas?

I can’t seem to get boolean fields to work properly in formulas, I’ve tried everything I can think of in terms of how they might be stored and treated but nothing seems to work.

I simply want to perform a calculation if a boolean field is true, otherwise just return 0. I’ve tried the below but to no avail. Any help would be greatly appreciated!

IF(Boolean,Calculation,0) - Always returns Calculation
IF(Boolean=TRUE(),Calculation,0) - Never returns Calculation
IF(Boolean=1,Calculation,0) - Never returns Calculation

Hey @EthosLuke, here is a formula example that works for me:

IF(

published

=FALSE(), “Unpublished”, IF(

closed

=TRUE(), “Closed”, “Open”))

Not sure if that helps!

Thanks Luke,

This can be closed, my original formula of

IF(Boolean,Calculation,0) - Always returns Calculation

does actually work, just the preview of the formula is incorrect and I needed to refresh the page to see the values update in the fields when unticking/ticking the boolean :sweat_smile:

1 Like