# Use relations \> column as source to an if/then/else case

**URL:** <https://community.glideapps.com/t/use-relations-column-as-source-to-an-if-then-else-case/17512>\
**Category:** Feature Requests\
**Created:** [October 23, 2020, 2:13pm UTC](https://community.glideapps.com/t/use-relations-column-as-source-to-an-if-then-else-case/17512 "2020-10-23T14:13:28Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 23, 2020, 2:13pm UTC](https://community.glideapps.com/t/use-relations-column-as-source-to-an-if-then-else-case/17512/1 "2020-10-23T14:13:28Z")

</div>

In order to do conditional checks between values in one sheet and the values in a different sheet, I have to create lookups for every check. It would be EXPONENTIALLY more convenient to select the value from the relation.

Here’s what I mean:

## ☝ Vote please!

---

<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 23, 2020, 2:24pm UTC](https://community.glideapps.com/t/use-relations-column-as-source-to-an-if-then-else-case/17512/2 "2020-10-23T14:24:03Z")

</div>

Definitely +1!

I finding that I’m endlessly replicating columns from one sheet to another via lookups.  
Being able to reference and use the values directly through a relation would be awesome.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 23, 2020, 4:03pm UTC](https://community.glideapps.com/t/use-relations-column-as-source-to-an-if-then-else-case/17512/3 "2020-10-23T16:03:28Z")

</div>

Right? Same for a math/template column, etc.

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [October 23, 2020, 4:08pm UTC](https://community.glideapps.com/t/use-relations-column-as-source-to-an-if-then-else-case/17512/4 "2020-10-23T16:08:23Z")

</div>

A question that has nothing to do with this topic. Sorry. Can you tell me what software do you use for your simultaneous screen and camera capture?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 23, 2020, 4:09pm UTC](https://community.glideapps.com/t/use-relations-column-as-source-to-an-if-then-else-case/17512/5 "2020-10-23T16:09:14Z")

</div>

Typically Loom for quick vids that need sharing instantly. Otherwise, I use Screenflow for my more polished YouTube videos.

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [October 23, 2020, 4:09pm UTC](https://community.glideapps.com/t/use-relations-column-as-source-to-an-if-then-else-case/17512/6 "2020-10-23T16:09:46Z")

</div>

Thanks Master

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 22, 2021, 3:41pm UTC](https://community.glideapps.com/t/use-relations-column-as-source-to-an-if-then-else-case/17512/7 "2021-02-22T15:41:15Z")

</div>

Bumping this feature request because I just ran into the situation again over the weekend and it would’ve been so much faster to include columns found through relations within an if then.