=MIN

The MIN function returns the smallest value from a list separated by semicolons. It works with two kinds of value: give it numbers and it returns the lowest one, give it dates and it returns the earliest one.

Syntax

=MIN(Parameter1; Parameter2; Parameter3; ...)

Parameters

• Parameter1, Parameter2, Parameter3, … – The values or field tokens to evaluate. Every value must be a number, or every value must be a date. Do not mix the two kinds in one function.

How It Works

• Reads the whole list first and decides whether it is a list of numbers or a list of dates.

• Skips values that are empty, so a field token that has no value yet is ignored rather than counted as zero.

• With numbers, returns the lowest number found.

• With dates, returns the earliest date found, written as YYYY-MM-DDTHH:MM:SS (for example 2026-03-04T00:00:00).

Usage Notes

• Formula functions are case sensitive and must be written in ALL CAPS.

• All parameters must be the same kind of value. If the list mixes numbers with dates, or contains text that is neither, the function cannot be evaluated and the formula stays on the field exactly as you wrote it.

• Field tokens can be used instead of hard-coded values, including Date and Date/Time field tokens.

• Useful for identifying minimums such as lowest price, smallest quantity, earliest due date, or the first date a customer was contacted.

• You can include multiple values in the function as long as the syntax remains valid.

• To show the date result in a friendlier format, wrap it in =FORMATDATE, for example =FORMATDATE(dd MMM yyyy; =MIN([[Field: Start (Date)]]; [[Field: Review (Date)]])).

Example - Numbers

=MIN(15; 7; 27; 10)

Returns: 7

Example - Dates

=MIN(2026-03-04; 2025-11-18; 2026-07-30)

Returns: 2025-11-18T00:00:00

---

Keywords

MIN, minimum value, earliest date, oldest date, numeric comparison, date comparison, list of numbers, list of dates, workflow formulas, formula function