I've got a spreadsheet in Google Drive and one column is meant for the date the entry is made. Is there a button to do this? I'm aware of the functions =NOW() and =TODAY() but their description says the value is updated when the document recalculates. However I reopened the document a few minutes latter and it still had the same time. Why is this?It would be even easier that when I start typing in a new row the column for the date auto-populates.
How to insert the current date into a Google Spreadsheet?
google spreadsheets;google sheets timestamp
I was able to reproduce your findings, however, opening a spreadsheet doesn't result in a re-calculation.Press Ctrl + R to recalculate the entire sheet.There's one concern about this method: it changes all NOW() formula's into the current date/time.Therefore you might want to consider pressing Ctrl + ; in the creation date cell and add the date manually.Reference: Recalculation of Sheet