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 ever sheet within the file itself.
Google sheet timestamp Google Drive's last modified
google spreadsheets
Short answerIMHO the easiest way is to add  =NOW() as a cell formula.ExplanationThe 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.ReferencesSet a spreadsheets location and calculation settingsNOW