--- title: Functions url: https://www.tines.com/docs/formulas/functions/ updated: 2026-07-16T11:20:58+00:00 --- *[tines.com](https://www.tines.com/llms.txt) › [Docs](https://www.tines.com/docs/llms.txt) › [Formulas](https://www.tines.com/llm/docs/formulas.md)* # Functions *[View on tines.com](https://www.tines.com/docs/formulas/functions/)* ## Function index ### Numbers - [ABS](https://www.tines.com/llm/docs/formulas/functions/abs.md) - [ACOS](https://www.tines.com/llm/docs/formulas/functions/acos.md) - [ASIN](https://www.tines.com/llm/docs/formulas/functions/asin.md) - [AT_LEAST](https://www.tines.com/llm/docs/formulas/functions/at-least.md) - [AT_MOST](https://www.tines.com/llm/docs/formulas/functions/at-most.md) - [AVERAGE](https://www.tines.com/llm/docs/formulas/functions/average.md) - [CEIL](https://www.tines.com/llm/docs/formulas/functions/ceil.md) - [CLAMP](https://www.tines.com/llm/docs/formulas/functions/clamp.md) - [COS](https://www.tines.com/llm/docs/formulas/functions/cos.md) - [DIVIDED_BY](https://www.tines.com/llm/docs/formulas/functions/divided-by.md) - [ESTIMATED_TOKEN_COUNT](https://www.tines.com/llm/docs/formulas/functions/estimated-token-count.md) - [FLOOR](https://www.tines.com/llm/docs/formulas/functions/floor.md) - [IS_BLANK](https://www.tines.com/llm/docs/formulas/functions/is-blank.md) - [IS_PRESENT](https://www.tines.com/llm/docs/formulas/functions/is-present.md) - [MAX](https://www.tines.com/llm/docs/formulas/functions/max.md) - [MEDIAN](https://www.tines.com/llm/docs/formulas/functions/median.md) - [MIN](https://www.tines.com/llm/docs/formulas/functions/min.md) - [MINUS](https://www.tines.com/llm/docs/formulas/functions/minus.md) - [MODULO](https://www.tines.com/llm/docs/formulas/functions/modulo.md) - [NUMBER](https://www.tines.com/llm/docs/formulas/functions/number.md) - [PLUS](https://www.tines.com/llm/docs/formulas/functions/plus.md) - [POWER](https://www.tines.com/llm/docs/formulas/functions/power.md) - [RANDOM](https://www.tines.com/llm/docs/formulas/functions/random.md) - [ROUND](https://www.tines.com/llm/docs/formulas/functions/round.md) - [SIN](https://www.tines.com/llm/docs/formulas/functions/sin.md) - [SQRT](https://www.tines.com/llm/docs/formulas/functions/sqrt.md) - [SUM](https://www.tines.com/llm/docs/formulas/functions/sum.md) - [TIMES](https://www.tines.com/llm/docs/formulas/functions/times.md) ### Encryption - [AES_DECRYPT](https://www.tines.com/llm/docs/formulas/functions/aes-decrypt.md) - [AES_ENCRYPT](https://www.tines.com/llm/docs/formulas/functions/aes-encrypt.md) - [GENERATE_RSA_KEYS](https://www.tines.com/llm/docs/formulas/functions/generate-rsa-keys.md) - [OPENSSL_DECRYPT](https://www.tines.com/llm/docs/formulas/functions/openssl-decrypt.md) - [OPENSSL_ENCRYPT](https://www.tines.com/llm/docs/formulas/functions/openssl-encrypt.md) - [RSA_AES_HYBRID_DECRYPT](https://www.tines.com/llm/docs/formulas/functions/rsa-aes-hybrid-decrypt.md) - [RSA_AES_HYBRID_ENCRYPT](https://www.tines.com/llm/docs/formulas/functions/rsa-aes-hybrid-encrypt.md) - [RSA_DECRYPT](https://www.tines.com/llm/docs/formulas/functions/rsa-decrypt.md) - [RSA_ENCRYPT](https://www.tines.com/llm/docs/formulas/functions/rsa-encrypt.md) - [RSA_SIGN](https://www.tines.com/llm/docs/formulas/functions/rsa-sign.md) - [TINES_DECRYPT](https://www.tines.com/llm/docs/formulas/functions/tines-decrypt.md) - [TINES_ENCRYPT](https://www.tines.com/llm/docs/formulas/functions/tines-encrypt.md) ### Logic - [AND](https://www.tines.com/llm/docs/formulas/functions/and.md) - [DEFAULT](https://www.tines.com/llm/docs/formulas/functions/default.md) - [ERROR](https://www.tines.com/llm/docs/formulas/functions/error.md) - [IF](https://www.tines.com/llm/docs/formulas/functions/if.md) - [IF_ERROR](https://www.tines.com/llm/docs/formulas/functions/if-error.md) - [IS_BLANK](https://www.tines.com/llm/docs/formulas/functions/is-blank.md) - [IS_PRESENT](https://www.tines.com/llm/docs/formulas/functions/is-present.md) - [NOT](https://www.tines.com/llm/docs/formulas/functions/not.md) - [OR](https://www.tines.com/llm/docs/formulas/functions/or.md) - [SWITCH](https://www.tines.com/llm/docs/formulas/functions/switch.md) ### Text - [APPEND](https://www.tines.com/llm/docs/formulas/functions/append.md) - [BYTESIZE](https://www.tines.com/llm/docs/formulas/functions/bytesize.md) - [CAMELIZE](https://www.tines.com/llm/docs/formulas/functions/camelize.md) - [CAPITALIZE](https://www.tines.com/llm/docs/formulas/functions/capitalize.md) - [CLAMP](https://www.tines.com/llm/docs/formulas/functions/clamp.md) - [CONST_EQUALS](https://www.tines.com/llm/docs/formulas/functions/const-equals.md) - [CONTAINS_URL](https://www.tines.com/llm/docs/formulas/functions/contains-url.md) - [DEFAULT](https://www.tines.com/llm/docs/formulas/functions/default.md) - [DOWNCASE](https://www.tines.com/llm/docs/formulas/functions/downcase.md) - [ENDS_WITH](https://www.tines.com/llm/docs/formulas/functions/ends-with.md) - [ESCAPE](https://www.tines.com/llm/docs/formulas/functions/escape.md) - [ESCAPE_ONCE](https://www.tines.com/llm/docs/formulas/functions/escape-once.md) - [ESTIMATED_TOKEN_COUNT](https://www.tines.com/llm/docs/formulas/functions/estimated-token-count.md) - [FORCE_ARRAY](https://www.tines.com/llm/docs/formulas/functions/force-array.md) - [HTML_DECODE](https://www.tines.com/llm/docs/formulas/functions/html-decode.md) - [HTML_ENCODE](https://www.tines.com/llm/docs/formulas/functions/html-encode.md) - [INCLUDES](https://www.tines.com/llm/docs/formulas/functions/includes.md) - [INDEX_OF](https://www.tines.com/llm/docs/formulas/functions/index-of.md) - [IS_BLANK](https://www.tines.com/llm/docs/formulas/functions/is-blank.md) - [IS_EMAIL](https://www.tines.com/llm/docs/formulas/functions/is-email.md) - [IS_EMPTY](https://www.tines.com/llm/docs/formulas/functions/is-empty.md) - [IS_IPV4](https://www.tines.com/llm/docs/formulas/functions/is-ipv4.md) - [IS_IPV6](https://www.tines.com/llm/docs/formulas/functions/is-ipv6.md) - [IS_JSON](https://www.tines.com/llm/docs/formulas/functions/is-json.md) - [IS_PRESENT](https://www.tines.com/llm/docs/formulas/functions/is-present.md) - [IS_URL](https://www.tines.com/llm/docs/formulas/functions/is-url.md) - [IS_XML](https://www.tines.com/llm/docs/formulas/functions/is-xml.md) - [IS_YAML](https://www.tines.com/llm/docs/formulas/functions/is-yaml.md) - [LAST_INDEX_OF](https://www.tines.com/llm/docs/formulas/functions/last-index-of.md) - [LEGACY_STRINGIFY](https://www.tines.com/llm/docs/formulas/functions/legacy-stringify.md) - [LEVENSHTEIN_DISTANCE](https://www.tines.com/llm/docs/formulas/functions/levenshtein-distance.md) - [LSTRIP](https://www.tines.com/llm/docs/formulas/functions/lstrip.md) - [MATCH](https://www.tines.com/llm/docs/formulas/functions/match.md) - [NEWLINE_TO_BR](https://www.tines.com/llm/docs/formulas/functions/newline-to-br.md) - [PAD_LEFT](https://www.tines.com/llm/docs/formulas/functions/pad-left.md) - [PAD_RIGHT](https://www.tines.com/llm/docs/formulas/functions/pad-right.md) - [PLURALIZE](https://www.tines.com/llm/docs/formulas/functions/pluralize.md) - [PREPEND](https://www.tines.com/llm/docs/formulas/functions/prepend.md) - [RANDOM_STRING](https://www.tines.com/llm/docs/formulas/functions/random-string.md) - [REGEX_EXTRACT](https://www.tines.com/llm/docs/formulas/functions/regex-extract.md) - [REGEX_REPLACE](https://www.tines.com/llm/docs/formulas/functions/regex-replace.md) - [REMOVE](https://www.tines.com/llm/docs/formulas/functions/remove.md) - [REMOVE_FIRST](https://www.tines.com/llm/docs/formulas/functions/remove-first.md) - [REPLACE](https://www.tines.com/llm/docs/formulas/functions/replace.md) - [REPLACE_FIRST](https://www.tines.com/llm/docs/formulas/functions/replace-first.md) - [RSTRIP](https://www.tines.com/llm/docs/formulas/functions/rstrip.md) - [SIZE](https://www.tines.com/llm/docs/formulas/functions/size.md) - [SLICE](https://www.tines.com/llm/docs/formulas/functions/slice.md) - [SPLIT](https://www.tines.com/llm/docs/formulas/functions/split.md) - [STARTS_WITH](https://www.tines.com/llm/docs/formulas/functions/starts-with.md) - [STRIP](https://www.tines.com/llm/docs/formulas/functions/strip.md) - [STRIP_HTML](https://www.tines.com/llm/docs/formulas/functions/strip-html.md) - [STRIP_NEWLINES](https://www.tines.com/llm/docs/formulas/functions/strip-newlines.md) - [TEXT](https://www.tines.com/llm/docs/formulas/functions/text.md) - [TITLEIZE](https://www.tines.com/llm/docs/formulas/functions/titleize.md) - [TO_SNAKE_CASE](https://www.tines.com/llm/docs/formulas/functions/to-snake-case.md) - [TRANSLITERATE](https://www.tines.com/llm/docs/formulas/functions/transliterate.md) - [TRUNCATE](https://www.tines.com/llm/docs/formulas/functions/truncate.md) - [TRUNCATEWORDS](https://www.tines.com/llm/docs/formulas/functions/truncatewords.md) - [UPCASE](https://www.tines.com/llm/docs/formulas/functions/upcase.md) - [URL_DECODE](https://www.tines.com/llm/docs/formulas/functions/url-decode.md) - [URL_ENCODE](https://www.tines.com/llm/docs/formulas/functions/url-encode.md) - [UUID](https://www.tines.com/llm/docs/formulas/functions/uuid.md) ### Arrays - [ARRAY](https://www.tines.com/llm/docs/formulas/functions/array.md) - [CHUNK_ARRAY](https://www.tines.com/llm/docs/formulas/functions/chunk-array.md) - [COMPACT](https://www.tines.com/llm/docs/formulas/functions/compact.md) - [CONCAT](https://www.tines.com/llm/docs/formulas/functions/concat.md) - [COUNTIF](https://www.tines.com/llm/docs/formulas/functions/countif.md) - [DEFAULT](https://www.tines.com/llm/docs/formulas/functions/default.md) - [DELETE](https://www.tines.com/llm/docs/formulas/functions/delete.md) - [DIFFERENCE](https://www.tines.com/llm/docs/formulas/functions/difference.md) - [ESTIMATED_TOKEN_COUNT](https://www.tines.com/llm/docs/formulas/functions/estimated-token-count.md) - [FILTER](https://www.tines.com/llm/docs/formulas/functions/filter.md) - [FIND](https://www.tines.com/llm/docs/formulas/functions/find.md) - [FIRST](https://www.tines.com/llm/docs/formulas/functions/first.md) - [FLATTEN](https://www.tines.com/llm/docs/formulas/functions/flatten.md) - [GROUP_BY](https://www.tines.com/llm/docs/formulas/functions/group-by.md) - [INCLUDES](https://www.tines.com/llm/docs/formulas/functions/includes.md) - [INDEX_OF](https://www.tines.com/llm/docs/formulas/functions/index-of.md) - [INSERT](https://www.tines.com/llm/docs/formulas/functions/insert.md) - [INTERSECTION](https://www.tines.com/llm/docs/formulas/functions/intersection.md) - [IS_BLANK](https://www.tines.com/llm/docs/formulas/functions/is-blank.md) - [IS_EMPTY](https://www.tines.com/llm/docs/formulas/functions/is-empty.md) - [IS_PRESENT](https://www.tines.com/llm/docs/formulas/functions/is-present.md) - [JOIN](https://www.tines.com/llm/docs/formulas/functions/join.md) - [LAST](https://www.tines.com/llm/docs/formulas/functions/last.md) - [LAST_INDEX_OF](https://www.tines.com/llm/docs/formulas/functions/last-index-of.md) - [MAP](https://www.tines.com/llm/docs/formulas/functions/map.md) - [PUSH](https://www.tines.com/llm/docs/formulas/functions/push.md) - [RANDOM_ELEMENT](https://www.tines.com/llm/docs/formulas/functions/random-element.md) - [RANGE](https://www.tines.com/llm/docs/formulas/functions/range.md) - [REJECT](https://www.tines.com/llm/docs/formulas/functions/reject.md) - [REVERSE](https://www.tines.com/llm/docs/formulas/functions/reverse.md) - [ROTATE](https://www.tines.com/llm/docs/formulas/functions/rotate.md) - [SHUFFLE](https://www.tines.com/llm/docs/formulas/functions/shuffle.md) - [SIZE](https://www.tines.com/llm/docs/formulas/functions/size.md) - [SLICE_ARRAY](https://www.tines.com/llm/docs/formulas/functions/slice-array.md) - [SORT](https://www.tines.com/llm/docs/formulas/functions/sort.md) - [SORT_NATURAL](https://www.tines.com/llm/docs/formulas/functions/sort-natural.md) - [SUM](https://www.tines.com/llm/docs/formulas/functions/sum.md) - [TALLY](https://www.tines.com/llm/docs/formulas/functions/tally.md) - [UNION](https://www.tines.com/llm/docs/formulas/functions/union.md) - [UNIQ](https://www.tines.com/llm/docs/formulas/functions/uniq.md) - [WHERE](https://www.tines.com/llm/docs/formulas/functions/where.md) ### Data Parsing/Conversion - [BASE64URL_DECODE](https://www.tines.com/llm/docs/formulas/functions/base64url-decode.md) - [BASE64URL_ENCODE](https://www.tines.com/llm/docs/formulas/functions/base64url-encode.md) - [BASE64_DECODE](https://www.tines.com/llm/docs/formulas/functions/base64-decode.md) - [BASE64_ENCODE](https://www.tines.com/llm/docs/formulas/functions/base64-encode.md) - [COMBINE_COLUMNS_AND_ROWS](https://www.tines.com/llm/docs/formulas/functions/combine-columns-and-rows.md) - [CSV_PARSE](https://www.tines.com/llm/docs/formulas/functions/csv-parse.md) - [CSV_PARSE_TO_OBJECTS](https://www.tines.com/llm/docs/formulas/functions/csv-parse-to-objects.md) - [EML_PARSE](https://www.tines.com/llm/docs/formulas/functions/eml-parse.md) - [GUNZIP](https://www.tines.com/llm/docs/formulas/functions/gunzip.md) - [GZIP](https://www.tines.com/llm/docs/formulas/functions/gzip.md) - [HCL_PARSE](https://www.tines.com/llm/docs/formulas/functions/hcl-parse.md) - [HEX_PARSE](https://www.tines.com/llm/docs/formulas/functions/hex-parse.md) - [JSON_PARSE](https://www.tines.com/llm/docs/formulas/functions/json-parse.md) - [JWK_TO_PEM](https://www.tines.com/llm/docs/formulas/functions/jwk-to-pem.md) - [LDIF_PARSE](https://www.tines.com/llm/docs/formulas/functions/ldif-parse.md) - [MIME_HEADER_DECODE](https://www.tines.com/llm/docs/formulas/functions/mime-header-decode.md) - [MSG_PARSE](https://www.tines.com/llm/docs/formulas/functions/msg-parse.md) - [NEAT_JSON](https://www.tines.com/llm/docs/formulas/functions/neat-json.md) - [OBJECTS_TO_CSV](https://www.tines.com/llm/docs/formulas/functions/objects-to-csv.md) - [OBJECTS_TO_MARKDOWN_TABLE](https://www.tines.com/llm/docs/formulas/functions/objects-to-markdown-table.md) - [PARSE_URL](https://www.tines.com/llm/docs/formulas/functions/parse-url.md) - [PEM_TO_JWK](https://www.tines.com/llm/docs/formulas/functions/pem-to-jwk.md) - [TAR](https://www.tines.com/llm/docs/formulas/functions/tar.md) - [TO_CSV](https://www.tines.com/llm/docs/formulas/functions/to-csv.md) - [TO_HEX](https://www.tines.com/llm/docs/formulas/functions/to-hex.md) - [TO_JSON](https://www.tines.com/llm/docs/formulas/functions/to-json.md) - [TO_XML](https://www.tines.com/llm/docs/formulas/functions/to-xml.md) - [TO_YAML](https://www.tines.com/llm/docs/formulas/functions/to-yaml.md) - [UNTAR](https://www.tines.com/llm/docs/formulas/functions/untar.md) - [UNZIP](https://www.tines.com/llm/docs/formulas/functions/unzip.md) - [XML_PARSE](https://www.tines.com/llm/docs/formulas/functions/xml-parse.md) - [YAML_PARSE](https://www.tines.com/llm/docs/formulas/functions/yaml-parse.md) - [ZIP](https://www.tines.com/llm/docs/formulas/functions/zip.md) ### Lambdas - [COUNTIF](https://www.tines.com/llm/docs/formulas/functions/countif.md) - [FILTER](https://www.tines.com/llm/docs/formulas/functions/filter.md) - [FIND](https://www.tines.com/llm/docs/formulas/functions/find.md) - [LAMBDA](https://www.tines.com/llm/docs/formulas/functions/lambda.md) - [MAP_LAMBDA](https://www.tines.com/llm/docs/formulas/functions/map-lambda.md) - [REDUCE](https://www.tines.com/llm/docs/formulas/functions/reduce.md) - [REJECT](https://www.tines.com/llm/docs/formulas/functions/reject.md) ### Dates/Times - [DATE](https://www.tines.com/llm/docs/formulas/functions/date.md) - [DATE_DIFF](https://www.tines.com/llm/docs/formulas/functions/date-diff.md) - [DATE_PARSE](https://www.tines.com/llm/docs/formulas/functions/date-parse.md) - [DAY](https://www.tines.com/llm/docs/formulas/functions/day.md) - [DISTANCE_OF_TIME_IN_WORDS](https://www.tines.com/llm/docs/formulas/functions/distance-of-time-in-words.md) - [HOUR](https://www.tines.com/llm/docs/formulas/functions/hour.md) - [MINUTE](https://www.tines.com/llm/docs/formulas/functions/minute.md) - [MONTH](https://www.tines.com/llm/docs/formulas/functions/month.md) - [NOW](https://www.tines.com/llm/docs/formulas/functions/now.md) - [SECOND](https://www.tines.com/llm/docs/formulas/functions/second.md) - [TODAY](https://www.tines.com/llm/docs/formulas/functions/today.md) - [UNIX_TIMESTAMP](https://www.tines.com/llm/docs/formulas/functions/unix-timestamp.md) - [YEAR](https://www.tines.com/llm/docs/formulas/functions/year.md) ### Objects - [DEEP_MERGE](https://www.tines.com/llm/docs/formulas/functions/deep-merge.md) - [ESTIMATED_TOKEN_COUNT](https://www.tines.com/llm/docs/formulas/functions/estimated-token-count.md) - [FILTER](https://www.tines.com/llm/docs/formulas/functions/filter.md) - [FLATTEN_JSON](https://www.tines.com/llm/docs/formulas/functions/flatten-json.md) - [GET](https://www.tines.com/llm/docs/formulas/functions/get.md) - [INCLUDES](https://www.tines.com/llm/docs/formulas/functions/includes.md) - [IS_BLANK](https://www.tines.com/llm/docs/formulas/functions/is-blank.md) - [IS_EMPTY](https://www.tines.com/llm/docs/formulas/functions/is-empty.md) - [IS_PRESENT](https://www.tines.com/llm/docs/formulas/functions/is-present.md) - [IS_VALID_JSON_SCHEMA](https://www.tines.com/llm/docs/formulas/functions/is-valid-json-schema.md) - [JSONPATH](https://www.tines.com/llm/docs/formulas/functions/jsonpath.md) - [JSON_SCHEMA_VALIDATE](https://www.tines.com/llm/docs/formulas/functions/json-schema-validate.md) - [KEYS](https://www.tines.com/llm/docs/formulas/functions/keys.md) - [MERGE](https://www.tines.com/llm/docs/formulas/functions/merge.md) - [OBJECT](https://www.tines.com/llm/docs/formulas/functions/object.md) - [REJECT](https://www.tines.com/llm/docs/formulas/functions/reject.md) - [REMOVE_KEY](https://www.tines.com/llm/docs/formulas/functions/remove-key.md) - [SET_KEY](https://www.tines.com/llm/docs/formulas/functions/set-key.md) - [UNFLATTEN_JSON](https://www.tines.com/llm/docs/formulas/functions/unflatten-json.md) - [VALUES](https://www.tines.com/llm/docs/formulas/functions/values.md) - [WHERE](https://www.tines.com/llm/docs/formulas/functions/where.md) ### Hashing/Signing - [HMAC_SHA1](https://www.tines.com/llm/docs/formulas/functions/hmac-sha1.md) - [HMAC_SHA1_BASE64](https://www.tines.com/llm/docs/formulas/functions/hmac-sha1-base64.md) - [HMAC_SHA256](https://www.tines.com/llm/docs/formulas/functions/hmac-sha256.md) - [HMAC_SHA256_BASE64](https://www.tines.com/llm/docs/formulas/functions/hmac-sha256-base64.md) - [JWT_DECODE](https://www.tines.com/llm/docs/formulas/functions/jwt-decode.md) - [JWT_SIGN](https://www.tines.com/llm/docs/formulas/functions/jwt-sign.md) - [MD5](https://www.tines.com/llm/docs/formulas/functions/md5.md) - [MD5_BASE64](https://www.tines.com/llm/docs/formulas/functions/md5-base64.md) - [SHA1](https://www.tines.com/llm/docs/formulas/functions/sha1.md) - [SHA256](https://www.tines.com/llm/docs/formulas/functions/sha256.md) - [SHA256_BASE64](https://www.tines.com/llm/docs/formulas/functions/sha256-base64.md) - [SHA512](https://www.tines.com/llm/docs/formulas/functions/sha512.md) - [ZSCALER_OBFUSCATE_API_KEY](https://www.tines.com/llm/docs/formulas/functions/zscaler-obfuscate-api-key.md) ### IP Addresses - [IN_CIDR](https://www.tines.com/llm/docs/formulas/functions/in-cidr.md) - [IS_IPV4](https://www.tines.com/llm/docs/formulas/functions/is-ipv4.md) - [IS_IPV6](https://www.tines.com/llm/docs/formulas/functions/is-ipv6.md) - [IS_IP_ADDRESS](https://www.tines.com/llm/docs/formulas/functions/is-ip-address.md) ### Story Metadata - [PROMPT](https://www.tines.com/llm/docs/formulas/functions/prompt.md) - [STORY_RUN_GUID](https://www.tines.com/llm/docs/formulas/functions/story-run-guid.md) - [STORY_RUN_LINK](https://www.tines.com/llm/docs/formulas/functions/story-run-link.md) - [WORKBENCH_LINK](https://www.tines.com/llm/docs/formulas/functions/workbench-link.md) ### Other - [TYPE](https://www.tines.com/llm/docs/formulas/functions/type.md)