How to Create Formula Field in Salesforce

Quick summary

A Salesforce formula field lets you automatically calculate and display values based on other fields in your CRM objects. This step-by-step walkthrough shows you how to create a formula field using the Object Manager and Advanced Formula editor in Salesforce Setup.

Steps

1. Click the gear icon at the top right corner of your Salesforce dashboard.
2. Select Open Advanced Setup from the dropdown menu.
3. Click Object Manager at the top of the Setup page.
4. Select the object you want to add a formula field to (e.g., Account, Opportunity, Contact).
5. Click Fields & Relationships in the left-hand sidebar.
6. Click New at the top of the Fields & Relationships list.
7. Choose Formula as the Data Type.
8. Click Next to proceed to the next step.
9. Fill in the required field details, including the field label and description.
10. Choose the Formula Return Type (e.g., Currency, Number, Text).
11. Click Next to open the formula editor.
12. Select Advanced Formula to access the full formula editor.
13. Click Insert Field to browse and select a field to add to your formula.
14. Choose a field (e.g., Amount), then click Insert to add it to the formula.
15. Click Insert Operator and choose an operator (e.g., +, -, *, /) for your formula.
16. Click Insert Field again to select another field to complete your formula, then click Insert when finished.
17. Click Check Syntax to validate your formula and ensure it is error-free.
18. When the formula is valid, click Next to proceed.
19. Modify field-level security settings as needed, then click Next.
20. Finally, click Save to create and activate the formula field.