Formulas

Datalexing formula fields let you calculate a value automatically for every cell in a field, based on a formula you define. The syntax works much like the formulas you already know from spreadsheet tools — combined with a fast, growing function library built for tables.

A formula is built from two building blocks:

Operators — symbols (+, =, >, etc.) that act directly between two values.
Functions — named, predefined calculations (e.g. SUM, IF, LEFT) that take arguments, do something with them, and return a result.

On this page

Operators

Operators are symbols that perform arithmetic, comparisons, or text joins directly between two values, without needing to write a function name. Most operators have a matching function that does the exact same thing (listed below) — use whichever reads better in your formula.

Operator	Function equivalent	Description	Example
`+`	`ADD`	Adds two numbers and returns the sum.	`1 + 2 = 3`
`-`	`MINUS`	Subtracts the second number from the first.	`10 - 2 = 8`
`*`	`MULTIPLY`	Multiplies two numbers together.	`10 * 3 = 30`
`/`	`DIVIDE`	Divides the first number by the second.	`10 / 5 = 2`
`=`	`EQUAL`	Returns `TRUE` if the two values are equal, `FALSE` otherwise.	`10 = 10` → `TRUE`
`!=`	`NOT_EQUAL`	Returns `TRUE` if the two values are not equal, `FALSE` otherwise.	`10 != 10` → `FALSE`
`>`	`GREATER_THAN`	Returns `TRUE` if the first value is greater than the second.	`10 > 11` → `FALSE`
`>=`	`GREATER_THAN_OR_EQUAL`	Returns `TRUE` if the first value is greater than or equal to the second.	`10 >= 10` → `TRUE`
`<`	`LESS_THAN`	Returns `TRUE` if the first value is less than the second.	`10 < 11` → `TRUE`
`<=`	`LESS_THAN_OR_EQUAL`	Returns `TRUE` if the first value is less than or equal to the second.	`19 <= 1` → `FALSE`

Function categories at a glance

Every function in Datalexing belongs to one of the categories below, shown by an icon. Here's what each one actually covers:

Category	Covers
Text	Reading, cleaning, and transforming text strings.
Number	Arithmetic, rounding, and mathematical calculations.
Logical	Comparisons and conditions that return `TRUE` or `FALSE`.
List & Aggregation	Summarizing values pulled in through a link/lookup field (sums, averages, counts, filters...).
General & Reference	Functions that pull in or combine data across any type — a field's raw value, a linked table's value, a row's ID — rather than being limited to text or numbers.
Date & Time	Creating, formatting, and measuring dates and timestamps.
Link	Building and reading clickable buttons and hyperlinks.

*Related: Column Types · Formulas Guide · *Score Cards