SF Formulas

Question 1

An algorithm that derives its values from other fields, expressions, or values

Answer 1

Formula

Question 2

Value or another custom or standard field

Example: Account.Email

Answer 2

Field reference

Question 3

A string (text) or number that is not calculated or changed. A constant value.

Examples: 3.14, “years”

Answer 3

Literal values

Question 4

A system defined formula

Example: AND, IF, TODAY, LAPD…

Answer 4

Function

Question 5

Symbol representing a calculation

Examples: +, -, *, /, =, <, >, <>, …

Answer 5

Operator

Question 6

Leave notes in formula to explain what its doing

Example: /* Looks like this */

Answer 6

Comments

Question 7

Boolean: True/False

Example: IsClosed

Answer 7

Checkbox

Question 8

Dollar, Pound, Lira, Euro, etc.

Example: Opportunity Amount

Answer 8

Currency

Question 9

yyyy-mm-dd

Example: Opportunity Close Date

Answer 9

Date

Question 10

Hh: mm: ss

Example: (not a standard field data type)

Answer 10

Time

Question 11

123

Example: Number of Employees

Answer 11

Number

Question 12

Probability

Example: 20%

Answer 12

Percent