MAX

MAX helps you calculate the largest value in Smart Sheets data. It provides the tools you need to perform formula-based analysis efficiently, making your work more efficient and helping you accomplish tasks with ease. With MAX, you can enter formulas directly in a cell or formula bar, view automatic syntax prompts with parameter guidance and examples, use flexible parameters for different calculation scenarios, reference data across worksheets, and build nested calculations. Results update automatically when source data changes, and you can manually recalculate if needed. Whether you're checking formula syntax, correcting parameter or reference issues, or analyzing ranges that may include text-formatted numbers or circular references, MAX helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53