Information Functions
CONTAINS
Returns true if values for all referred columns exist, or are contained, in those columns; …
CUSTOMDATA
Returns the content of the CustomData property in the connection string.
ISBLANK
Checks whether a value is blank, and returns TRUE or FALSE.
ISERROR
Checks whether a value is an error, and returns TRUE or FALSE.
ISEVEN
Returns TRUE if number is even, or FALSE if number is odd.
ISINSCOPE
Returns true when the specified column is the level in a hierarchy of levels.
ISLOGICAL
Checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or …
ISNONTEXT
Checks if a value is not text (blank cells are not text), and returns TRUE …
ISNUMBER
Checks whether a value is a number, and returns TRUE or FALSE.
ISONORAFTER
A boolean function that emulates the behavior of a ‘Start At’ clause and returns true …
ISTEXT
Checks if a value is text, and returns TRUE or FALSE.
LOOKUPVALUE
Returns the value in result_columnName for the row that meets all criteria specified by search_columnName …
USERNAME
Returns the domain name and username from the credentials given to the system at connection …
USEROBJECTID
Returns the current user's Object ID from Azure AD or security identifier (SID).
USERPRINCIPALNAME
Returns the user principal name.