Returns the lowest number or earliest date
Sample Usage
MIN(Cost1:Cost5)
Syntax
MIN(
-
value1
- [
]
- value2
- ...
- value1—The number or range from which you want the lowest value
- —[optional]
- value2
- ...
Additional numbers or ranges
Usage Notes
- When referencing dates, you must use MIN in a Date column
Examples
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.