Salesforce Compatible Functions

The following are the functions supported by the Mashmatrix Sheet formulas. Each function works just as well as its Salesforce counterpart, unless otherwise specified. Please see Salesforce's help for more information about the details of each function.

Date & Time

  • ADDMONTHS

  • DATE

  • DATEVALUE

  • DATETIMEVALUE

  • TIMEVALUE

  • YEAR

  • MONTH

  • DAY

  • WEEKDAY

  • HOUR

  • MINUTE

  • SECOND

  • MILLISECOND

  • TODAY

  • NOW

  • TIMENOW

Logical

  • AND

  • OR

  • NOT

  • CASE

  • IF

  • ISNULL

  • ISBLANK

  • ISNUMBER

  • NULLVALUE

  • BLANKVALUE

Math

  • ABS

  • CEILING

  • FLOOR

  • ROUND

  • MCEILING

  • MFLOOR

  • EXP

  • LN

  • LOG

  • SQRT

  • MAX

  • MIN

  • MOD

Text

  • BEGINS

  • CONTAINS

  • INCLUDES

  • ISPICKVAL

  • FIND

  • LEFT

  • RIGHT

  • MID

  • LOWER

  • UPPER

  • LPAD

  • RPAD

  • SUBSTITUTE

  • TRIM

  • LEN

  • TEXT

  • VALUE

  • CASESAFEID

  • HYPERLINK

  • IMAGE

In order to correctly display links/images in cells of a formula column that returns the value of the HYPERLINK and IMAGE functions, the display type of the column must be changed to Rich Text. See "Column Settings - Basic Property" for more information.

The following functions are available as Salesforce formula functions, but are not supported by the Mashmatrix Sheet. Even if a function is not listed here, it is unsupported unless it is explicitly specified as a supported function above.

  • GEOLOCATION

  • DISTANCE

  • BR

  • GETSESSIONID

  • CURRENCYRATE

Formula Restrictions and Considerations

  • Note that not all functions and global variables in Salesforce formulas are supported. Please check the support list above for details.

  • Unlike Salesforce formulas, fields must match at the case level with the API reference name defined in Salesforce. Additionally, function names should be in all capital letters.

  • Unlike Salesforce formulas, you need direct read access to the fields referenced within a formula.

  • If you are referring to a field in another object through a relationship in a formula (Cross-Object Formula), you need reference access to the corresponding object record. If you do not have access to the object record, the behavior will be equivalent to a reference to the record being null.

  • It is currently not supported to refer to fields within a formula that follow a relationship to multiple objects (Polymorphic Relationship).

PreviousFunctionNextAggregation Functions

Last updated