Formula.

Formula

The formula provides a convenient way to automatically calculate and display values in the table based on user-defined parameters. The values are calculated based on a preconfigured formula. The formula can be set up to use values from other numerical columns or select list columns.

Supported arithmetic operations:

addition “+”
subtraction “-”
multiplication “*”
division “/”

Formula column configuration is quite straightforward.

Enter an arithmetic expression into the ‘Formula’ field. To pass validation, column names must be quoted.

Conditional operations in formula columns

The formula column supports two types of conditional logic:

if(condition, valueIfTrue, valueIfFalse),
iff(condition, valueIfTrue; condition2, valueIfTrue2; ..., defaultValue)

if(condition, valueIfTrue, valueIfFalse)

Returns one of two values depending on whether the condition is true or false.

Use this when only one condition and two possible outcomes are needed.

Function structure:

condition – a statement that evaluates to a number (0 or non-zero).
valueIfTrue – returned if the condition is true.
valueIfFalse – returned if the condition is false.

How it works:

A condition that evaluates to 0 is considered false
A non-zero value is considered true
If true → returns valueIfTrue
If false → returns valueIfFalse

Example

Select list column is created, with options A, B, and C configured.

Requirement: formula column needs to return 10 if option A is selected, otherwise 0.

if(
  compare("select_list_column", 'A') == 0,
  10,
  0
)

Result:

If option A is selected → returns 10
Otherwise → returns 0

iff(condition1, result1; condition2, result2; ..., defaultResult)

Short for “if and only if”, this is used for multiple branching conditions.

Use this logic when you want to check multiple conditions in order or need to simulate switch/case logic.

How it works

Conditions are checked in order, from top to bottom.
As soon as one condition evaluates to true (non-zero), its result is returned.
If no condition matches, the final value is returned as default.

Example

A select list column is created, with options A, B, and C configured.

Requirement: formula column needs to return values based on what’s selected in select list column:

10 if option A is selected
20 if option B is selected
30 if option C is selected
0 if anything else is selected

iff(
  compare("select_list_column", 'A') == 0, 10;
  compare("select_list_column", 'B') == 0, 20;
  compare("select_list_column", 'C') == 0, 30;
  1 == 1, 0
)