Using a combination of new Glide Plugin Columns, you can now rank items based on a raw value (points, score, scale, etc.) [Glide: Create a RANKED Leaderboard!]

Hola @Robert_Petitto and @JackVaughan Very weird the situation, I tested that plugin days ago and worked perfectly using a Number or Text column, it was even very smart by sorting the array. Today I retested it and it still works perfectly!. Here my result when my Num column is Number type [imag…

@gvalero you’re right. It does sort arrays of numbers correctly. @JackVaughan @Robert_Petitto how did you guys manage to break it? :thinking: :rofl: Okay, I think I figured out how it breaks. It depends how you create your array. If you create the array via Joined List → Split text, then pass tha…

It breaks when I’m sorting the Unique Array: @JackVaughan @david [Screen Shot 2021-11-08 at 9.32.23 AM] [image] Array Playground · Glide

Updated video. See original post :point_up:

Cool tutorial for leaderboards! One question - how would you display ties? For example) display as “Tied for 3rd” I assume you would have to use (at least) ITE and Template columns… the Template being the result of the ITE and your text, but how would the ITE work? Would this be an example of wh…

There is a lot of discussion on ties in this thread. [image] RANK VIA New data columns Ask for Help Trying to find a way to RANK in the GLIDE data editor. Anyways of doing this with the newly released data columns. Cheers

I’ll check it out - thanks Jeff!

What I would do is continue on by creating a multiple relation from the ordinal rank column to itself. Then create a rollup column to see how many times that rank exists. Then create an if then else column that looks to see if the Rollup is greater than one and if so results in “Tied for” else blank…

:fire: :fire: :fire: Awesome! Thanks Bob!

Just to add to my dilemmas of ranking. Each position entry needs to be sorted into categories prior to ranking. For the life of me, I just can’t seem to find a workable option other than creating multiple sheets for the same event. I’m a medic by profession so forgive my data naivete.

🥇🥈🥉 Convert Number Score to Rankings in Glide!

Community Resources

Jeff_Hager November 10, 2021, 2:18pm 15

There is a lot of discussion on ties in this thread.

Topic		Replies	Views
RANK VIA New data columns Ask for Help	14	1532	November 9, 2021
Issues of Ranks in Leaderboard Ask for Help	10	950	January 23, 2023
How to Rank High to Low numbers from 1st to 10th etc Ask for Help	3	679	April 4, 2022
Rank Date Ask for Help custom-code	45	1806	August 20, 2021
Ranking dentro do aplicativo Ask for Help	5	214	January 1, 2024

🥇🥈🥉 Convert Number Score to Rankings in Glide!

Related topics