# 🥇🥈🥉 Convert Number Score to Rankings in Glide! **URL:** \ **Category:** Community Resources\ **Tags:** tutorial\ **Created:** [November 6, 2021, 4:20am UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103 "2021-11-06T04:20:45Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 6, 2021, 4:20am UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/1 "2021-11-06T04:20:45Z")
Using a combination of new Glide Plugin Columns, you can now rank items based on a raw value (points, score, scale, etc.) [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/5/85d52dfc2c6fa59b69ebf006cb6cad7d5e3e8944.jpeg "Glide: Create a RANKED Leaderboard!") ](https://www.youtube.com/watch?v=QvNTzYx7tvI) ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [November 6, 2021, 4:30am UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/2 "2021-11-06T04:30:47Z")
Awesome! Instead of Join, Split, try Lookup Points on the Things table. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 6, 2021, 1:19pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/3 "2021-11-06T13:19:21Z")
Ooo nice…one less column! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 7, 2021, 11:53pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/4 "2021-11-07T23:53:37Z")
Make this adjustment in order to have your list items “tie” for rank values without skipping ranks: > [@RANK VIA New data columns](https://community.glideapps.com/t/rank-via-new-data-columns/34176/8): > > This worked! [https://www.loom.com/share/a43335985a8e4502af4cb6cda7f39b86](https://www.loom.com/share/a43335985a8e4502af4cb6cda7f39b86) ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [November 8, 2021, 11:19am UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/5 "2021-11-08T11:19:30Z")
@Robert_Petitto do you mind if I use this in an education video? Will give you a shoutout. ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [November 8, 2021, 11:57am UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/6 "2021-11-08T11:57:06Z")
Hmm… looks like we need to add numerical sorting to make this really work? ![CleanShot 2021-11-08 at 11.53.52@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/9493fd707033d0fc7913baa23c1d17f08b20f1c3.png) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 8, 2021, 12:14pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/7 "2021-11-08T12:14:37Z")
Oof. Good catch. Yes, for sure. ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [November 8, 2021, 12:26pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/8 "2021-11-08T12:26:00Z")
@Darren_Murphy has also noted the other types we need [Sort Array does not work on arrays of dates · Issue #58 · glideapps/glide-code-columns · GitHub](https://github.com/glideapps/glide-code-columns/issues/58) I’m still going to use it though. Thanks @Robert_Petitto. I needed a good use case to crack open tutorials on Array column stuff. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 8, 2021, 12:53pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/9 "2021-11-08T12:53:10Z")
Ya…this is disappointing. ![Screen Shot 2021-11-08 at 7.52.49 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e50abe737e72ed79e2a2e83b4c82985be2fbaa48.png) @david I submitted an issue: [Sort Array column does not sort numbers · Issue #85 · glideapps/glide-code-columns · GitHub](https://github.com/glideapps/glide-code-columns/issues/85) ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [November 8, 2021, 1:44pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/10 "2021-11-08T13:44:26Z")
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** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1d50837c12d7b67c7e98d1e76a08f10c51baa082.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/900d49ae096e5fc3f07c1ed102fbcf26d63f36a5.png) and here when my _Num column_ is **Text type**. The plugin was very smart to recognize that all text values were numbers and could sort it perfect. Otherwise, the sequence would have been different (what Robert has). ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0e22ae0fbe24599e34bf969cb64b96401cac7a31.png) Regarding the sorting an array of dates, this is true, the **plugin fails**. Here I wrote an advise to David about this issue: [🆕 20 new experimental code columns to play with - #33 by gvalero](https://community.glideapps.com/t/20-new-experimental-code-columns-to-play-with/33351/33) Saludos! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 8, 2021, 2:06pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/11 "2021-11-08T14:06:20Z")
@gvalero you’re right. It _does_ sort arrays of numbers correctly. @JackVaughan @Robert_Petitto how did you guys manage to break it? 🤔 🤣 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 that to the Array Sort, then it breaks. (It actually does a lexical sort instead of a numerical sort) ![Screen Shot 2021-11-08 at 10.14.20 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b7b476b87ec793b5bfcbc7139fd4768ea0af929e.jpeg) - But if you create the array via a Lookup (as @david suggested), then it works perfectly. ![Screen Shot 2021-11-08 at 10.16.39 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/36253f0f614f8e472c97833a776aac4ce5ff301f.png) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 8, 2021, 2:31pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/12 "2021-11-08T14:31:53Z")
It breaks when I’m sorting the Unique Array: @JackVaughan @david ![Screen Shot 2021-11-08 at 9.32.23 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/5/25da24b7d16f2e15855414cb7d17116ece8fa763.png) > **[Array Playground · Glide](https://www.loom.com/share/69ee4effff3d49249121a0e768dca835)** ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 10, 2021, 1:41am UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/13 "2021-11-10T01:41:11Z")
Updated video. See original post ☝ ---
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [November 10, 2021, 2:08pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/14 "2021-11-10T14:08:24Z")
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 when you would need a conditional relation? 🤔 Thanks again for the tutorial! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 10, 2021, 2:18pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/15 "2021-11-10T14:18:47Z")
There is a lot of discussion on ties in this thread. > [@RANK VIA New data columns](https://community.glideapps.com/t/rank-via-new-data-columns/34176): > > Trying to find a way to RANK in the GLIDE data editor. Anyways of doing this with the newly released data columns. Cheers ---
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [November 10, 2021, 2:53pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/16 "2021-11-10T14:53:23Z")
I’ll check it out - thanks Jeff! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 10, 2021, 3:29pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/17 "2021-11-10T15:29:18Z")
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. Lastly, create a Template Column that starts with that if then else and ends with the rank. ---
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [November 10, 2021, 3:53pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/18 "2021-11-10T15:53:28Z")
🔥 🔥 🔥 Awesome! Thanks Bob! ---
**Author:** ![jason\_palmer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason_palmer/32/3234_2.png) [@jason\_palmer](https://community.glideapps.com/u/jason_palmer)\ **Post date:** [November 10, 2021, 7:12pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/19 "2021-11-10T19:12:53Z")
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. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 10, 2021, 7:14pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/20 "2021-11-10T19:14:50Z")
Nah. Just create a multiple relation from the category back to itself. Then, the very first lookup column will be based off the relation column and not just the sheet column. ![Screen Shot 2021-11-10 at 2.19.35 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cccd7eb36ad2b018d9f8e4c004c5cdf28df504ed.jpeg) [Next page](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103.md?page=2)