Not sure how to describe this one…
I have a primary field in one tab of Publications. Each publication has a Pub Date column.
In another tab, I have Last Name as a primary field (of authors) and want to create a column that tells me the most recent publication they were attached to.
If I use Roll-Up with max value, I can get the pub date itself (1/12/20) to appear rather than the name of the most recent publication the author is attached to. So I think I need a formula that would produce, instead, the most recent Publication the author is attached to.