Skip to main content

Questions tagged [google-sheets-timestamp]

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

Filter by
Sorted by
Tagged with
-1 votes
1 answer
574 views

Function OnEdit run slow and timeout error

I have a short timestamp script for my google spreadsheet. But it run quite slow and make a lots function onEdit(e) { var TIMERECIEVE = [0,-29]; var DATETRECIEVE = [0,-28]; var DATEDONE = [0,-...
OS Imagtor's user avatar
0 votes
1 answer
146 views

Auto update of cells with timestamp [duplicate]

I'm new to writing/using scripts. I want to use something to allow for multiple cells to be updated and tracked for the last time they were modified. I've tried various different scripts on here but ...
Nick's user avatar
  • 11
2 votes
1 answer
78 views

Timestamp format with carriage return

I have this time stamp format: var timestamp_format = "yyyy-MM-dd HH:mm:ss"; Which produced a result like: 5/25/2019 10:52:43 but I would like to have a carriage return between the date and time ...
Bryan Keadle's user avatar
3 votes
3 answers
14k views

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

I want to get the current date added into a cell when a tick box is checked in another cell. I currently have another formula in the date cell which changes its colour when the tick box is checked, ...
Christopher Grant's user avatar
2 votes
2 answers
1k views

How do I create multiple time zones by using the NOW formula?

I'm trying to create 5 cells with different time zones: CDT MDT MST PDT EDT I am in MST, so I obviously get my current time by doing NOW() How do I add hours to that? I tried NOW()+(2,0,0) But ...
Tyler Garver's user avatar
1 vote
1 answer
345 views

Inserting date automatically when a tick box is ticked

I have a simple sheet that has two columns with tick boxes in them (columns 5 and 8) The goal is when the box is ticked the date and time are inserted in the column next to it. I have got it working ...
ceolnamara's user avatar
0 votes
1 answer
560 views

Google Spreadsheets timestamp

I'm trying to have a timestamp automatically appear in column L (12) in a Google Spreadsheet if a tick box is ticked on the same row (in column A). The app script code that I modified from this source ...
ibkid's user avatar
  • 3
0 votes
1 answer
261 views

Method to preserve cell reference in a formula upon adding rows in reference sheet?

I have a Google Sheets with two(2) tabs. The first sheet is just a running tally of raw data and is updated with new rows at the top weekly. In tab 2 there is just a single query(arrayformula)... ...
rosa's user avatar
  • 85
2 votes
2 answers
494 views

How do I get the count number of weekdays in a datetime column in Google Sheets?

I have a timestamp in mm/dd/yy hh:mm:ss format from January to March. How do I count "how many days are Monday" in the range of A1:A199? (Or How Many are Tuesday, Wednesday, Saturday? This gives me a ...
rosa's user avatar
  • 85
0 votes
1 answer
750 views

Google Sheets adding weird number in 11th decimal place

Can anyone explain this? I have 18 hardcoded numbers - that is, typed in, not as a result of a formula. [B1 thru B18] I have a cell [D1] that sums those 18 numbers. I have eleven other hardcoded ...
Ben Adams's user avatar
6 votes
3 answers
32k views

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] ...
Elad Ratson's user avatar
0 votes
1 answer
1k views

How to date/timestamp for modifications in Google Sheets?

I have a sheet that has information in 8 columns starting in row 14. I would like I14:I310 to date stamp anytime there is an update in the corresponding row. I have tried a couple of different ways ...
Julie Dunsmuir's user avatar
0 votes
1 answer
563 views

How to print the first modified date of a cell

I would like to make a script that works like this script to print a timestamp when a cell was last updated but in this case I want to return when it was first updated, not last. Here is one attempt:...
luisgonzalez's user avatar
2 votes
1 answer
65 views

Timestamping purchase entries

I’ve created myself a budget tracker where I can track what I bought and how much I spent across a few categories. I specified column B (purchase entries are rows) to be the date and time at which I ...
Alec's user avatar
  • 21
2 votes
1 answer
159 views

Can I record the users within a Google sheet?

I'd like to have an auto-generated list of users with timestamps within a spreadsheet, tabs, or if possible specific cells. Ideally, once a cell has been altered, I'd like another cell to record the ...
Dan M's user avatar
  • 21
0 votes
1 answer
624 views

Auto update field exclude header row [closed]

In Google Sheets I have a column that needs to be updated with the current date & time every time another cell in the same row is updated, but skip the top row which is the header. I found this ...
user198427's user avatar
1 vote
2 answers
153 views

Formula for dates in Google sheets doesn't work when static time included

I'm trying to make a formula that takes a date formatted like this "10/7" and will spit out the date 3 days before it. So I make a formula =C79-3 and that spits out the date. However, I also ...
Jin's user avatar
  • 135
0 votes
1 answer
94 views

How to calculate hours per date

I am trying to use A Google Sheet generated by Google Forms to track total attendance time in lab for a robotics team. I have created a form with the following questions: Checking in or Checking out ...
SteveC's user avatar
  • 101
0 votes
1 answer
164 views

Change COUNTIF range based on the current day of the week, with 3 days using the same dataset

I work as a delivery driver and have been futzing around trying to create a google sheet that automatically updates with the current day's drops. However, there is a rub with the data set. The ...
Tank R.'s user avatar
  • 101
0 votes
1 answer
237 views

2 timestamps in different cells at the same time [duplicate]

function onEdit(event) { var timezone = "GMT-7"; var timestamp_format = "MM-dd-yyyy-hh:mm"; // Timestamp Format. var updateColName = "Ext Warehouse"; var timeStampColName = "Date/Time Change";...
michael s ingwerson's user avatar
1 vote
1 answer
150 views

How to extend script on next column?

How should I modify the script, in a way that it would work also in another column, eg. by putting data in A:A date will be printed in B:B and also in C:C function onEdit() { var sheetName = "...
Deep Kumar's user avatar
0 votes
1 answer
124 views

Timestamp for Edits Made to 1 Cell Only

I have this script that works perfectly for any edit on the spreadsheet page: function onEdit(e) { if (!e.value) return; e.source.getActiveSheet() .getRange('F29') .setValue(new ...
Tamarissa's user avatar
0 votes
3 answers
2k views

Auto-updating timestamp [duplicate]

In a particular cell of a column, I would like to have a timestamp of the last date any cell of that column was modified. Specifically: G31 would show a date of last modification on any cell of the G ...
Fanny Bissonnette's user avatar
1 vote
1 answer
160 views

How to add a date to a cell next to an cell with an imported value

In column A I have a value added each day from the tab/cell TOTAL/A1 by this script: function dailyLog() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sourceSheet = ss.getSheetByName('...
Fredrik's user avatar
  • 11
2 votes
1 answer
142 views

Make function only work on first sheet, not in whole Google Sheets file

I have the following code which is for tracking the date of any edit made in a particular row. However, this code applies to the whole spreadsheet file, I would like to change this to be for the 1st ...
Keith Mauppa's user avatar
0 votes
1 answer
2k views

Pasting timestamp for edits by multiple users in Google Sheets

I got a good Google Sheet script for pasting a time stamp at the designated column of the same row on editing any cells of another particular column. Here it is On Edit of column 11: timestamp is to ...
Manoj Mathew's user avatar
2 votes
1 answer
1k views

Put the timestamp of last edit on master sheet, next to edited sheet's name

I'm trying to come up with a script that will print a timestamp of the last edit made to a specific tab within a google sheet. Imagine you have 17 retail stores, each one having its own tab with a set ...
Alex Farmer's user avatar
1 vote
1 answer
1k views

Counting timestamp considering time and date

How do I count timestamp considering both date and time range?For example, I want to count how many cells are within 2/14/2018 22:00 to 2/15/2018 1:00.
kjcc's user avatar
  • 11
0 votes
0 answers
137 views

Google spreadsheets: How to get average session per user instead of all users?

In google spreadsheets I'm trying to get the average session per user from Google Analytics, so I tried ga:avgSessionDuration on metrics, ga:date in dimensions, it returned me the time in seconds, so ...
023023's user avatar
  • 123
5 votes
1 answer
3k views

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: ...
Leon Overweel's user avatar
2 votes
1 answer
1k views

Script for GoogleSheets that inserts date, time, and user names of everyone entering text in a specified cell?

I wanted to ask for your help in building a script in Google spreadsheet that would allow users to respond to comments left by different users in the same cell (cell where the initial comment was ...
µHg30's user avatar
  • 21
1 vote
1 answer
923 views

Google script to delete on condition

I'm trying to fix a script for a Google Spreadsheet, https://docs.google.com/spreadsheets/d/1J3VRBXkx5B3p1fmrVpkI3Y6F5EGns9Vao7FyxOQsSVo/edit?usp=sharing I wrote to following: function ...
Robert's user avatar
  • 11
6 votes
1 answer
17k views

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

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 ...
Jason Zuniga's user avatar
1 vote
1 answer
2k views

Create fresh duplicate of Master Google Sheet on a daily basis

I'm trying to hack together a paperless data-entry solution for my company using Google Sheets. Basically, our employees are required to fill out daily logs on paper. Needless to say, this is ...
Brian CT's user avatar
3 votes
1 answer
14k views

Dating When a Cell is Edited in Google Sheets

I want to autofill the date of an edit in one cell into the next cell. Specifically: When I enter something into any cell in column 2, I want the cell next to it in column 3 to autofill the date. ...
Josh Kelver's user avatar
1 vote
1 answer
2k views

Update a timestamp in a cell only when specific text is entered in another cell

Looking for a timestamp to be created in Google Sheets in cell B2 based on the text "Loading-Outside" being entered into cell A2. I know the below script will work for any edit made to the cell, but ...
Bowen Williams's user avatar
1 vote
2 answers
2k views

Timestamp based on cell value

I've created a script that inserts a timestamp based on any update to a specific cell; however I'm trying to insert a timestamp on a specific condition: 'Complete'. Would anyone know how to modify ...
Jack's user avatar
  • 11
-1 votes
1 answer
144 views

A date column in Google Sheets, e.g column B, that fills itself when I enter a value to its neighbour cell in column A

I need to create a date column that automatically returns the date in which I filled its neighbour cell. For example, when I enter data to cell A2, B2 will return the date the data was entered to A2.
Beto's user avatar
  • 1
5 votes
1 answer
964 views

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 ...
TeacherTim's user avatar
0 votes
1 answer
10k views

.getSheetByName not returning specific sheet?

I'm using a script to add a timestamp when a value on a given row is changed. My issue I'm running into is that the getSheetByName isn't returning the sheet I want, rather the script is running across ...
Kyle Walker's user avatar
2 votes
1 answer
22k views

Cell last modified date & user stamp Google Sheets?

I want the cells of two columns in my Spreadsheet to auto-update with the date (m/d/y) and name of user when cells in a certain range are edited. For instance, Catherine goes to sheet on 3/6/2017 (...
Barnett's user avatar
  • 21
4 votes
1 answer
2k views

Timestamp Google Drive's "last modified"

I'm trying to get a cell in my Google sheet to reference the last modified timestamp from the Google Drive of the same file (not folder). In other words, I'd like for a cell to update its timestamp ...
Tommy's user avatar
  • 43
1 vote
2 answers
5k views

Google Sheets execute script only in certain range on certain sheet

Currently I use this script to put a timestamp in a column when a value is entered into a cell in the same row but different column. function onEdit(e) { var sheet = e.source.getActiveSheet(); ...
Andrew J's user avatar
3 votes
1 answer
9k views

Auto insert column with today's date every day

I would like Google Sheets to insert a new column between columns A and B at the start of each new day with that day's date in cell B1. Is there a function or script that would make this possible?
Alex's user avatar
  • 33
-1 votes
1 answer
2k views

An "Updated on" field that records the last time that a particular column changed [duplicate]

Is it possible to create a "last updated" field under Google Sheets? I have a status column, where the status progresses something like: New -> Pending -> Started -> Done I would like to add a "...
user2813274's user avatar
1 vote
2 answers
11k views

Timestamp code for Google Sheets

I am using this script in order to put a time stamp in column B when someone edits in a row. However, I need it to place the time stamp if someone edits a row in column A. I don't need it to place a ...
Scott Miller's user avatar
2 votes
1 answer
2k views

Periodically updating a URL in the ImportXML command with a script

I am using importxml to extract prices from multiple websites. My main concern is to be able to refresh the prices whenever I want and not be dependent on Google's hourly update. I am using this ...
user1314051's user avatar
-1 votes
1 answer
236 views

Your Time stamp code

I have copied and pasted your code to put a time stamp on a spreadsheet that I am working on and it is working great. Except the day is coming back as "56" for some reason and I don't know why. It ...
Scott Miller's user avatar
3 votes
2 answers
5k views

How to add current date to cell if the rest of the cells (or some cells) in that row are edited, but only the first time?

I have a column A4:A (heading = Date), and other columns after it B4:O. I want column A to fill in today's date automatically when I fill in any other columns (some of these B4:O maybe empty, but ...
Spongebob Squarepants's user avatar
-1 votes
1 answer
6k views

Insert today's date as a value in Google Sheets [duplicate]

I have a Google Sheets where I store customers details and the date of the last time I contacted or was contacted by this customer: Customer name | Last contact date Bob | 2016/01/...
nic's user avatar
  • 8,754