Update a value on a sheet with a sub table value

[Dstrickland]

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?

Thanks

[Angie]

Hi,

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: