MAX Function

Returns the highest number or latest date.
Sample Usage
MAX(Cost1:Cost5)
Syntax
MAX(
  • value1
  • [
    • value2
    • ...
    ]
)
  • value1
    The number or range from which you want the highest value.
    • value2
    • ...
    —[optional]
    Additional numbers or ranges.
Usage Notes
  • When referencing dates, you must use MAX in a Date column. See Column Types for more information on Date columns.
     
Examples

This example references the following sheet information:

  Clothing Item Transaction Total Units Sold In Stock? Ship Date
1 T-Shirt 1,170.00 78 true 02/15/19
2 Pants 1,491.00 42 false 03/20/19
3 Jacket 812.00 217 true 02/27/19

Given the table above, here are some examples of using MAX in a sheet:

Formula Description Result
=MAX([Units Sold]:[Units Sold]) Returns the highest number from the “Units Sold” column. 217
=MAX([Ship Date]:[Ship Date]) When placed in a Date column, returns the most recent date from the “Ship Date” column. 03/20/19
=MAX(COLLECT([Transaction Total]:[Transaction Total], [In Stock?]:[In Stock?], 1)) Collects any values from the "Transaction Total" column that have a corresponding "In Stock?" value of true, then returns the highest  "Transaction Total" number. 1,170.00

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