MIN Function

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
    • value2
    • ...
    —[optional]
    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.

Ask the Community