# "Reference" Not working properly

**URL:** <https://community.glideapps.com/t/reference-not-working-properly/3372>\
**Category:** Report a Bug\
**Created:** [January 6, 2020, 7:04pm UTC](https://community.glideapps.com/t/reference-not-working-properly/3372 "2020-01-06T19:04:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Olivia\_Green](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/olivia_green/32/1642_2.png) [@Olivia\_Green](https://community.glideapps.com/u/Olivia_Green)\
**Post date:** [January 6, 2020, 7:04pm UTC](https://community.glideapps.com/t/reference-not-working-properly/3372/1 "2020-01-06T19:04:38Z")

</div>

Hi I am having an issue with the reference equation “Winner=Commitment:Group Name: Multiple”. I’ve already checked to make sure there weren’t any misspellings and it is not. I’ve also used the data editor as an alternative but it will not associate the data to the right category.

I thought maybe it was because I am referencing data that is built from a query formula but I tried on a normal sheet and still to no avail.

Is anyone also having this issue?

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [January 6, 2020, 8:28pm UTC](https://community.glideapps.com/t/reference-not-working-properly/3372/2 "2020-01-06T20:28:14Z")

</div>

Try creating the relation column in the Glide app. You do it in the Data area. I avoided it for a while but finally started to use it and it works great.

---

<div class="post-metadata">

**Author:** ![Olivia\_Green](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/olivia_green/32/1642_2.png) [@Olivia\_Green](https://community.glideapps.com/u/Olivia_Green)\
**Post date:** [January 6, 2020, 8:38pm UTC](https://community.glideapps.com/t/reference-not-working-properly/3372/3 "2020-01-06T20:38:08Z")

</div>

Hi George,

Thanks for the response. I actually tried it in the data editor originally and it still didn’t work. I’ll keep playing with it.

---

<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:** [January 6, 2020, 9:18pm UTC](https://community.glideapps.com/t/reference-not-working-properly/3372/4 "2020-01-06T21:18:44Z")

</div>

Check for spelling, upper/lower case, spaces, etc. to make sure you are comparing similar values. If there isn’t a match, the relation won’t return anything. Also, is the first column of the related table empty? Maybe the relation is working, but only appears empty.

---

<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:** [February 7, 2024, 11:01am UTC](https://community.glideapps.com/t/reference-not-working-properly/3372/5 "2024-02-07T11:01:03Z")

</div>


