Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to show most recent entry in group of numbers

56 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Ok, I have been trying to do this for a while on my own with no luck.

I have a list of serial numbers. These serial numbers have more than one entry. I group the view by serial number so I can see all entries for any particular serial number. What I would like to do is figure out a way that I can see only the last entry for every serial number. My thought is to have a third field for a conditional formula. Something that just posts the number 1 if it is the most recent date. Then I can use a view to only see everything with the number 1 in that field. The problem is that I need to pull the most recent date for EVRY serial number group. Not just the most recent date over all. Hope that I am explaining this right. Here is an example of the a sample base:

Rich_Nuzzi_0-1674682858384.png

 

Please help! Thank you.

3 Replies 3

I believe @W_Vann_Hall 's answer in this thread might be a good building block (though you'd still need to figure out the final step of it working for each serial number).

Saw that one. But that is also for two separate tables. I am only using 1 table. But I do appreciate the tip.