---
title: "Expressions"
slug: "expressions"
status: "update"
updated: 2026-03-06T22:09:20Z
published: 2026-03-06T22:09:39Z
canonical: "support.tulip.co/expressions"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.tulip.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Expressions

Below is a complete list of expressions in the Tulip platform and the areas that each is available for.

Click on the expression name to navigate to its documentation.

| Function | Description | Available in |
|----------|-------------|--------------|
| [ABS()](https://support.tulip.co/docs/abs%29) | Returns the absolute value of the input | Apps, Automations, Functions |
| [ADD_TIME()](https://support.tulip.co/docs/add-time) | Adds a given duration unit to a given time. If a tz identifier is provided, uses that time zone instead of the local time zone. | Apps, Automations, Functions |
| [ARRAY_AVG()](https://support.tulip.co/docs/array-avg) | Returns the average of a given numeric list | Apps, Automations, Functions |
| [ARRAY_CONCAT()](https://support.tulip.co/docs/array-concat) | Concatenates any number of lists of a single type into a single list of that type | Apps, Automations, Functions |
| [ARRAY_INDEX_OF()](https://support.tulip.co/docs/array-index-of) | Returns the index of the first occurrence of the given value in the given list. If not found, returns -1. | Apps, Automations, Functions |
| [ARRAY_MAX()](https://support.tulip.co/docs/array-max) | Returns the maximum of a given numeric list | Apps, Automations, Functions |
| [ARRAY_MIN()](https://support.tulip.co/docs/array-min) | Returns the minimum of a given numeric list | Apps, Automations, Functions |
| [ARRAY_STDEV_POPULATION()](https://support.tulip.co/docs/array-stdev-population) | Returns the standard deviation of the population of a given numeric list | Apps, Automations, Functions |
| [ARRAY_STDEV_SAMPLE()](https://support.tulip.co/docs/array-stdev-sample) | Returns the standard deviation of the sample of a given numeric list | Apps, Automations, Functions |
| [ARRAY_VALUE_AT_INDEX()](https://support.tulip.co/docs/array-value-at-index) | Returns the value at the given index in the given list. If the index is out of bounds, returns null. | Apps, Automations, Functions |
| [ARRAYCONTAINS()](https://support.tulip.co/docs/arraycontains) | Returns true if the given value is in the given list, false otherwise | Apps, Automations, Functions |
| [AVERAGE()](https://support.tulip.co/docs/average) | Returns the average of its argument | Analysis |
| [AVERAGEFILTERED()](https://support.tulip.co/docs/averagefiltered) | Returns the average of its argument, filtered to completions matching the given condition | Analysis |
| [AVG()](https://support.tulip.co/docs/avg) | Returns the average of its argument | Analysis |
| [AVGFILTERED()](https://support.tulip.co/docs/avgfiltered) | Returns the average of its argument, filtered to completions matching the given condition | Analysis |
| [BADGE_ID_TO_USER()](https://support.tulip.co/docs/badge-id-to-user) | Converts a badge id to a user object | Apps |
| [CEIL()](https://support.tulip.co/docs/ceil) | Rounds up to the nearest integer | Apps, Automations, Analysis, Functions |
| [CONTAINS()](https://support.tulip.co/docs/contains) | Returns whether or not a string contains a given substring | Apps, Automations, Functions |
| [COS()](https://support.tulip.co/docs/cos) | Returns the cosine of the given input in radians | Apps, Automations, Functions |
| [COUNT()](https://support.tulip.co/docs/count) | Returns the number of completions matching the given condition | Analysis |
| [COUNTOFCOMPLETIONS()](https://support.tulip.co/docs/countofcompletions) | Returns the total number of completions. | Analysis |
| [COUNTUNIQUE()](https://support.tulip.co/docs/countunique) | Returns the number of unique results for the given value | Analysis |
| [CURRENTDATEANDTIME()](https://support.tulip.co/docs/currentdateandtime) | Returns the current timestamp as a Datetime value.<br> **Note:** CURRENTDATEANDTIME() is only supported in analyses set to My timezone. | Analysis |
| [DATETIMETOTEXT()](https://support.tulip.co/docs/datetimetotext) | Formats a date to a string. If a tz identifier is provided, uses that time zone instead of the local time zone.  | Apps, Automations, Analysis, Functions |
| [ENCODE_URI_COMPONENT()](https://support.tulip.co/docs/encode-uri-component) | Returns a URL-encoded string version of a URI component. | Apps, Automations, Functions |
| [ENCODE_URI()](https://support.tulip.co/docs/encode-uri) | Returns a URL-encoded string version of a URI. | Apps, Automations, Functions |
| [FILETOTEXT()](https://support.tulip.co/docs/filetotext) | Converts File into text | Apps, Automations, Functions |
| [FIND()](https://support.tulip.co/docs/find) | Finds the starting index of the given substring inside the given string | Apps, Automations, Analysis, Functions |
| [FLOOR()](https://support.tulip.co/docs/floor) | Rounds down to the nearest integer | Apps, Automations, Analysis, Functions |
| [GETDECIMALPLACES()](https://support.tulip.co/docs/getdecimalplaces) | Returns the number of decimal places in a given number | Apps |
| [HEX_TO_INT()](https://support.tulip.co/docs/hex-to-int) | Returns the numeric representation of the given hexadecimal string | Apps, Automations, Functions |
| [IF()](https://support.tulip.co/docs/if) | Returns the second argument if the first argument is true, or the third argument if the first argument is false | Apps, Automations, Analysis, Functions |
| [INT_TO_HEX()](https://support.tulip.co/docs/int-to-hex) | Returns the hexadecimal representation of the given number | Apps, Automations, Functions |
| [INTERVAL_TO_SECONDS()](https://support.tulip.co/docs/interval-to-seconds) | Returns the length of an interval in seconds | Apps, Automations, Analysis, Functions |
| [ISNULL()](https://support.tulip.co/docs/isnull) | Returns true if the argument is null, otherwise false | Apps, Automations, Analysis, Functions |
| [LEFT()](https://support.tulip.co/docs/left) | Returns a substring containing n characters starting from the left | Apps, Automations, Analysis, Functions |
| [LEN()](https://support.tulip.co/docs/len) | Returns the length of the input | Apps, Automations, Analysis, Functions |
| [LINK()](https://support.tulip.co/docs/link) | Returns the first non-null argument. Takes any number of same-type arguments. | Apps, Automations, Analysis, Functions |
| [LOWERCASE()](https://support.tulip.co/docs/lowercase) | Converts string to be all lowercase | Apps, Automations, Analysis, Functions |
| [MAP_TO_BOOLEAN_LIST()](https://support.tulip.co/docs/map-to-boolean-list) | Converts an object list to base list for the given key | Apps, Automations, Functions |
| [MAP_TO_INTEGER_LIST()](https://support.tulip.co/docs/map-to-integer-list) | Converts an object list to base list for the given key | Apps, Automations, Functions |
| [MAP_TO_NUMBER_LIST()](https://support.tulip.co/docs/map-to-number-list) | Converts an object list to base list for the given key | Apps, Automations, Functions |
| [MAP_TO_TEXT_LIST()](https://support.tulip.co/docs/map-to-text-list) | Converts an object list to base list for the given key | Apps, Automations, Functions |
| [MAX()](https://support.tulip.co/docs/max) | Returns the maximum of the given values | Apps, Automations, Functions |
| [MAXFILTERED()](https://support.tulip.co/docs/maxfiltered) | Returns the maximum of its argument, filtered to completions matching the given condition | Analysis |
| [MAXIMUM()](https://support.tulip.co/docs/maximum) | Returns the maximum of its argument | Analysis |
| [MAXIMUMFILTERED()](https://support.tulip.co/docs/maximumfiltered) | Returns the maximum of its argument, filtered to completions matching the given condition | Analysis |
| [MID()](https://support.tulip.co/docs/mid) | Returns a substring containing n characters starting from start | Apps, Automations, Analysis, Functions |
| [MIN()](https://support.tulip.co/docs/min) | Returns the minimum of the given values | Apps, Automations, Functions |
| [MINFILTERED()](https://support.tulip.co/docs/minfiltered) | Returns the minimum of its argument, filtered to completions matching the given condition | Analysis |
| [MINIMUM()](https://support.tulip.co/docs/minimum) | Returns the minimum of its argument | Analysis |
| [MINIMUMFILTERED()](https://support.tulip.co/docs/minimumfiltered) | Returns the minimum of its argument, filtered to completions matching the given condition | Analysis |
| [NULLIF()](https://support.tulip.co/docs/nullif) | Returns null if the first argument equals the second argument, otherwise returns the first argument | Apps, Automations, Analysis, Functions |
| [POW()](https://support.tulip.co/docs/pow) | Returns the first argument raised to power of the second argument | Apps, Automations, Functions |
| [RAND()](https://support.tulip.co/docs/rand) | Generates a random decimal number between 0 and 1 | Apps, Automations, Functions |
| [RANDBETWEEN()](https://support.tulip.co/docs/randbetween) | Generates a random number between (and including) the two numbers provided | Apps, Automations, Functions |
| [RANDOM_COLOR()](https://support.tulip.co/docs/random-color) | Generates a random color | Apps, Automations, Functions |
| [RANDOMSTRING()](https://support.tulip.co/docs/randomstring) | Returns a random 17-character string | Apps, Automations, Functions |
| [REGEX_MATCH()](https://support.tulip.co/docs/regex-match) | Returns a list of matches to the regular expression | Apps, Automations, Analysis, Functions |
| [REGEX_REPLACE()](https://support.tulip.co/docs/regex-replace) | Replaces content in text using a regular expression | Apps, Automations, Functions |
| [RGB()](https://support.tulip.co/docs/rgb) | Returns a color of the specified red, green, and blue components | Apps, Automations, Functions |
| [RGBA()](https://support.tulip.co/docs/rgba) | Returns a color of the specified red, green, blue, and alpha components | Apps, Automations, Functions |
| [RIGHT()](https://support.tulip.co/docs/right) | Returns a substring containing n characters starting from the right | Apps, Automations, Analysis, Functions |
| [ROUND()](https://support.tulip.co/docs/round) | Rounds a number to the specified number of decimal places. If decimal places are negative or not specified, rounds to the nearest integer. | Apps, Automations, Analysis, Functions |
| [ROUNDDATETIME()](https://support.tulip.co/docs/rounddatetime) | Truncates a date to the given unit. If a tz identifier is provided, uses that time zone instead of the local time zone. | Apps, Automations, Analysis, Functions |
| [SECONDS_TO_INTERVAL()](https://support.tulip.co/docs/seconds-to-interval)  | Converts seconds into an interval | Apps, Automations, Analysis, Functions |
| [SIN()](https://support.tulip.co/docs/sin) | Returns the sine of the given input in radians | Apps, Automations, Functions |
| [SPLIT()](https://support.tulip.co/docs/split) | Splits text on the given delimiter | Apps, Automations, Analysis, Functions |
| [SQRT()](https://support.tulip.co/docs/sqrt) | Returns the square root of a number | Apps, Automations, Functions |
| [SUBSTITUTE()](https://support.tulip.co/docs/substitute) | Replaces text from given string with another string | Apps, Automations, Analysis, Functions |
| [SUBTRACT_TIME()](https://support.tulip.co/docs/subtract-time) | Subtracts a given duration unit from a given time. If a tz identifier is provided, uses that time zone instead of the local time zone. | Apps, Automations, Functions |
| [SUM()](https://support.tulip.co/docs/sum) | Returns the sum of its argument | Analysis |
| [SUMFILTERED()](https://support.tulip.co/docs/sumfiltered) | Returns the sum of its argument, filtered to completions matching the given condition | Analysis |
| [TAN()](https://support.tulip.co/docs/tan) | Returns the tangent value of the input in radians | Apps, Automations, Functions |
| [TEXTTOBOOLEAN()](https://support.tulip.co/docs/texttoboolean) | Parses text into a boolean.  “y”, “yes”, “t”, “true”, and “on” (and any capitalized variants) are recognized as true, and “n”, “no”, “f”, “false”, and “off” are recognized as false | Apps, Automations, Analysis, Functions |
| [TEXTTODATETIME()](https://support.tulip.co/docs/texttodatetime) | Parses a datetime from text and format. If a tz identifier is provided, uses that time zone instead of the local time zone.  | Apps, Automations, Analysis, Functions |
| [TEXTTOFILE()](https://support.tulip.co/docs/texttofile) | Converts text into a File | Apps, Automations, Functions |
| [TEXTTOIMAGEURL()](https://support.tulip.co/docs/texttoimageurl) | Converts text into an image URL | Apps, Automations, Functions |
| [TEXTTOINTEGER()](https://support.tulip.co/docs/texttointeger) | Parses text into a integer | Apps, Automations, Analysis, Functions |
| [TEXTTONUMBER()](https://support.tulip.co/docs/texttonumber) | Parses text or a timestamp into a number | Apps, Automations, Analysis, Functions |
| [TOPLAINTEXT()](https://support.tulip.co/docs/toplaintext) | Parses anything into text. Numbers are treated as strings in objects and lists to support precision. | Apps, Automations, Functions |
| [TOTEXT()](https://support.tulip.co/docs/totext) | Parses anything into text | Apps, Automations, Analysis, Functions |
| [TRIM()](https://support.tulip.co/docs/trim) | Trims the given character(s) from the ends of the given string | Apps, Automations, Analysis, Functions |
| [UPPERCASE()](https://support.tulip.co/docs/uppercase) | Converts string to be all uppercase | Apps, Automations, Analysis, Functions |
| [USER_ID_TO_USER()](https://support.tulip.co/docs/user-id-to-user) | Converts a user id to a user object | Apps |