Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: How to show most recent entry in group of numbers

665 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rich_Nuzzi
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

4 Replies 4
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

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.

AlxdS
4 - Data Explorer
4 - Data Explorer

Same issue here. Did you find a solution?