SMALL

SMALL helps you return the nth smallest value in a specified range in DBSheet formula fields. It provides the tools you need to calculate ranked numeric results directly in a table, making your work more efficient and helping you accomplish tasks with ease. With SMALL, you can create a formula field, enter the function in the formula editor, define the target data range, use flexible parameter formats, and combine the result with other functions such as IF or AND for nested calculations. Results are calculated immediately, refresh automatically when source data changes, and are also filled automatically after data import. Whether you're setting up formula fields, troubleshooting parameter or data type errors, or testing formulas before applying them broadly, SMALL helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

1:53