Web Applications Stack Exchange
Web Applications Stack Exchange

Questions tagged [google-sheets-timestamp]

Use for question about inserting a date, time or a date and time (timestamp) automatically into a Google spreadsheet.

Google spreadsheets are very popular for record keeping, sometimes they are used as a simple database. On this and other scenarios could be required to automatically insert the current date, time or both.

This could be done by using several methods:

  • Keyboard shortcuts
  • Google Apps Script
  • Add-on

Use this tag together with but not with or with any other tag related to other spreadsheets application.

131 questions
46
votes
6 answers

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

How can I automatically set "last updated" cell in row Google Docs Spreadsheets ? I want to create a column where the cells' value will be automatically set to when that row was last amended. Is this possible? How do I do this / what option do I use…
cwd
  • 824
  • 3
  • 10
  • 12
46
votes
4 answers

Add 3 hours to Date value (DD/MM/YYYY 00:00:00)

I have cells with dates in this format: DD/MM/YYYY 00:00:00 and I want to add 3 hours because I'm in a different GMT zone. Is possible to use dates in a formula? Something like: 30/12/2012 22:15:00 should become: 31/12/2012 01:15:00
Santiago
  • 571
  • 1
  • 4
  • 5
44
votes
3 answers

Auto-updating column in Google Spreadsheet showing last modify date

Trying to figure out a way to have column two auto-update to show a timestamp of the last update. I realize the doc shows a timestamp of the last modification, but we have a lot of clients accessing and adjusting the doc at the same time. So this…
RichGonzalez
  • 451
  • 1
  • 4
  • 4
41
votes
11 answers

Is there any way to create a timestamp in a Google Spreadsheet?

I use PSPad as a text editor, which allows you to press Alt + D to insert a timestamp, e.g.: 2010-07-17 23:45:44 Is there a way to do this in a Google Spreadsheet?
Edward Tanguay
  • 3,207
  • 7
  • 29
  • 36
40
votes
10 answers

How to insert the current date into a Google Spreadsheet?

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…
Celeritas
  • 3,558
  • 23
  • 47
  • 68
24
votes
10 answers

How to stop NOW function from auto-updating?

I'm using Google Spreadsheet's NOW() function as a shortcut to insert the current timestamp now. However, the value in the cell changes whenever the spreadsheet is modified in any way, even when the changes have nothing to do with that particular…
Pacerier
  • 6,373
  • 24
  • 68
  • 88
9
votes
2 answers

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

I've got a Google sheet that is updated quite regularly by a few people. I'd like to be able to view the doc, and at a glance—have a cell that shows a date (last modified) and another cell (user that made the modification). Is this at all possible…
user86903
  • 91
  • 1
  • 1
  • 2
6
votes
3 answers

Auto date insert when opposite cell is populated

I am creating a spreadsheet which will contain records of my daily expenditure. Something like the following: A | B ---------- 0 | 50.04 0 | 20.00 0 | 19.99 0 | 2.40 What I am trying to achieve is each time I insert data into a cell in the…
sisko
  • 161
  • 1
  • 1
  • 4
6
votes
1 answer

Google Spreadsheet Timestamp?

I'm looking for some help with my Daily Work Log spreadsheet. I've search and read many different version of making a "TimeStamp" in Google spreadsheet. And it seems I don't have enough experience for it to work correctly. The time stamp script I am…
myanda
  • 81
  • 1
  • 1
  • 5
6
votes
3 answers

Convert Text String into Date/Time Value

I'm fetching data into a Google Sheet. The date column contains multiple cells with the following text string pattern: Mon Mar 11 19:05:32 +0000 2019 The pattern always repeat itself: [day] [month] [date] [HH:mm:ss] [Time Zone offset] [YYYY] Can…
Elad Ratson
  • 812
  • 2
  • 11
  • 22
6
votes
1 answer

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

I want to time stamp when a cell was filled out in the column to the right of only certain columns. We use a simple spread sheet to keep inventory and I'd like to know when someone takes something or checks it back in for accountability reasons. I…
Jason Zuniga
  • 61
  • 1
  • 1
  • 2
5
votes
1 answer

Insert current date to cell based on content in other cell

Background: I am trying to create a sheet which tracks my costs on daily basis. Instead of entering the current date everyday, I want the sheet to store the current day based on the content I enter in the Costs column. For the cells in column C I…
Kristof Pal
  • 153
  • 1
  • 4
5
votes
2 answers

Add a 'creation date' value when a new line is edited

I have a Google Spreadsheets that is used by different people to add tasks for my team. Here's an example. People can add tasks to column B and I will assign them to the right people in the team, filling in the other columns. The first field I'm…
Koen
  • 61
  • 1
  • 1
  • 3
5
votes
1 answer

How can I stop Google Sheets charts from rounding down durations?

I've got a Google Sheets chart that displays the average pace of a day's rowing machine workouts (e.g. average the time to row 500m). It looks like this: The Query I'm using to get the data is this: =QUERY(Data!A:Z, "select A, 15 / (avg(G) / 500) /…
Leon Overweel
  • 151
  • 1
  • 3
5
votes
1 answer

Google Sheets Script Editor action not applying to all sheets

I have a Sheets file with a tab/sheet for each month. I am editing the Script Editor to apply an automatic Timestamp when an item is scanned. How do I make the same script for each sheet, but make it that it only adds the timestamp to that specific…
TeacherTim
  • 51
  • 1
1
2 3
…
8 9