Overview of formulas

Formulas are used to calculate custom fields and add logic to features such as validation rules and flows. Formulas calculate based on operators and functions.

The following operators and functions are available in Salesforce formulas. Using a combination of these results in a very powerful data integrity engine.

Below, we have provided screenshots of the different operators and functions categorized into different areas. First, we will see math, logic, and text operators; next, we will see date and time, logic, math, text, summary, and advanced functions. Have a brief look through the information below to get an idea of the tools you have available to you:

Note that you can view these operators and functions, and their relevant descriptions, at any time on Salesforce Help (see Further reading).

• Math operators:

Figure 19.1: List of math operators available in Salesforce formulas

• Logic operators:
...