List of Supported Operators:


  • +
  • -
  • *
  • ^
  • /
  • !=
  • <>
  • >
  • <
  • >=
  • <=
  • ==
  • =
  • &&
  • ||
  • &
  • -
  • !
  • ~, + 


List of Supported Formulas:


  • ADDMONTHS
  • DAY
  • MONTH
  • NOW
  • TODAY
  • WEEKDAY
  • YEAR
  • AND
  • BLANKVALUE
  • CASE
  • DATETIMEVALUE
  • IF
  • ISBLANK
  • ISNULL
  • ISNUMBER
  • NOT
  • NULLVALUE
  • OR
  • ABS
  • CEILING
  • EXP
  • FLOOR
  • LN
  • LOG
  • MAX
  • MCEILING
  • MFLOOR
  • MIN
  • MOD
  • ROUND
  • SQRT
  • BEGINS
  • CONTAINS
  • FIND
  • LEFT
  • LEN
  • LOWER
  • LPAD
  • MID
  • RIGHT
  • RPAD
  • SUBSTITUTE
  • TEXT
  • TRIM
  • UPPER
  • VALUE
  • REGEX


For more information on how to create Formulas, please visit this Salesforce webpage that breaks down all the different functionalities: Formula Operators and Functions.

Comments in Formulas

You may include comments in your Formulas. See the examples below.