Reference: Worksheets-Unique Functions

Worksheets functions help you organize and manage your data to see trends and obtain insights.

The functions listed in this table distinguish Worksheets from most other spreadsheet products by providing additional value for data analysis.

Functions in bold text are designed for use as unconstrained array formulas. Submit unconstrained array formulas with the special keyboard shortcut Ctrl+Alt+Enter (Windows) or Command+Option+Enter (Mac) so Worksheets can use the entire range it needs when returning the results.

As a best practice, use absolute references in Worksheets-unique functions wherever possible to minimize the use of system resources. To make a cell reference absolute, add a dollar sign ($) in front of the column letter and row number in the formula. Examples: $Q$45, $T$67, $A$1:$A$10, etc.

The Workday Administrator Guide describes the Worksheets-unique functions. The Worksheets User Guide describes all the functions in Worksheets.

Function Type	Function
Date	CONVERTTZ DATESBETWEEN DATESFROM DATETIME NOWTZ WD.DATEDIF
Engineering	DIMENSIONS IMCOTH IMTANH SETUNITS UNITS
Information	ISBOOLEAN
Logical	IFEMPTY
Lookup	ARRAYAREA IN MATCHEXACT MHLOOKUP MVLOOKUP WD.MVLOOKUP WD.VLOOKUP
Math	CBRT E EXPM1 HYPOT LOG1P RANDCONST RINT WD.MAXIFS WD.MINIFS WD.SUMIF WD.SUMIFS
Matrix	MIDENTITY TRUNCATEMATRIX
Miscellaneous	CAPPEDVALUES CLUSTER.KMEANS CLUSTER.KMEANS.CENTROIDS CORRELATE DISTINCTROWS DISTINCTROWS2 EMAIL GROUPBY INSTANCE INSTANCE.DESCRIPTOR INSTANCE.ID JOIN MATCHCOMPOSITE MERGECOLUMNS MERGEROWS MI.COUNT MI.INDEX MINUS MULTIINST NOTIFYIF NOTIFYIFS REMOVECOLUMNS REMOVEROWS SELECT SORT SORT2 SORT3 TRIMCOLUMNS TRIMROWS UNIQUE UNIQUE2 URL URLTEXT WD.ARRANGECOLUMNS WD.ARRANGEROWS WD.LIVEDATA WD.SLICE
Operator	COMPARE SUBTRACT
Statistical	WD.AVERAGEIF WD.AVERAGEIFS WD.COUNTIF WD.COUNTIFS FORECAST.WD.SEASONAL TDISTRT
Table	FLATTEN VALUEAT
Text	REGEXFIND REGEXPARSE