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 ItemTransaction TotalUnits SoldIn Stock?Ship Date
1T-Shirt1,170.0078true02/15/19
2Pants1,491.0042false03/20/19
3Jacket812.00217true02/27/19

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

FormulaDescriptionResult
=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 Formula Handbook template to find more support resources and view 100+ formulas. It includes a glossary of every function that you can practice working with in real time and examples of commonly used and advanced formulas.

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

Was this article helpful?
YesNo