Below is a list of all available formula functions in Layer. Read technical documentation in Layer →

List

ARRAY(value1, value2, ...)

• Creates an array from a list of values.

• All values must be of the same type.

ARRAYAT(array, index)

• Gets the value at a specified index in an array.

ARRAYFLATTEN(array)

• Expands an array of objects with quantity into a flat array.

• Repeats each object according to its quantity and sets quantity to 1.

ARRAYJOIN(array, delimiter)

• Joins an array of strings into a single string.

ARRAYLENGTH(array)

• Returns the number of items in an array.

AVERAGE(numbers)

• Calculates the average of an array of numbers.

COUNTEMPTY(values)

• Counts the number of empty values in an array.

• An empty value is anything that is not a number, a string that is empty or only contains whitespace, or a falsy boolean value.

COUNTNOTEMPTY(values)

• Counts the number of non-empty values in an array.

• A non-empty value is a number, a string that is not empty and contains more than whitespace, or a truthy boolean value.

FIRST(array)

• Gets the value at the first index in an array.

LAST(array)

• Gets the value at the last index in an array.

MATRIXMULTIPLY(array1, array2)

• Multiplies two arrays of numbers element-wise.

• If arrays have different lengths, the shorter one is padded with 0s.

MAX(numbers)

• Returns the maximum value from a list of numbers.

MEDIAN(numbers)

• Calculates the median of an array of numbers.

MIN(numbers)

• Returns the minimum value from a list of numbers.

PRODUCT(numbers)

• Multiplies all numbers in an array.

RANGE(numbers)

• Returns the difference between the highest and lowest numerical values in an array.

SUM(numbers)

• Sums an array of numerical values.

UNIQUE(values)

• Consolidates an array by combining equivalent values and storing the quantity on the returned value.

Text

CONCATENATE(text1, text2, ...)

• Concatenates two or more strings into one.

DATE(value)

• Converts a value to a date.

ENCODEURICOMPONENT(text)

• Replaces characters with encoded equivalents for use in constructing URLs or URIs.

EQUALS(value1, value2)

• Checks if two values are equal.

• Inputs must be of the same type to be considered equal.

LEFT(text, count)

• Extracts a substring of the specified size from the start of a string.

LENGTH(text)

• Returns the number of characters in a string.

LOWER(text)

• Converts a string to all lowercase.

MID(text, start_index, length)

• Extracts a substring from a string.

NOTEQUALS(value1, value2)

• Checks if two values are not equal.

REGEXEXTRACT(text, pattern)

• Extracts a substring that matches a regular expression.

REGEXMATCH(text, pattern)

• Checks if a string matches a regular expression.

REGEXREPLACE(text, pattern, replacement)

• Replaces a substring that matches a regular expression.

REPEAT(text, count)

• Repeats a string a specified number of times.

RIGHT(text, count)

• Extracts a substring of the specified size from the end of a string.

SEARCH(text, search_text)

• Searches a string for another string and returns the index position of the found string.

• Returns 1 if not found.

SUBSTITUTE(text, search_text, replacement_text)

• Substitutes a string with another string.

TRIM(text)

• Trims whitespace from a string.

UPPER(text)

• Converts a string to all uppercase.

Date

DATEADDDAYS(date, days)

• Adds a specified number of days to a date.

DATEADDHOURS(date, hours)

• Adds a specified number of hours to a date.

DATEADDMINUTES(date, minutes)

• Adds a specified number of minutes to a date.

DATEADDMONTHS(date, months)

• Adds a specified number of months to a date.

DATEADDSECONDS(date, seconds)

• Adds a specified number of seconds to a date.

DATEADDWEEKS(date, weeks)

• Adds a specified number of weeks to a date.

DATEADDYEARS(date, years)

• Adds a specified number of years to a date.

DATEISAFTER(date1, date2)

• Checks if the first date is after the second date.

DATEISBEFORE(date1, date2)

• Checks if the first date is before the second date.

DATEISSAME(date1, date2)

• Checks if two dates are the same.

DATEISSAMEDAY(date1, date2)

• Checks if two dates are on the same day.

DATEISSAMEHOUR(date1, date2)

• Checks if two dates are in the same hour.

DATEISSAMEMINUTE(date1, date2)

• Checks if two dates are in the same minute.

DATEISSAMEMONTH(date1, date2)

• Checks if two dates are in the same month.

DATEISSAMEWEEK(date1, date2)

• Checks if two dates are in the same week.

DATEISSAMEYEAR(date1, date2)

• Checks if two dates are in the same year.

DATESUBTRACTDAYS(date, days)

• Subtracts a specified number of days from a date.

DATESUBTRACTHOURS(date, hours)

• Subtracts a specified number of hours from a date.

DATESUBTRACTMINUTES(date, minutes)

• Subtracts a specified number of minutes from a date.

DATESUBTRACTMONTHS(date, months)

• Subtracts a specified number of months from a date.

DATESUBTRACTSECONDS(date, seconds)

• Subtracts a specified number of seconds from a date.

DATESUBTRACTWEEKS(date, weeks)

• Subtracts a specified number of weeks from a date.

DATESUBTRACTYEARS(date, years)

• Subtracts a specified number of years from a date.

DATETOSTRING(date, format)

• Converts a date to a string using date-fns format tokens.

DAY(date)

• Returns the day of the week for a date as a number 0–6, where 0 is Sunday.

HOUR(date)

• Returns the hour of the day for a date.

ISWEEKDAY(date)

• Checks if a date is a weekday Monday-Friday.

ISWEEKEND(date)

• Checks if a date is a weekend Saturday-Sunday.

MONTH(date)

• Returns the month for a date as a number 0–11, where 0 is January.

WEEK(date)

• Returns the week number for a date using the ISO week numbering system.

• The first day of the week is Monday.

YEAR(date)

• Returns the year for a date.

No Input

FALSE()

• Returns the logical value false.

NOW()

• Returns the current date and time when the formula is executed.

PI()

• Returns the value of PI.

TRUE()

• Returns the logical value true.

Any

IF(condition, value_if_true, value_if_false)

• Returns a value based on a condition.

Null

LENGTH(text)

• Returns the number of characters in a string.

• Accepts null as an input.