Print this page

How do I create a custom formula field that evaluates a checkbox field?

Knowledge Article Number 000004941
Description

How do I create a custom formula field that evaluates a checkbox field?

Resolution

The format for a custom formula field that evaluates whether or not a checkbox field is checked is:

IF(
CheckboxField__c,
value_if_true,
value_if_false)

It is not necessary to use the "Equal" or "Not Equal" operator within the formula. The act of Declaring the API NAME of the checkbox implies TRUE. To Evaluate FALSE, one of the following Formats can be utilized:

NOT( CheckboxField__c)

!CheckboxField__c





promote demote