The images represent the number, he probably made a column that listed the scores or rankings and simply sorted the list from lowest to highest or vice versa if it is a score.

Yes, this is what I was looking for. Thank you.
However, I’m trying to use the rank function on a sheet that will always be able to add or remove users, so I’m not sure how to edit the formula to do this.

So essentially, there can be 15 rows in the future and I want the ranking column to be able to account for that.

Use an array formula and make sure in the formula it leaves a blank cell if there isnt a user for that row
=Arrayformula(IF(A2:A="","",SORT(B2:B))

Something like that. So when u add a row glide recognizes the row as empty then the array formula adds the values as needed.
You can also just have another sheet that pulls the data and matches and sorts so you dont have to worry about that.

Well, him and I started Glide around the same time and it feels like we both know everything there is to know about Glide, he posts more frequently than I do unless I’m on vacation or something. But not to sound like an ass I haven’t come across something I’ve needed help on just yet.

rank function? You just put the cell you are ranking 1st, then the range it is tested against, then ascending or descending
RANK(4,A2:A100,1)
if you use 0 the largest value is ranked 1st if you use 1 then the smallest value is ranked 1st.

The problem I am facing is that the ranking column is based on a dynamic column that is always changing. Having C2:C6 would only work for C2:C6, but if new users were added, then it would then be C2:C20.

You see how I use that same idea in the arrayformula above. Never limit yourself to a set range, it gets you in trouble in the end.
So instead,
=ARRAYFORMULA(RANK(C2:C,C2:C,0))

Then to remove errors use
=ARRAYFORMULA(IF(ISERROR(RANK(C2:C,C2:C,0)),"",RANK(C2:C,C2:C,0)))