How can I select the most recent record from a list?
For getting the reference to the most recently created record in the same table, please refer to MAXROW() function described in the article below. The function returns the "Key " of the most recently created record.
If you are looking to get the most recent child record from a child record in a parent table for each parent record , then please refer to the sample app below
appsheet.com - Most Recent Child Row - This app shows how to get the most recent related row for a table Most Recent Child Row - This app shows how to get the most recent related row for a table appsheet.com
To get the row at the bottom of the spreadsheet, the row with the highest row number:
replacing TableName with the name of your table.
If your table has a timestamp column (Timestamp), and you want the row with the most-recent timestamp: