Functions

SESSION_ID

Create a unique ID per session, which you can use in your submissions

Date functions

Functions that handle or generate dates

DATASET() - function

Learn how to build datasets in Convert_

PMT function

PMT calculates the periodic payment for a loan with fixed installments and a constant interest rate.

REGEXMATCH

This article explains how to use the REGEXMATCH() function

COUPON

This article explains how to use COUPON function

FILTER

MAP

TABLESORT

The TABLESORT function in Excel allows you to sort a Table or Datasheet based on a column

CONVERTCURRENCY

This article explains how to convert currencies in your functions

INDEX

The INDEX function is a versatile function that allows you to return a value from a table or range based on the row and column numbers you specify.

IFS

This article explains how to use the IFS function

FormulaScript

CONVERT

DISTANCE

This article explains how to use our unique DISTANCE functions in combination with the Place element

FINDMANY & FINDFIRST

Learn how to use the FINDMANY and FINDFIRST functions

CHOOSE

This article explains how to use the CHOOSE function

Table Functions

This article explains how to use our unique table functions.

DATEDIF

This article explains how to use the DATEDIF() function

TEXT

This article explains how to use the TEXT()-function.

SUMIFS

This article explains how to use SUMIFS functions

FINDIFS

This article explains how to use the FINDIFS function

HLOOKUP

This article explains how to use the HLOOKUP function

VLOOKUP

This article explains how to use the VLOOKUP function

GOOGLESHEET

This article explains how to use GOOGLESHEET functions

OR

This article explains how to use the OR function

AND

This article explains how to use the AND function

IF

This article explains how to use IF() functions

Supported functions