RANKEQ Function

Returns the rank of a number relative to other numbers in a range
Sample Usage
RANKEQ([Units Sold]1,[Units Sold]:[Units Sold], 1)
Syntax
RANKEQ(
  • number
  • range
  • [
    order
    ]
)
  • number
    The number, or cell reference, of the value to rank
  • range
    The cell references, or range, to rank
  • order
    —[optional]
    Specifies rank order: 0 (default) is descending order, and 1 is ascending order
Examples

Still need help? 

Use the Smartsheet Formula Template to view examples and practice working with functions in real-time. 


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