Questions tagged [google-sheets-timestamp]
Use for question about inserting a date, time or a date and time (timestamp) automatically into a Google spreadsheet.
88
questions
0
votes
0answers
19 views
Google Sheets. Adding timestamps for multiple sheets in a workbook
Here is a copy of my current workbook
https://docs.google.com/spreadsheets/d/1S7V4Gkgr_1DiP5sMQ3EWYffvRi4S0b-C7G0O6MGejY8/edit#gid=442994829
Right now i am using a script that performs a timestamp ...
1
vote
1answer
26 views
Google Sheets Pulling data between a specific date and time, from a timestamp
I am trying to pull specific data from a timestamp that I will be using in several pivot tables.
Here is my workbook https://docs.google.com/spreadsheets/d/1iYHYdATK06Wxl-Jtxe2P92Kh50XEsWgwx5d-...
0
votes
1answer
25 views
Put Date in Specific Column
I found the following code in another post here to add a date after an edit but it places it in an offset column, I would like the date in Column 8 if column 3 or 4 has been edited.
What do I change?
...
0
votes
1answer
29 views
How to timestamp on new added cells in LIVE google spreadsheet?
The code below insert timestamp in google sheet by editing another column.
However, there an issue which I have no idea how to solve. When I add new row manually, it successfully adds timestamp, BUT ...
0
votes
1answer
27 views
How to automatically set date in a cell when a different cell value is changed by a formula from data on another sheet?
I currently have a column, e.g. ColB, containing SUMIF functions with its data range from other sheets and a column, e.g. ColC, with dates that I want to automatically update to the last date ColB's ...
-1
votes
1answer
23 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,-...
1
vote
1answer
55 views
Auto update of cells with timestamp
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 ...
0
votes
1answer
17 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 ...
1
vote
2answers
41 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, ...
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
16 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
53 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
222 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
27 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
67 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
29 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
42 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
32 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
2k 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
32 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
400 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
59 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
37 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
36 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
297 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
56 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
61 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
93 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 ...
0
votes
1answer
150 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";...
1
vote
1answer
82 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
91 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 ...
0
votes
3answers
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 ...
1
vote
1answer
67 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
75 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
786 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
847 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
687 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
66 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
914 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
397 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
5k 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
930 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
858 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 ...
1
vote
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
103 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
494 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
931 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 ...
