Adding a Most Recent Saved Time in Google Sheets

1
votes

I would like to add a cell at the bottom of my spreadsheet that simply says the time it was most recently saved. This would need to automatically update every time Google Sheets automatically saves. Does anyone know if there is a way to do this?

Thanks!

1
google-sheets

1 Answers

2
votes

The sheet automatically saves whenever it's edited. There is an onEdit() trigger, so you could run the simple onEdit() function to enter the date value in the sheet.

function onEdit() {
  var thisSheet = SpreadsheetApp.getActiveSheet();
  var theLastRow = thisSheet.getLastRow();
  var newRowRange = thisSheet.getRange(theLastRow+1,1);
  var theDateTime = new Date();
  newRowRange.setValue(theDateTime);
};