| Functions | Description |
|---|---|
| IF | Determines if expressions are true or false. Returns a given value if true and another value if false. |
| ISNUMBER | Determines if a text value is a number and returns True if it is. Otherwise, it returns False. |
| ABS | Calculates the absolute value of a number. The absolute value of a number is the number without its positive or negative sign. |
| MAX | Returns the highest number from a list of numbers. |
| MIN | Returns the lowest number from a list of numbers. |
| NOW | Returns the current date and time in Date/Time data type. |
| TODAY | Returns the current date as a date data type. |
| DATEVALUE | Returns a date value for a date/time. |
| DATETIMEVALUE | Returns a year, month, day and time value in the GMT timezone. |
| CONTAINS | Compares two arguments of text and returns True if the first argument contains the second argument. If not, returns False. |
| STRARTSWITH | Determines the value or text to start with. |
| ENDSWITH | Determines the value or text to end with. |
| ISPICKVAL | Determines if the value of a picklist field is equal to a text literal you specify. |
| INCLUDES | Determines if the value of a picklist field is equal to a text literal you specify. |
| HYPERLINK | Creates a link to a URL specified that is linkable from the text specified. |
| TEXT | Returns the text value of a literal. Example: TEXT(picklist) returns the text value of the selected item in the picklist field. |
| VALUE | Returns the decimal value of a literal. Example: VALUE(“3.6”) returns the decimal value 3.6 |
- Home
- /
- Fields
- /
- Create Formula Field
- /
- Use the Formula Functions