Help Center Units & fieldsLook it up

Every formula function, with an example

Everything you can write in a calculation field and a smart default value: operators, comparisons, conditions, and every function with an example.

10 minUpdated Oct 27, 2026

Open in Corteksa

The basics

Element

How to write it

Example

Field

Its internal name in curly braces

{amount}

Number

As it is

15 or 0.15

Text

In double quotes

"Direct"

True/false

true or false

true

Arithmetic

+ - * /

{qty} * {price}

Grouping

Regular parentheses

({a} + {b}) * 2

Comparison

== != > < >= <=

{total} >= 1000

Combining conditions

AND and OR between two conditions

{a} > 0 AND {b} > 0

+ only adds numbers. To join text, use CONCAT. To negate a condition, use !=.

Conditions

Function

Description

Example

Result

IF(condition, if true, if false)

Picks a value based on the condition

IF({total} > 50000, "Needs approval", "Direct")

“Needs approval” if the amount is over 50,000

COALESCE(a, b, ...)

The first value that isn’t empty

COALESCE({discount}, 0)

The discount, or zero if it’s empty

Numbers

Function

Description

Example

Result

ROUND(x, places)

Financial rounding: halves round away from zero

ROUND(100.125, 2)

100.13

Negative places round to tens and hundreds

ROUND(1250, -2)

1300

CEIL(x)

Up to the next whole number

CEIL(4.1)

5

FLOOR(x)

Down to the previous whole number

FLOOR(4.9)

4

ABS(x)

The absolute value

ABS({balance})

The balance without its sign

MIN(a, b, ...)

The smallest value, ignoring empty ones

MIN({offer}, {budget})

The lower of the two

MAX(a, b, ...)

The largest value, ignoring empty ones

MAX({paid}, 0)

Zero if the amount paid is negative

ROUND without places rounds to a whole number: ROUND(2.5) gives 3, and ROUND(-2.675, 2) gives -2.68.

Text

Function

Description

Example

Result

CONCAT(a, b, ...)

Joins any number of values as text

CONCAT({first_name}, " ", {last_name})

Ahmed Saleh

LENGTH(text)

The number of characters

LENGTH({code})

4 for the code ACME

In CONCAT, an empty value becomes empty text, numbers are written as they are, and dates as 2026-07-15. A select field shows as an internal ID, so don’t use it to build readable text.

Dates

Function

Description

Example

Result

TODAY()

Today’s date

TODAY()

2026-07-15

NOW()

The current moment, with the time

NOW()

A date and time

DATE("YYYY-MM-DD")

A fixed date

DATE("2027-01-01")

January 1, 2027

DATEDIFF(a, b, unit)

a minus b; the unit is optional (days by default)

DATEDIFF({end}, {start}, 'days')

The number of days between them

DATEADD(date, number, unit)

Shifts the date

DATEADD({start}, 30, 'days')

30 days later

Subtracting two dates

The same as DATEDIFF in days

{end} - {start}

The number of days

Units: days, weeks, months and years, in the plural. Months in DATEDIFF are whole months. Adding a month to January 31 gives the last day of February.