RANKAVG Function

Returns the rank of a number relative to other numbers in a range, and assigns an average rank to any duplicates
Sample Usage
RANKAVG([Units Sold]1,[Units Sold]:[Units Sold],1)
  • number
  • range
  • [
  • number
    The number to rank
  • range
    The group of cells to evaluate
  • order
    The arrangement to use to evaluate the range

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