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.
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