# Look up Item to Sort

**URL:** https://community.glideapps.com/t/look-up-item-to-sort/71897
**Category:** Ask for Help
**Created:** [March 21, 2024, 2:22pm UTC](https://community.glideapps.com/t/look-up-item-to-sort/71897 "2024-03-21T14:22:11Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![tkd\_hayden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tkd_hayden/32/67200_2.png) [@tkd\_hayden](https://community.glideapps.com/u/tkd_hayden)
#### Post date: [March 21, 2024, 2:22pm UTC](https://community.glideapps.com/t/look-up-item-to-sort/71897/1 "2024-03-21T14:22:11Z")

</div>

I’m trying to sort a table based on a relation look up item. I see that this isn’t possible. How do I turn the look up item into something I can sort by?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 21, 2024, 2:24pm UTC](https://community.glideapps.com/t/look-up-item-to-sort/71897/2 "2024-03-21T14:24:28Z")

</div>

Use a Query column instead of a relation. It has a sorting option.

---

<div class="post-metadata">

### Author: ![tkd\_hayden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tkd_hayden/32/67200_2.png) [@tkd\_hayden](https://community.glideapps.com/u/tkd_hayden)
#### Post date: [March 21, 2024, 2:27pm UTC](https://community.glideapps.com/t/look-up-item-to-sort/71897/3 "2024-03-21T14:27:56Z")

</div>

Sorry, I think I explained wrong. I’m wanting to sort on the Layout side of things based on a location that is in a look up item from a relation. Not sorting on the actual data table.

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 21, 2024, 2:40pm UTC](https://community.glideapps.com/t/look-up-item-to-sort/71897/4 "2024-03-21T14:40:14Z")

</div>

As long as the relation is the source of the collection, you can sort the collection based on the data in that relation. You don’t need the lookup column.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 21, 2024, 11:53pm UTC](https://community.glideapps.com/t/look-up-item-to-sort/71897/5 "2024-03-21T23:53:18Z")

</div>

So you have a table, and in that table there’s a lookup column. You want to sort by that column but that isn’t possible?

Any chance you’re using a Big Table? Or the relation you have is a multiple match column?