Update a value on a sheet with a sub table value

I have a form that is for tracking shipments, and within that form is an ETA Date field. I have a subtable of this table that users go in, enter some notes and other information and enter a new ETA date.

I only have 1 entry in the subtable, it updates my main ETA date field properly. If I have multiple entries it seems to add the ETA dates in the subtable together.

How can I update the ETA date with only the most recent information from the subtable?



If the “most recent information” means the “ETA” field of the latest subtable row, you may use LAST() to retrieve the value:

If the “most recent information” means the largest “ETA” field of the whole subtable, you may use LARGE() to retrieve the value: