59 votes

How can I automatically set "last updated" cell in row Google Docs Spreadsheets?

=iferror(A1+B1+C1+D1+J1+K1+L1+"x",today()) whenever the cells in the row changes the formula re-calculates. with the "x" in the equation it guarantees an error. which in return, returns the date.
Robert's user avatar
  • 615
55 votes

How to insert the current date into a Google Spreadsheet?

ctrl+; inserts current date ctrl+shift+; (ctrl+:) inserts current time ctrl+alt+shift+; (ctrl+alt+:) inserts current date and time Use ⌘ instead of ctrl on Mac OS However it does not work in Google ...
kolen's user avatar
  • 651
11 votes

How to stop NOW function from auto-updating?

This is an old post, but I was looking into this recently and figured I'd chime in. Depending on you needs, the easiest answer I could think of is by creating a drop down menu and referencing a ...
btodd's user avatar
  • 111
8 votes

How to insert the current date into a Google Spreadsheet?

I think the question is how to get today's date into a spreadsheet cell so that remains unchanged over time. I put "=today()" into a frozen header cell one time. That changes as the date changes. ...
Steven Zins's user avatar
7 votes

How to stop NOW function from auto-updating?

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 ...
Rishabh Gusain's user avatar
7 votes

Show a time-stamp in one cell when another cell is updated in Google Sheets

All you need is this short script function getDate() { return new Date(); } And then you can put this equation into E1: =getDate(C1:D1) which you can then drag down. You may also want to change ...
Tesseract's user avatar
  • 179
7 votes
Accepted

Convert Text String into Date/Time Value

={DATE(RIGHT(A1, 4), MONTH(MID(A1, 5, 3)&1), REGEXEXTRACT(A1, "\d+")), TEXT(INDEX(SPLIT(A1, " "), 1, 4), "hh:mm:ss")} with timezone in account: ={DATE(RIGHT(A1, 4), MONTH(MID(A1, 5, 3)&1), ...
user0's user avatar
  • 26.4k
6 votes

How to insert the current date into a Google Spreadsheet?

To insert static DateTime value use macros: In your sheet Tools -> Script Editor. Paste this code: function currentStaticDate() { var spreadsheet = SpreadsheetApp.getActive(); spreadsheet....
RasAlhague's user avatar
4 votes

Insert today's date as a value in Google Sheets

There is a shortcut exactly for this: Select the cell Press CTRL and ; That's it, the cell's content has been replaced with today's date.
nic's user avatar
  • 8,744
4 votes

How to show "Last edited" date and user on Google Sheets?

As Amit said in his answer, the onEdit() trigger will work for this, and you'll need to get values from the Edit event object. A complete solution for this use case would be something like: function ...
kevinmicke's user avatar
4 votes

Auto date insert when opposite cell is populated

I made an adjustment to Vidar's script for anyone who only wants the autodate to work once (the first time a cell is changed). This may be helpful in a timesheet where users sometimes go back to add ...
Michael's user avatar
  • 41
3 votes

Google Sheets Script Editor action not applying to all sheets

Get the sheet that was edited. Change code to: var sheet, ss; ss = SpreadsheetApp.getActiveSpreadsheet(); sheet = ss.getActiveSheet();//Get the active sheet Now the sheet variable is the active ...
Alan Wells's user avatar
3 votes

Timestamp based on cell value

This line: if( nextCell.getValue() !== '' ) //is empty? Should be: if (nextCell.getValue() === 'Complete') { nextCell.setValue(new Date()).setNumberFormat('dd-MM-yyyy HH:mm:ss'); }
Alan Wells's user avatar
3 votes

How do you get current date to be added to a cell when a check box is checked in another cell

I adapted user0's answer to have the following additional features: It works in a multi-worksheet spreadsheet by specifying which sheet the change will occur in, as opposed to making the same change ...
Vincent's user avatar
  • 363
3 votes
Accepted

How to automatically add 00 minutes to hours in Google Sheets?

You can do that with an onEdit(e) simple trigger, like this: /** * Simple trigger that runs each time the user hand edits the spreadsheet. * * Converts numbers like 8 and 15 into times like 8:00 and ...
doubleunary's user avatar
2 votes

How can I automatically set "last updated" cell in row Google Docs Spreadsheets?

Here's a version that finds the column using the header, rather than hardcoding the column number, and uses a custom time zone: function updateModified(options) { var sheet = SpreadsheetApp....
Benjamin Atkin's user avatar
2 votes

How to insert the current date into a Google Spreadsheet?

On an italian keboard use Ctrl+è for current date Ctrl+Shift+è for current time Ctrl+Alt+Shift+è for current date and time
Gabriele's user avatar
2 votes

How to insert the current date into a Google Spreadsheet?

On a Brazilian portuguese keyboard use Ctrl+ç for current date Ctrl+Shift+ç for current time Ctrl+Alt+Shift+ç for current date and time
Álister Lopes Ferreira's user avatar
2 votes

How to stop NOW function from auto-updating?

Per, A way for static "now" in Google sheet? (@the-god-of-biscuits), putting a volatile function inside a Lambda function makes it 'sticky'. For example, if the lambda contains no external ...
KnowHow_ryan's user avatar
2 votes

How to stop NOW function from auto-updating?

=IF(A1<>"",IF(B1<>"",B1,NOW()),"") This will provide the date/time in B1 as soon as cell A1 is populated, and it will not update as the sheet updates. You ...
Sean's user avatar
  • 31
2 votes

How to stop NOW function from auto-updating?

Another option (an expansion of this answer ... "Example: 1. Select A10:A20 > right click > Data Validation Criteria = "List from range" > F2 2. Formula in cell F2: =mult(now(),1) " ) Is to ...
user235027's user avatar
2 votes

How to stop NOW function from auto-updating?

Another option is to copy the value of the cell and paste it in the same respective cell, but with values only special paste option. Input =NOW() in a cell. Copy it Ctrl+C Paste in the same cell ...
47tucanae's user avatar
2 votes

Your Time stamp code

Please use lower case ds, ie for Line 7: time = Utilities.formatDate(time, "GMT-08:00", "MM/dd/yy, hh:mm:ss"); GAS uses Java SE SimpleDateFormat class, where D is Day in year.
pnuts's user avatar
  • 17.5k
2 votes
Accepted

Timestamp Google Drive's "last modified"

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 ...
Rubén - Volunteer Moderator -'s user avatar

Only top scored, non community-wiki answers of a minimum length are eligible