Lookup field to pull most recent from a multiple linked field.

Question

On Table A I have a linked record field that allows multiples. It pulls records from Table B. These records on Table B include a Date field. Records on Table B are not necessarily entered in chronological order. For example:

Table B Record 1 - 1/1/2023
Table B Record 2 - 3/1/2023
Table B Record 3 - 2/1/2023

On Table A, I'm trying to pull the most recent record linked using a Lookup field with the "limit the number of items shown" option turned on and set to "last 1" but I believe this is giving me the date of the linked record that was most recently created rather than using the date field of the record to give me the most recent.

I believe I could play around with an automation that could accomplish this for me but before diving into that, is there a more simple way to achieve this?

Jonathan_Gunne1 · Accepted Answer

Figured it out! Instead of a Lookup field, I needed a Rollup field that pulls the Dates from the Table B records. Then aggregated with MAX(values).

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded