Skip to main content
60 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
  • 625
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.7k
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

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
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
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

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

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
  • 373
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
  • 14.9k
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

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.7k
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
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
2 votes

Google Sheets execute script only in certain range on certain sheet

Try changing r.getColumn() == 4 by r.getColumn() >= 4 && r.getRow() >= 6 && r.getRow() <= 100
Rubén - Volunteer Moderator -'s user avatar
2 votes
Accepted

.getSheetByName not returning specific sheet?

You'll want to check the event's sheet and cell, not necessarily a specific sheet. So, receive the event as a parameter to your event handler: function onEdit(event) ... then check the event's ...
Vidar S. Ramdal's user avatar
2 votes

Adding missing dates to Google Sheets

It looks like you are looking for a single formula solution but they could be hard to understand and maintain, specially if you aren't familiar on how the Google Sheets related features works. ...
Rubén - Volunteer Moderator -'s user avatar
2 votes

Removing Last Updated value when No data was selected from the column to check

Explanation: You can simply check whether the new value in column A is blank. If it is blank, then set the value in column B also to blank, otherwise, set date. You can use a Conditional (ternary) ...
Marios's user avatar
  • 385
2 votes

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

The Issue In Sheets times and dates are simply numbers that have been "formatted" as such. Where you see 8:00 it is a formatted version of the number 0.3333333333333330. Reason Sheets ...
Blindspots's user avatar
  • 6,044

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