1. Home
  2. Fields
  3. Create Formula Field
  4. Use the Formula Functions

Use the Formula Functions

FunctionsDescription
IFDetermines if expressions are true or false. Returns a given value if true and another value if false.
ISNUMBERDetermines if a text value is a number and returns True if it is. Otherwise, it returns False.
ABSCalculates the absolute value of a number. The absolute value of a number is the number without its positive or negative sign.
MAXReturns the highest number from a list of numbers.
MINReturns the lowest number from a list of numbers.
NOWReturns the current date and time in Date/Time data type.
TODAYReturns the current date as a date data type.
DATEVALUEReturns a date value for a date/time.
DATETIMEVALUEReturns a year, month, day and time value in the GMT timezone.
CONTAINSCompares two arguments of text and returns True if the first argument contains the second argument. If not, returns False.
STRARTSWITHDetermines the value or text to start with.
ENDSWITHDetermines the value or text to end with.
ISPICKVALDetermines if the value of a picklist field is equal to a text literal you specify.
INCLUDESDetermines if the value of a picklist field is equal to a text literal you specify.
HYPERLINKCreates a link to a URL specified that is linkable from the text specified.
TEXTReturns the text value of a literal.
Example: TEXT(picklist) returns the text value of the selected item in the picklist field.
VALUEReturns the decimal value of a literal.
Example: VALUE(“3.6”) returns the decimal value 3.6
Was this article helpful to you? Yes No

How can we help?