Mashmatrix Sheet
English
English
  • Mashmatrix Sheet User Guide
  • Introduction
  • Application Overview
  • Basic Usage
  • Functions about Books / Sheets
    • Create a New Book
    • Change Book Setting
    • Duplicate Book
    • Delete Book
    • Open Book in New Tab
    • Change Book Sharing Folder
    • Split Book Screen
    • Create a New Sheet
    • Change Tab Display Order of Sheets
    • Change Sheet Setting
      • Sheet Setting - Basic
      • Sheet Setting - Options
      • Sheet Setting - Filter
      • Sheet Setting - Actions
    • Maximize Sheet
    • Duplicate Sheet
    • Delete Sheet
    • Create a Related Sheet
    • Create a Card Type Sheet
    • Change Card Type Sheet Setting
    • Configure Views
    • Configure Search Form
  • Functions about Displaying Data
    • Change Columns Order
    • Change Column Width / Height
    • Fix Column from Scrolling
    • Sort
    • Filter
    • Change Column Setting
      • Column Setting - Basic Property
      • Column Setting - Options
      • Column Setting - Format
    • Show / Hide Column
    • Add Column
    • Delete Column
    • Group Column Headers
    • Summary Row
    • Formula
    • Function
      • Salesforce Compatible Functions
      • Aggregation Functions
      • Other Extension Functions
    • Reference Value
    • Navigate Pages and Reload Records
  • Functions about Editing Data
    • Edit / Save Displayed Data
    • Copy & Paste Values
    • Create a New Record
    • Duplicate Records
    • Delete Records
    • Lookup Search
  • Functions about Actions
    • Action Button
    • Standard Actions
    • Marketing Actions
    • Custom Actions
    • Approval Request Actions
  • Functions for Advanced Usage
    • Time-Series Matrix Transformation
      • Overview
      • Add Matrix Column
      • Change Matrix Column Setting
      • Show / Hide Column
      • Add Child Column
      • Delete Child Column
      • Format
      • Matrix Column and Formula
      • Limitations
  • Settings for Admin
    • Assign License
    • Grant Permission Set
    • Administration Console
    • Organization-Level Configuration
  • Customization
    • Access Sheet Directly with URL
    • Sheet Component
    • Embed Sheet in Layout using Visualforce
    • Using Sheet Component in Visualforce
    • JavaScript API
    • Launching Custom Apex / Visualforce
    • Launching Flow
    • Using in Experience Cloud
Powered by GitBook
On this page
  • Date & Time
  • Logical
  • Math
  • Text
  • Formula Restrictions and Considerations
  1. Functions about Displaying Data
  2. Function

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

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 3 years ago

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 "" for more information.

Column Settings - Basic Property