The documentation says this:
The NOW Function and Worksheet Recalculation The NOW() function is a
member of Google Sheet's group of volatile functions, which, by
default, recalculate or update every time the worksheet in which they
are located recalculates.
For example, worksheets recalculate each time they are opened or when
certain events occur — such as when data is entered or changed in the
worksheet — so if the date or time is entered using the NOW()
function, it continues to update.
The spreadsheet settings, which are located under the File menu in
Google Sheets, offers two additional settings for when a worksheet
recalculates:
On change and every minute On change and every hour There is no option
within the program for turning off recalculation of volatile
functions.
Keeping Dates and Times Static If having the date or time continually
change is not desirable, use a shortcut option for entering static
dates and time include typing the date or time manually or entering
them using the following keyboard shortcuts:
The static date shortcut is Ctrl+; (semi-colon key) The static time
shortcut is Ctrl+Shift+: (colon key)
but I would consider using the function TIMESTAMP
just like this:
=TIMESTAMP()
This would give you static date time as follows
8-15-2019 16:53:52
But there is no function such as TIMESTAMP()
. You can easily add this:
Go to tools>Script Editor and paste the following code
function TIMESTAMP() {
var today = new Date();
var date = (today.getMonth()+1)+'-'+today.getDate()+'-'+today.getFullYear();
var time = today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds();
var dateTime = date+' '+time;
return dateTime;
}
Save the script and your sheets are now ready to use this function.
TODAY()
is also possible? – Jacob Jan Tuinstra Dec 20 '14 at 15:04