Timestamp Google Drive's “last modified”

Question

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.

Answer 1

Short answer

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

Explanation

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.

References

• Set a spreadsheet’s location and calculation settings
• NOW