Archive

Returns the current user’s Object ID from Azure AD or security identifier (SID).

Returns the domain name and username from the credentials given to the system at connection time.

Returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.

Checks if a value is text, and returns TRUE or FALSE.

A boolean function that emulates the behavior of a ‘Start At’ clause and returns true for a row that meets all of the condition parameters.

This function takes a variable number of triples, the first two values in a triple are the expressions to be compared, and the third parameter indicates the sort order. The sort order can be ascending (default) or descending.

Based on the sort order, the first parameter is compared with the second parameter. If the sort order is ascending, the comparison to be done is first parameter greater than or equal to second parameter. If the sort order is descending, the comparison to be done is second parameter less than or equal to first parameter.

Checks whether a value is a number, and returns TRUE or FALSE.

Checks if a value is not text (blank cells are not text), and returns TRUE or FALSE.

Checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE.

Returns true when the specified column is the level in a hierarchy of levels.

Returns TRUE if number is even, or FALSE if number is odd.