# How can I identify the most recent date for a related exercise?

**URL:** <https://community.glideapps.com/t/how-can-i-identify-the-most-recent-date-for-a-related-exercise/60028>\
**Category:** Ask for Help\
**Created:** [April 2, 2023, 10:44am UTC](https://community.glideapps.com/t/how-can-i-identify-the-most-recent-date-for-a-related-exercise/60028 "2023-04-02T10:44:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hawki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hawki/32/42137_2.png) [@Hawki](https://community.glideapps.com/u/Hawki)\
**Post date:** [April 2, 2023, 10:44am UTC](https://community.glideapps.com/t/how-can-i-identify-the-most-recent-date-for-a-related-exercise/60028/1 "2023-04-02T10:44:45Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d531747d21e4647cd357c66b542d3e5fd0d1f066.jpeg)

Hi folks 👋

I’ve hit a roadblock in a fitness app that I’ve been building. As shown in the image, I have four sheets: Users, Workouts, Exercises and Sets.

Within the ‘_sets_’ sheet, I have the date that the set was recorded, along with the ‘_Related exercise_’, the ‘_Rollup of dates_’ in which I show the latest, and a True/False column to indicate whether this is the ‘_latest set_’, all of which are on the right side.

Problem  
My rollup column shows the latest date for all sets, instead of the date of the last set for each exercise. So my question to you experts is: **How might I show the latest date for each exercise, so that I can then designate this as True for the latest set?**

Any support would be grateful appreciated 🙏

---

<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:** [April 2, 2023, 10:51am UTC](https://community.glideapps.com/t/how-can-i-identify-the-most-recent-date-for-a-related-exercise/60028/2 "2023-04-02T10:51:28Z")

</div>

You probably want to do it in your Exercises table.  
Create a multi-relation in that table that matches the exercise name with the name in the Sets table, and then do your rollup through that relation. That should give you the latest for each exercise.

---

<div class="post-metadata">

**Author:** ![Hawki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hawki/32/42137_2.png) [@Hawki](https://community.glideapps.com/u/Hawki)\
**Post date:** [April 2, 2023, 12:37pm UTC](https://community.glideapps.com/t/how-can-i-identify-the-most-recent-date-for-a-related-exercise/60028/3 "2023-04-02T12:37:35Z")

</div>

I’m not entirely sure what I did, but this worked a charm. Thank you 🙏

---

<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:** [April 3, 2023, 12:38pm UTC](https://community.glideapps.com/t/how-can-i-identify-the-most-recent-date-for-a-related-exercise/60028/4 "2023-04-03T12:38:16Z")

</div>

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