Rollup...by rank?

Feature Requests
13

I’d like to bump this feature request.

I think we need a Rank/Order functionality to sequentially number rows, either:

  • Along the entire contents of a sheet.
  • Or by specifying a grouping value, so each group has its own unique numbering.

Then within that sheet or grouping, I’d like to specify a column to rank by, either:

  • Numerically
  • Alphabetically
  • Date Order
  • Etc.

Then finally the ability to choose to number in:

  • Ascending order
  • Descending order

I was thinking of ways to build this into an existing column type, such as rollup, math, or single value, but maybe it would be better as its own column type. What I’m thinking is a Rank column with 3 setting options.

  • The first setting option is to select the entire sheet, or select a specific column to group by.
  • The second setting option is the actual value you want to rank by (such as a score or a date), or you can choose to select nothing and it will number by sheet order.
  • The third option would be Ascending/Descending order so it numbers from top-down or bottom-up if nothing selected for option 2, or it numbers from lowest-greatest or greatest-lowest if you selected a value to rank by in option 2.

I’ve beat my head against the wall trying to find a way to mathematically rank the data in a row using only glide functionality, and so the results are sequential whole numbers. I feel like there is some magic math formula that could do this but I’ve been unable to figure it out or find a solution the didn’t suggest programmatically sorting and looping the data, or simply using a Rank function (which we don’t have…yet).

3 Likes