While working as a Salesforce Admin, we sometimes need to quickly identify records that meet specific conditions without creating any automation, such as a Flow or Process Builder.
For example, the sales team wants to know if an opportunity’s Close Date is before TODAY() and the Stage is not “Closed Won” or “Closed Lost“.
Instead of asking users to check a box manually, we can create a Checkbox Formula that automatically checks itself when the condition is true. This way, users can easily identify the overdue opportunities in reports and list views.
In this article, we will learn about the Salesforce Checkbox Formula Field. In this, I will explain how to use the checkbox field with formulas and functions that return either TRUE (checked) or FALSE (unchecked) based on the defined condition.
Salesforce Checkbox Formula Field: Use Cases & Examples
Next, I will explain some real-time use cases and how to create a checkbox formula field in Salesforce. This field automatically gets checked or unchecked whenever the specific condition you define is met.
Example: Employee Birthday or Anniversary Checkbox
Let’s say you want to highlight an employee’s birthday in Salesforce. We can create a checkbox formula field that will automatically get checked on the employee’s birthday and then get unchecked the next day.
I have already created a custom date field named DOB__c on the custom object Employee__c to store the employee’s date of birth, which we will now use in our checkbox formula.
- Go to the Gear Icon. -> Click on the Setup. -> Select the Object Manager tab. Select the Object on which you want to create the Formula Field to extract the year from the date. Here, I’m going to create an Employee Object.
- In the Employee setup, click on Fields and Relationships to create a new field, then click the New button.
- In this step, we will use a formula to add a condition, so that if the condition is met, the checkbox should be set to true. To do this, select the Formula from the data type and click Next.