I have a checkbox field named "Approval" that is checked and not checked when creating a candidate record to see if they have been approved. What I'm trying to do is create a formula text field named “Custom Approval Message” that will dynamically display this:

i. “Record not yet approved” – When a candidate's test record has not yet been approved.

ii. “Record has been approved” – When a candidate's test record is approved.

My main question is how to achieve this using a custom formula field.

What I have so far:

A candidate object with fields Name, Salary, and approval(checkbox set at false). Now I want a new formula text field record to display the above information based off if the checkbox has been checked or not. I created a new formula text box and keep getting errors with this:

Customer Approval Message (checkbox) = IF([Approval__c] == True, "Record has been approved", [Approval__c]== False, "Record not yet approved")

I'm very new to using salesforce and cannot figure out how to do this. Any help appreciated

I have a checkbox field named "Approval" that is checked and not checked when creating a candidate record to see if they have been approved. What I'm trying to do is create a formula text field named “Custom Approval Message” that will dynamically display this:

1. “Record not yet approved” – When a candidate's test record has not yet been approved.

2. “Record has been approved” – When a candidate's test record is approved.

My main question is how to achieve this using a custom formula field.

What I have so far:

A candidate object with fields Name, Salary, and approval  (checkbox set at false).

Now I want a new formula text field record to display the above information based off if the checkbox has been checked or not. I created a new formula text box and keep getting errors with this:

IF(
    [Approval__c] == True, 
    "Record has been approved",
    [Approval__c] == False, 
    "Record not yet approved"
)

I'm very new to using salesforce and cannot figure out how to do this. Any help appreciated