I’m trying to figure out how to create a column that lists the last date that a particular person was contacted. Right now, I have two tables: one is a list of contacts and another is a list of messages to that contact (with dates). I created a lookup table that populates a field “last contacted” by the time stamp on the message associated with that person as lookup to a linked field.
Here’s the problem: the field lists every single date that the person was contacted, not the last time the person was contacted. How would I filter the column to only show the most recent date? Or, some other work around that only takes the most recent time stamp associated with a linked record?