# Comparing two lookup columns

**URL:** <https://community.glideapps.com/t/comparing-two-lookup-columns/25550>\
**Category:** Ask for Help\
**Created:** [April 14, 2021, 5:12pm UTC](https://community.glideapps.com/t/comparing-two-lookup-columns/25550 "2021-04-14T17:12:32Z")\
**Posts on this page:** 1\
**Showing post:** 24

<div class="post-metadata">

**Author:** ![Eden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eden/32/18651_2.png) [@Eden](https://community.glideapps.com/u/Eden)\
**Post date:** [September 18, 2021, 5:25am UTC](https://community.glideapps.com/t/comparing-two-lookup-columns/25550/24 "2021-09-18T05:25:53Z")

</div>

> [@Eden](#):
>
> last submitted phase per opening, based on the last submitted record for this opening

So I came across this answer by @Jeff_Hager,

> [@Lookup Latest Row (idea for lookups with Multiple Relations)](https://community.glideapps.com/t/lookup-latest-row-idea-for-lookups-with-multiple-relations/12441/5):
>
> This is multiple steps, but you can do a rollup on your relation to get a max date for example, build a template with the rollup date and whatever you used for your previous relation in the sheet containing the relation and The sheet you are relating to. Then create a new single relation using the template to get only the last record. It’s a lot of Glide columns, but it’s better than a completely separate sheet and duplicated data.

so that resolves the question of getting the last phase submitted. As for the upcoming phase, I can do without it. Thank you Jeff 🙏

---

_[View the full topic](https://community.glideapps.com/t/comparing-two-lookup-columns/25550)._