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