In a formula-type column, the MIN() function returns the smallest value among multiple columns or numeric values.
-
Numeric function name:
MIN()
Syntax
MIN(column_1, column_2, ...)
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.
Parameters
| Parameter | Description |
|---|---|
column_1, column_2, ... |
Number-type columns and/or values to compare. |
Example
MIN($Supplier A Price, $Supplier B Price)
The column returns the lowest price between the two suppliers.
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.
Return Type
The function returns a number (the smallest value).
The output type format can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Business Use Cases
MIN() selects the smallest value: best price among suppliers, floor of a range, minimum rating.
Best Practice
For the minimum among values of a single column in a linked table, use MIN_NUM_ELEMENTS().