# Adding a rankings - set column - relations

**URL:** <https://community.glideapps.com/t/adding-a-rankings-set-column-relations/25706>\
**Category:** Ask for Help\
**Created:** [April 18, 2021, 5:07am UTC](https://community.glideapps.com/t/adding-a-rankings-set-column-relations/25706 "2021-04-18T05:07:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Linda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/linda/32/49581_2.png) [@Linda](https://community.glideapps.com/u/Linda)\
**Post date:** [April 18, 2021, 5:07am UTC](https://community.glideapps.com/t/adding-a-rankings-set-column-relations/25706/1 "2021-04-18T05:07:33Z")

</div>

I want to set a column based on a position entered against the items on the list in the app. The complication is that I’ve used a Relation between sheets and the positions are in the sub-relation.

The first sheet is Day\>Ring\>Class  
The second sheet is Class\>Competitor Number\>Competitor Name\> Position (I want to update the positions of the list of competitors - scoring them)

It’s sometimes hundreds of classes and the number of competitors varies per class.

Any suggestions on how this can be done?

Thank you

---

<div class="post-metadata">

**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:** [September 24, 2021, 3:27am UTC](https://community.glideapps.com/t/adding-a-rankings-set-column-relations/25706/2 "2021-09-24T03:27:20Z")

</div>

I’m trying to do the same thing. I’ll keep you posted if I get any traction on this