Formulas

Question 1

What is a Formula Field in Salesforce?

Answer 1

Data within a formula field is automatically updated by Salesforce based on the formula’s logic.

Question 2

What is a Cross Object Formula in Salesforce?

Answer 2

A Cross Object Formula is one that references data in a related record.

Example: Create a Formula Field on an Opportunity to display the Account phone number. When the Account’s phone number gets updated, the field on the Opportunity is automatically updated.

https://help.salesforce.com/articleView?id=customize_cross_object.htm&language=en_US&type=0

Question 3

What’s important to know about Formula Fields?

Answer 3

Formula Fields are READ ONLY for ALL users.
For this reason, Formula Fields will NOT be displayed when editing records. The value of the Formula Field is only calculated after the record is saved. This applies to Cross Object Formula fields as well.

Question 4

What are some Formula Field limitations in Salesforce?

Answer 4

• Formula Fields CANNOT reference several Field Types, including: Text Area (Long), Text Area (Rich), Picklist (Multi-Select).
• Some Formula Fields CANNOT be referenced by Roll-Up Summary Fields.
• There are several restrictions on Formula size (character, save, compile).

Question 5

What are the two Formula Editors in Salesforce?

Answer 5

Simple and Advanced

Question 6

What is the difference between the two Formula Editors in Salesforce?

Answer 6

The Simple Editor does not provide access to cross-object formulas or functions.

The Advanced Editor provides access to cross-object variables and functions.

Question 7

Examples of Advanced Formula Fields:

Answer 7

https://help.salesforce.com/articleView?id=useful_advanced_formulas.htm&language=en_US&type=0