RANK

RANK helps you return the ranking position of a numeric value within a specified range in DBSheet formula fields. It provides the tools you need to calculate rankings directly in a table, making your work more efficient and helping you accomplish tasks with ease. With RANK, you can create a formula field, enter a RANK formula in the 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 after saving, refresh automatically when data changes, and are also filled automatically after data import. Whether you're ranking values in a range, troubleshooting parameter or data type errors, or testing formulas before applying them broadly, RANK 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