I'm trying to get a cell in my Google sheet to reference the last modified timestamp from the Google Drive of the same file (not folder).

In other words, I'd like for a cell to update its timestamp for an entire Google sheet, whenever a change is made. It should reference every sheet within the file itself.

  • That makes sense. Is there a way for this to happen any other way? I just want the cell to tell me when the last time the spreadsheet has been modified – Tommy Dec 22 '16 at 0:36

Short answer

IMHO the easiest way is to add =NOW() as a cell formula.


The Google Sheets spreadsheet recalculation settings default value is "On change", that means that the result of NOW will be updated everytime a change is made on your spreadsheet.

Calculation settings



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.