|
Title |
Label |
Description |
ExampleString |
1 |
ABS |
ABS |
Returns absolutely the worth of a quantity, a quantity with out its signal |
ABS(quantity) |
2 |
ACOS |
ACOS |
Returns the arc cosine of the quantity in radians, if the given quantity is between -1 and 1. In any other case NULL. |
ACOS(quantity) |
3 |
ADDMONTHS |
ADDMONTHS |
Add the num months to the date, utilizing the final date of the month if date is the final day of the month or including num months has fewer days. |
ADDMONTHS(date,num) |
4 |
AND |
AND |
Checks whether or not all arguments are true and returns TRUE if all arguments are true |
AND(logical1,logical2,…) |
5 |
ASCII |
ASCII |
Return the primary character’s code level from the given string as a quantity. |
ASCII(textual content) |
6 |
ASIN |
ASIN |
Returns the arc sine of the quantity in radians, if the given quantity is between -1 and 1. In any other case NULL. |
ASIN(quantity) |
7 |
ATAN |
ATAN |
Returns the arc tangent of the quantity in radians. |
ATAN(quantity) |
8 |
ATAN2 |
ATAN2 |
Returns the arc tangent of the quotient of y and x in radians. |
ATAN2(y, x) |
9 |
BEGINS |
BEGINS |
Checks if textual content begins with specified characters and returns TRUE if it does. In any other case returns FALSE |
BEGINS(textual content, compare_text) |
10 |
BLANKVALUE |
BLANKVALUE |
Checks whether or not expression is clean and returns substitute_expression whether it is clean. If expression just isn’t clean, returns the unique expression worth. |
BLANKVALUE(expression, substitute_expression) |
11 |
BR |
BR |
Inserts an HTML break tag in string formulation |
BR() |
12 |
CASE |
CASE |
Checks an expression in opposition to a sequence of values. If the expression compares equal to any worth, the corresponding result’s returned. If it isn’t equal to any of the values, the else-result is returned |
CASE(expression, value1, result1, value2, result2,…,else_result) |
13 |
CASESAFEID |
CASESAFEID |
Converts a 15-character ID right into a case insensitive 18-character ID |
CASESAFEID(id) |
14 |
CEILING |
CEILING |
Rounds a quantity as much as the closest integer, away from zero if adverse |
CEILING(quantity) |
15 |
CHR |
CHR |
Return a string with the primary character’s code level because the given quantity. |
CHR(quantity) |
16 |
CONTAINS |
CONTAINS |
Checks if textual content comprises specified characters, and returns TRUE if it does. In any other case, returns FALSE |
CONTAINS(textual content, compare_text) |
17 |
COS |
COS |
Returns the cosine of the quantity, the place the quantity given in radians |
COS(quantity) |
18 |
CURRENCYRATE |
CURRENCYRATE |
Return the conversion price to the company forex for the given CurrencyIsoCode, or 1.zero if the forex is invalid. |
CURRENCYRATE(IsoCode) |
19 |
DATE |
DATE |
Creates a date from a yr, month and day |
DATE(yr,month,day) |
20 |
DATETIMEVALUE |
DATETIMEVALUE |
Returns a yr, month, day and GMT time worth |
DATETIMEVALUE(expression) |
21 |
DATEVALUE |
DATEVALUE |
Creates a date from its datetime or textual content illustration |
DATEVALUE(expression) |
22 |
DAY |
DAY |
Returns the day of the month, a quantity between 1 and 31 |
DAY(date) |
23 |
DAYOFYEAR |
DAYOFYEAR |
Return the day of the calendar yr (from 1-366). |
DAYOFYEAR(date) |
24 |
DISTANCE |
DISTANCE |
Returns the gap between two areas utilizing the supplied unit. |
DISTANCE(location, location, unit) |
25 |
EXP |
EXP |
Returns e raised to the facility of a given quantity |
EXP(quantity) |
26 |
FIND |
FIND |
Returns the place of the search_text string in textual content |
FIND(search_text, textual content [, start_num]) |
27 |
FLOOR |
FLOOR |
Rounds a quantity down, in the direction of zero to the closest integer |
FLOOR(quantity) |
28 |
FORMATDURATION |
FORMATDURATION |
Format the variety of seconds with optionally available days, or the distinction between instances or dateTimes as HH:MI:SS. |
FORMATDURATION(numSeconds[, includeDays] | dateTime/time, dateTime/time) |
29 |
FROMUNIXTIME |
FROMUNIXTIME |
Return the datetime that represents the given quantity because the seconds elapsed since 1 Jan 1970. |
FROMUNIXTIME(quantity) |
30 |
GEOLOCATION |
GEOLOCATION |
Returns a location primarily based on the supplied latitude and longitude. |
GEOLOCATION(latitude, longitude) |
31 |
GETSESSIONID |
GETSESSIONID |
Returns the present session ID. This can be helpful in hyperlinks to different functions that use salesforce.com credentials for authentication |
GETSESSIONID() |
32 |
HTMLENCODE |
HTMLENCODE |
Encodes textual content and merge subject values to be used in HTML |
HTMLENCODE(textual content) |
33 |
HYPERLINK |
HYPERLINK |
Creates a hyperlink |
HYPERLINK(url, friendly_name [, target]) |
34 |
IF |
IF |
Checks whether or not a situation is true, and returns one worth if TRUE and one other worth if FALSE. |
IF(logical_test, value_if_true, value_if_false) |
35 |
INCLUDES |
INCLUDES |
Determines if any worth chosen in a multi-select picklist subject equals a textual content literal you specify. |
INCLUDES(multiselect_picklist_field, text_literal) |
36 |
INITCAP |
INITCAP |
Return the textual content as lowercase with first character of every phrase made uppercase. |
INITCAP(textual content) |
37 |
ISBLANK |
ISBLANK |
Checks whether or not an expression is clean and returns TRUE or FALSE |
ISBLANK(expression) |
38 |
ISNULL |
ISNULL |
Checks whether or not an expression is null and returns TRUE or FALSE |
ISNULL(expression) |
39 |
ISNUMBER |
ISNUMBER |
Returns TRUE if the textual content worth is a quantity. In any other case, it returns FALSE. |
ISNUMBER(Textual content) |
40 |
ISOWEEK |
ISOWEEK |
Return the ISO 8601 week quantity for the given date (from 1-53) in order that the primary week begins on monday. |
ISOWEEK(date) |
41 |
ISOYEAR |
ISOYEAR |
Return the ISO 8601 week-numbering 4-digit yr for the given date in order that the primary day is a monday. |
ISOYEAR(date) |
42 |
ISPICKVAL |
ISPICKVAL |
Checks whether or not the worth of a picklist subject is the same as a string literal |
ISPICKVAL(picklist_field, text_literal) |
43 |
JSENCODE |
JSENCODE |
Encodes textual content and merge subject values to be used in JavaScript |
JSENCODE(textual content) |
44 |
JSINHTMLENCODE |
JSINHTMLENCODE |
Encodes textual content and merge subject values to be used in JavaScript inside HTML tags |
JSINHTMLENCODE(textual content) |
45 |
LEFT |
LEFT |
Returns the desired variety of characters from the beginning of a textual content string |
LEFT(textual content, num_chars) |
46 |
LEN |
LEN |
Returns the variety of characters in a textual content string |
LEN(textual content) |
47 |
LINKTO |
LINKTO |
Returns the HTML hyperlink ingredient for the chosen goal with optionally available inputs expressed as question parameters |
LINKTO(label, goal, id, [inputs], [no override]) |
48 |
LN |
LN |
Returns the pure logarithm of a quantity |
LN(quantity) |
49 |
LOG |
LOG |
Returns the bottom 10 logarithm of n |
LOG(quantity) |
50 |
LOWER |
LOWER |
Converts all letters within the worth to lowercase |
LOWER(textual content) |
51 |
LPAD |
LPAD |
Pad the left aspect of the worth with areas or the optionally available pad string in order that the size is padded_length |
LPAD(textual content, padded_length [, pad_string]) |
52 |
MAX |
MAX |
Returns the best of all of the arguments |
MAX(quantity,quantity,…) |
53 |
MCEILING |
MCEILING |
Rounds a quantity as much as the closest integer, in the direction of zero if adverse |
MCEILING(quantity) |
54 |
MFLOOR |
MFLOOR |
Rounds a quantity all the way down to the closest integer, away from zero if adverse |
MFLOOR(quantity) |
55 |
MID |
MID |
Returns character from the center of a textual content string, given a beginning place and size |
MID(textual content, start_num, num_chars) |
56 |
MIN |
MIN |
Returns the least of all of the arguments |
MIN(quantity,quantity,…) |
57 |
MOD |
MOD |
Returns the rest after a quantity is split by a divisor |
MOD(quantity,divisor) |
58 |
MONTH |
MONTH |
Returns the month, a quantity between 1 (January) and 12 (December) |
MONTH(date) |
59 |
NOT |
NOT |
Adjustments FALSE to TRUE or TRUE to FALSE |
NOT(logical) |
60 |
NOW |
NOW |
Returns a datetime representing the present second |
NOW() |
61 |
NULLVALUE |
NULLVALUE |
Checks whether or not expression is null and returns substitute_expression whether it is null. If expression just isn’t null, returns the unique expression worth. |
NULLVALUE(expression, substitute_expression) |
62 |
OR |
OR |
Checks whether or not any of the arguments are true and returns TRUE or FALSE. Returns FALSE provided that all arguments are false |
OR(logical1,logical2,…) |
63 |
PI |
PI |
Returns pi |
PI() |
64 |
PICKLISTCOUNT |
PICKLISTCOUNT |
Returns the variety of chosen values in a multi-select picklist. |
PICKLISTCOUNT(multiselect_picklist_field) |
65 |
PREDICT |
PREDICT |
Returns an Einstein Discovery prediction primarily based on both a file ID or an inventory of fields and their values. |
PREDICT(PredDefId, [recordId] | [field, value, …]) |
66 |
REGEX |
REGEX |
Returns TRUE if Textual content matches the common expression RegEx_Text. In any other case, it returns FALSE. |
REGEX(Textual content, RegEx_Text) |
67 |
REVERSE |
REVERSE |
Returns the textual content string in reverse order |
REVERSE(textual content) |
68 |
RIGHT |
RIGHT |
Returns the desired variety of characters from the tip of a textual content string |
RIGHT(textual content, num_chars) |
69 |
ROUND |
ROUND |
Rounds a quantity to a specified variety of digits |
ROUND(quantity,num_digits) |
70 |
RPAD |
RPAD |
Pad the suitable aspect of the worth with areas or the optionally available pad string in order that the size is padded_length |
RPAD(textual content, padded_length [, pad_string]) |
71 |
SIN |
SIN |
Returns the sine of the quantity, the place the quantity given in radians |
SIN(quantity) |
72 |
SQRT |
SQRT |
Returns the constructive sq. root of a quantity |
SQRT(quantity) |
73 |
SUBSTITUTE |
SUBSTITUTE |
Substitutes new_text for old_text in a textual content string. Use SUBSTITUTE while you need to change particular textual content in a textual content string |
SUBSTITUTE(textual content, old_text, new_text) |
74 |
TAN |
TAN |
Returns the tangent of the quantity, the place the quantity given in radians |
TAN(quantity) |
75 |
TEXT |
TEXT |
Converts a price to textual content utilizing normal show format |
TEXT(worth) |
76 |
TODAY |
TODAY |
Returns the present date |
TODAY() |
77 |
TRIM |
TRIM |
Removes all areas from a textual content string aside from single areas between phrases |
TRIM(textual content) |
78 |
TRUNC |
TRUNC |
Truncates a quantity to a specified variety of digits |
TRUNC(quantity,num_digits) |
79 |
UNIXTIMESTAMP |
UNIXTIMESTAMP |
Return the variety of seconds since 1 Jan 1970 for the given date, or variety of seconds within the day for a time. |
UNIXTIMESTAMP(date/time) |
80 |
UPPER |
UPPER |
Converts all letters within the worth to uppercase |
UPPER(textual content) |
81 |
URLENCODE |
URLENCODE |
Encodes textual content and merge subject values to be used in URLs |
URLENCODE(textual content) |
82 |
URLFOR |
URLFOR |
Returns the url for the chosen goal with optionally available inputs expressed as question parameters |
URLFOR(goal, id, [inputs], [no override]) |
83 |
VALUE |
VALUE |
Converts a textual content string that represents a quantity to a quantity |
VALUE(textual content) |
84 |
WEEKDAY |
WEEKDAY |
Return the day of the week for the given date, utilizing 1 for Sunday, 2 for Monday, by means of 7 for Saturday. |
WEEKDAY(date) |
85 |
YEAR |
YEAR |
Returns the yr of a date, a quantity between 1900 and 9999 |
YEAR(date) |