# 🥇🥈🥉 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:** 12\ **Page:** 2
**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 16, 2021, 1:55am UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/21 "2021-11-16T01:55:13Z")
Robert, I have had a degree of success with rankings based on time but I still seem to have a blind spot around separating the multiple categories. My sheet is divided into three main components. 1. Time entry to rank ( no issues) 2. Class is divided into Elite, Competitive & Open. 3. Sex, Male/ Female Creating a rank for the various class and sex categories from one sheet is the goal. Please advise. [Capture|690x165](https://community.glideapps.com/uploads/short-url/4ErmSopMvaIYmPmhGfl1LpVuCDz.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 16, 2021, 3:10am UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/22 "2021-11-16T03:10:29Z")
So there may be an Elite - Male and an Elite - Female and a Competitive - Male, etc. and you want individual rankings within these class/sex combos? ---
**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 16, 2021, 3:12am UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/23 "2021-11-16T03:12:57Z")
If so, create a template column combining the Class column and the Sex column (eg. Elite-Male), and then do a multiple relation to self from/to this template column (as instructed in my previous reply): > [@1st\_place\_medal2nd\_place\_medal3rd\_place\_medal Convert Number Score to Rankings in Glide!](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/20): > > 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. ---
**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 16, 2021, 6:41pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/24 "2021-11-16T18:41:30Z")
Cheers. Sorry for the late reply, I’m in New Zealand. I’ll let you know how that pans out. ---
**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 28, 2021, 7:46pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/25 "2021-11-28T19:46:37Z")
Robert I am having massive success with your recommendations. Unfortunately when I try to tally the points for 3 races into a leader board my results are not displaying correctly in the app. So to be clear the points are added together correctly in the leader board sheet and showing the correct total, but when displayed in the inline list the Template relation seems to be having an effect on this calculated columns ability to display correctly. ---
**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 28, 2021, 9:27pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/26 "2021-11-28T21:27:47Z")
Can you take a screenshot of where it looks correct in the data editor and then a second one that shows both the inline list and the data panel (lower left hand panel \> “data”) where it displays incorrectly? ---
**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 28, 2021, 11:31pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/27 "2021-11-28T23:31:11Z")
Points Total is the column in dispute. ![Screenshot (66)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/906c6dd48cded817b1273ceefbc5e02e37ea0ed2.png) ![Screenshot (67)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4af2d65aba730c3269c47531099bdae94559a871.jpeg) ---
**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\ **Post date:** [August 3, 2023, 2:04am UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/28 "2023-08-03T02:04:37Z")
I built the most amazing capability in my app today, thanks to this instruction. Thank you so much, @Robert_Petitto!! 🙏 ❤ ---
**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:** [August 3, 2023, 10:25am UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/29 "2023-08-03T10:25:53Z")
My pleasure! Share what you built! ---
**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\ **Post date:** [August 3, 2023, 2:40pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/30 "2023-08-03T14:40:41Z")
@Robert_Petitto , basically we collect a variety of environmental data from our users and apply that to an analytics methodology. Within the methodology, I needed to calculate what is essentially the ‘percentile’ of a given datapoint to use in other calculations. Your rankings approach worked like a charm! ---
**Author:** ![Adam\_Chambers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adam_chambers/32/67402_2.png) [@Adam\_Chambers](https://community.glideapps.com/u/Adam_Chambers)\ **Post date:** [January 3, 2024, 8:02pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/31 "2024-01-03T20:02:51Z")
@Robert_Petitto thanks for the vid. I have 5000 rows. It’s organizing them from 1 to 5000. How can I convert this so it ranks based on rank within a category? I have a “state” column. I’d like to show each row’s rank within its state, rather than overall. For example “1st in California”. Thanks. ---
**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:** [January 3, 2024, 8:54pm UTC](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/32 "2024-01-03T20:54:25Z")
I think I answered that above: > [@1st\_place\_medal2nd\_place\_medal3rd\_place\_medal Convert Number Score to Rankings in Glide!](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103/20): > > 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. Is this what you mean? [Previous page](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103.md?page=1)