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.
- Next, provide the Field Label and API Name for the formula field. Then, in the Formula Return Type, select Checkbox and click on the Next button.
- Enter the Checkbox formula in the Advanced Formula editor. Here is the formula:
AND(
NOT(ISBLANK(DOB__c)),
DAY(DOB__c) = DAY(TODAY()),
MONTH(DOB__c) = MONTH(TODAY())
)In the above formula, we have used the AND() function, which checks all conditions inside it, a function that we will define. If all conditions are true, the formula returns true, which means the checkbox is checked; otherwise, it remains unchecked.
IF DOB is not blank, AND the day of DOB = today’s day, AND the month of DOB = today’s month → then TRUE (checked). Otherwise FALSE (unchecked).
- DOB__c = 09-Sep-1995.
- Today = 09-Sep-2025 → Checkbox is checked.
- Tomorrow = 10-Sep-2025 → Checkbox is unchecked.
- Next year, on 09-Sep-2026, the checkbox is rechecked.
Click “Check Syntax” to ensure the formula is correct. After that, click Next.
- Select the Field Level Security for the formula field, and then select the profiles to make the field visible to those profiles. The field will be visible for the profiles selected from the Visible column.
- After selecting the profiles, click on the Next button.
- In this step, we must select the field’s visibility on the object’s page layouts. In this case, we have created a formula field for the reports, allowing us to choose not to display it on the page layouts.
- Uncheck the checkboxes of the page layouts to prevent the field from displaying on them. After this, click on the Save button.
- In the screenshot below, you can see that the Formula Checkbox field has been successfully created on the object in Salesforce.
Proof of Concept:
I have now added the created Checkbox Formula field to the Employee list view, where we can view the list of employee records.
For example, today = 9th September. If today’s day and month match the employee’s DOB__c field, then the condition becomes TRUE and the checkbox is automatically checked. Otherwise, it remains unchecked.
Example: Check Opportunity is Overdue
For example, if an opportunity is overdue, it means its Close Date is before TODAY() and the Stage is not “Closed Won” or “Closed Lost.” Then, for those opportunities, the checkbox field should automatically get checked.
On the Opportunity object, we already have the standard fields Close Date and Stage Name.
Using these fields and formula functions, we will create a checkbox formula to meet our requirement.
Whenever the defined condition is satisfied, the checkbox will automatically return TRUE (checked).
In the above example, we created a Checkbox Formula field on the Employee object. In the same way, you now need to navigate to the Formula Editor on the Opportunity object to create the checkbox formula using the CloseDate and StageName fields.
Add the following formula in the Formula Editor to define the conditions:
AND(
CloseDate < TODAY(),
NOT(
OR(
ISPICKVAL(StageName, "Closed Won"),
ISPICKVAL(StageName, "Closed Lost")
)
)
)- Here we are checking whether the Opportunity’s Close Date is before today (meaning the record is overdue).
- At the same time, the Stage Name should not be “Closed Won” or “Closed Lost.”
- If both of these conditions are met, the formula will return TRUE, and the checkbox will be checked for that Opportunity record.
Proof of Concept:
After adding the created Checkbox Formula field to the Opportunity list view as a column, you can easily see the results.
In the image below, if the Close Date is before TODAY() and the Stage is not “Closed Won” or “Closed Lost,” then those Opportunities will have the checkbox automatically checked.
In this way, we can use the Salesforce checkbox formula field, which returns either TRUE (checked) or FALSE (unchecked) based on the defined condition.
Conclusion
I hope you have got an idea about how the Salesforce Checkbox Formula Field works. It is very useful when you want to quickly identify records that meet certain conditions without using automation like Flow or Process Builder.
In this, I have explained how to use the checkbox field with formulas and functions that return either TRUE (checked) or FALSE (unchecked) based on the defined condition.
You may like to read:
- Create a Checkbox Field in Salesforce
- Create Formula Field Type in Salesforce
- Salesforce Checkbox Group
- Use Roll Up Summary on Average field in Salesforce
I am Bijay Kumar, the founder of SalesforceFAQs.com. Having over 10 years of experience working in salesforce technologies for clients across the world (Canada, Australia, United States, United Kingdom, New Zealand, etc.). I am a certified salesforce administrator and expert with experience in developing salesforce applications and projects. My goal is to make it easy for people to learn and use salesforce technologies by providing simple and easy-to-understand solutions. Check out the complete profile on About us.
