Returns the highest number or latest date.
Syntax
MAX(value1, [value2, ...])
- value1—The number or range from which you want the highest value.
- value2, ... —[optional]Additional numbers or ranges.
Sample usage
MAX(Cost1:Cost5)
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 | Clothing Item T-Shirt | Transaction Total 1,170.00 | Units Sold 78 | In Stock? true | Ship Date 02/15/19 |
2 | Clothing Item Pants | Transaction Total 1,491.00 | Units Sold 42 | In Stock? false | Ship Date 03/20/19 |
3 | Clothing Item Jacket | Transaction Total 812.00 | Units Sold 217 | In Stock? true | Ship Date 02/27/19 |
Given the table above, here are some examples of using MAX in a sheet:
Formula | Description | Result |
---|---|---|
Formula =MAX([Units Sold]:[Units Sold]) | Description Returns the highest number from the “Units Sold” column. | Result 217 |
Formula =MAX([Ship Date]:[Ship Date]) | Description When placed in a Date column, returns the most recent date from the “Ship Date” column. | Result 03/20/19 |
Formula =MAX(COLLECT([Transaction Total]:[Transaction Total], [In Stock?]:[In Stock?], 1)) | Description Collects any values from the "Transaction Total" column that have a corresponding "In Stock?" value of true, then returns the highest "Transaction Total" number. | Result 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.