# Getting a cell value according to the latest date

**URL:** <https://community.glideapps.com/t/getting-a-cell-value-according-to-the-latest-date/83577>\
**Category:** Ask for Help\
**Created:** [July 31, 2025, 10:32am UTC](https://community.glideapps.com/t/getting-a-cell-value-according-to-the-latest-date/83577 "2025-07-31T10:32:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jbandeira86](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jbandeira86/32/90874_2.png) [@jbandeira86](https://community.glideapps.com/u/jbandeira86)\
**Post date:** [July 31, 2025, 10:32am UTC](https://community.glideapps.com/t/getting-a-cell-value-according-to-the-latest-date/83577/1 "2025-07-31T10:32:31Z")

</div>

Hello!

Just started using Glide and finding it an amazing tool. Still learning and I think I may be having some trouble with relations.

I have two tables. One, lists bins where I have the bin number and two relations to the other table. The relation is to the number of the bin and I have a rollup which shows the latest record date on the second table.

 ![First table, bin list](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/dea7cb3e2795b8dbf8e68fd1a4439bfefd1143de.png)

The second table, records the level of each bin, according to different dates. This table has the same bin number as the first one and a relation between their numbers.

 ![Second table, records bin level and record date](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/bef7d2186588cf546194cebfd5e8f3fe7b1c8416.png)

What I am missing is that I want as well to show along with the latest date, the latest level of each bin, a unique value. I’ve tried playing with single value, but I always get the maximum value of all bins and not the latest.

What am I doing wrong?

Thanks 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:** [July 31, 2025, 11:24am UTC](https://community.glideapps.com/t/getting-a-cell-value-according-to-the-latest-date/83577/2 "2025-07-31T11:24:12Z")

</div>

Use a Query instead of a relation. Filter where bin is this row→bin, and sort by date in descending order. Don’t check match multiple. Then use a lookup through the query.

Or alternatively, use a rollup→ latest through your relation.