Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

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

0
votes
0answers
19 views

Two timestamps referencing different columns in one google sheet? [duplicate]

I'd like to have a timestamp occur in column 6 when an edit is made to column 1. But another timestamp to occur in column 6 when an edit is made to column 8. I would be open to having the 2nd ...
2
votes
1answer
13 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 ...
1
vote
1answer
37 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 ...
0
votes
1answer
45 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 ...
0
votes
1answer
23 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)... ...
1
vote
2answers
61 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 ...
0
votes
1answer
19 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 ...
0
votes
0answers
29 views

Auto date insert when opposite cell is populated in different columns - only if in a particular sheet in a document

I found this solution to autoinclude the date in a column when another one is modified and it works great. Auto date insert when opposite cell is populated What Im looking to do is: To modify this ...
0
votes
0answers
29 views

Auto timestamp based on specific value

Currently, I am using below code to update timestamp in the next column. But I want to modify the code to update timestamp only when the cell value is True not on a change of cell value. function ...
1
vote
3answers
457 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] ...
0
votes
0answers
28 views

Auto update date in google sheets based on edit in range of cells [duplicate]

I want to update a timestamp based on the last time any cell in a range is updated. I added this script: function getDate() { return new Date(); } In a cell I use the formula: =getDate(D5:AF5) ...
1
vote
1answer
151 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 ...
0
votes
1answer
44 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:...
2
votes
1answer
34 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 ...
1
vote
1answer
29 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 ...
0
votes
0answers
263 views

timestamp for specific value change in different column

I want an automatic timestamp to appear in column D ('Receive Date') when the value in column B ('Status') is changed to 'Received'. I have the script below, but it inserts a timestamp regardless of ...
1
vote
2answers
46 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 ...
0
votes
1answer
57 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 ...
0
votes
1answer
90 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 ...
-1
votes
1answer
119 views

2 time stamps in different cells I would like both of the scripts below to work 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";...
0
votes
1answer
70 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 = "...
0
votes
1answer
89 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 ...
-1
votes
1answer
370 views

Replace formula with its value after evaluation

In Google Sheets, I'd like to replace a formula with its evaluated value immediately after evaluation. Specifically, given two empty cells A1 and B1, I'd like B1 to be filled with the timestamp of ...
0
votes
3answers
1k 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 ...
0
votes
0answers
872 views

Auto insert current date when a cell value changes to one of two specific values

I am trying to enter the date and time when a certain query gets resolved. I am using the below script for entering the create-date timestamp in column T, however I would also like to add another ...
1
vote
1answer
61 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('...
0
votes
0answers
29 views

Locking the value of TODAY() [duplicate]

I have two columns in my spreadsheet, A and B. In column A I would like to add the date the corresponding row's value in B was added. I'm thinking something along =IF(ISBLANK(B2),"",TODAY()). The ...
2
votes
1answer
68 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 ...
0
votes
1answer
745 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 ...
2
votes
1answer
796 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 ...
1
vote
1answer
611 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.
0
votes
0answers
62 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 ...
5
votes
1answer
712 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: ...
1
vote
1answer
372 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 ...
3
votes
1answer
4k views

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 ...
0
votes
0answers
912 views

Automatically set “last updated” cell in row Google Docs Spreadsheets

To follow up on this solution, instead of offset(0,7) to any active cell, is there a way to change line 6 (var nextCell = r.offset(0, 7);) in the code below to display the last updated code a ...
1
vote
1answer
741 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 ...
1
vote
1answer
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 ...
0
votes
2answers
1k 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 ...
-1
votes
1answer
98 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.
4
votes
1answer
439 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 ...
0
votes
1answer
3k 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 ...
4
votes
1answer
884 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 ...
1
vote
2answers
3k 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(); ...
1
vote
1answer
3k 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?
4
votes
2answers
20k views

Automatic date in Google Docs

Is there a way in Google Docs to automatically update the date in a header of the page, so that whenever I print the document it will have today's date?
-1
votes
1answer
1k 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 "...
1
vote
2answers
3k 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 ...
2
votes
1answer
1k 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 ...
-1
votes
1answer
176 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 ...