# Weekly, Monthly Leaderboard

**URL:** https://community.glideapps.com/t/weekly-monthly-leaderboard/60091
**Category:** Ask for Help
**Created:** [April 3, 2023, 8:39pm UTC](https://community.glideapps.com/t/weekly-monthly-leaderboard/60091 "2023-04-03T20:39:05Z")
**Posts on this page:** 1
**Showing post:** 17

<div class="post-metadata">

### 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: [April 10, 2023, 1:44am UTC](https://community.glideapps.com/t/weekly-monthly-leaderboard/60091/17 "2023-04-10T01:44:16Z")

</div>

Follow my rankings video below, but before you create the points arrays, you’ll need to create a multiple relation column that relates the week number back to itself. This will isolate each set of values to their respective week. Then use a look up column to get the points array for each week.

described here:

> [@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.

[![](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)

---

_[View the full topic](https://community.glideapps.com/t/weekly-monthly-leaderboard/60091)._