πŸ₯‡πŸ₯ˆπŸ₯‰ Convert Number Score to Rankings in Glide!

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

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?

1 Like

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):

2 Likes

Cheers.
Sorry for the late reply, I’m in New Zealand.
I’ll let you know how that pans out.

1 Like

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.

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?

1 Like

Points Total is the column in dispute.