# Could Get a Reference Column in Same Table into a IF-Else Column

**URL:** <https://community.glideapps.com/t/could-get-a-reference-column-in-same-table-into-a-if-else-column/51009>\
**Category:** Ask for Help\
**Created:** [October 6, 2022, 9:10am UTC](https://community.glideapps.com/t/could-get-a-reference-column-in-same-table-into-a-if-else-column/51009 "2022-10-06T09:10:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [October 6, 2022, 9:10am UTC](https://community.glideapps.com/t/could-get-a-reference-column-in-same-table-into-a-if-else-column/51009/1 "2022-10-06T09:10:21Z")

</div>

Dear Community

We are trying to get a column date into a IF-Else relation column but in vain. In the same table:

1. Some Records are HQ records i.e ID is HQ
2. Some Records are related to the above HQ as subsidiary
3. If HQ has a Contract Start Date, those related Records contract start date will follow.

 ![Subsidiary Following HQ Contract Start Date](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4ab8f18a1977ed4dd22a142d16509c8e5b8881b6.png)

The above is a lookup on Contract/Subsidiary Follow HQ Contract Start Date

However in the IF-ELse column we are not able to get the above dates

 ![Dates cannot follow](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2c4462b89f2e0e3aab97553b7cd98e8e7fbe6842.jpeg)

Why is the dates empty when it is showing the rightful?

Thanks for any advise in advance!

---

<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:** [October 6, 2022, 9:52am UTC](https://community.glideapps.com/t/could-get-a-reference-column-in-same-table-into-a-if-else-column/51009/2 "2022-10-06T09:52:03Z")

</div>

It looks like your relation is a multiple relation, so your lookup column is returning an array of all dates.  
If you’re expecting just a single date value from the lookup, then your relation column needs to be a single relation.

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [October 6, 2022, 11:19am UTC](https://community.glideapps.com/t/could-get-a-reference-column-in-same-table-into-a-if-else-column/51009/3 "2022-10-06T11:19:54Z")

</div>

Thanks!

Didn’t notice that! Resolved!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 7, 2022, 11:20am UTC](https://community.glideapps.com/t/could-get-a-reference-column-in-same-table-into-a-if-else-column/51009/4 "2022-10-07T11:20:50Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.