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
    Commented Dec 22, 2016 at 0:36

1 Answer 1


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 and acknowledge you have read our privacy policy.

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