Get a date from the the newest modified column of another sheet both need to have same ID

@Zurisadai,

Have you tried using index/match?

for ex:

=index(sheet2[Estimated Finish Date to be entered manually], match([Service Ticked ID]@row, sheet2[Service Ticket ID],0))

This matches the Service Ticket ID field on your sheet 1 to the Service Ticket ID on sheet 2 and gets the Estimated Finish Date from that same row. Remember, if you try this, for the sheet2 references, click the references link in the pop-up, select sheet 2 (from the list of sheets) and the applicable column once the sheet subset is displayed.

Hope this helps.

How do your rows get added to the sheet? For example, if you use a Form to get new rows added to the sheet, on the Settings area of the Form setup you can set whether the new submission is added to the top or bottom of the sheet. If you're adding rows with a Form, just make sure the Form adds the row to the top of the sheet. That way, when you Index Match or Index Collect, what you want to grab will always be the first thing with that Service Ticket ID and an Index Match should always grab what you're looking for I believe.