MIN() : find the smallest value

In a formula-type column, the MIN function returns the smallest value among multiple columns or numeric values. It returns a number.

Calling function parameters in TimeTonic:

$field_name = field (link, linked table column, number, selection, formula, text...).
"free text" = free text to add within quotation marks.
do not use quotation marks for numbers.

Syntax

MIN(column_1, column_2, ...)

Parameters

# Parameter Description

1 column_1, column_2, ... Number-type columns and/or values to compare.

The output format of the result (number, currency, percentage...) is configured in the output field options of the formula editor. See Output format options in the Formula Column article.

Examples

Find the lowest price

The column returns the lowest price between the two suppliers.

MIN($Supplier A Price, $Supplier B Price)

Result of MIN between two supplier prices

I selected the smallest numeric value contained in my columns Provider 1, Provider 2, and Provider 3 to find out which one was the cheapest.

Go further

MIN_NUM_ELEMENTS

For the minimum among the values of a single column in a linked table.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.