Questions tagged [google-sheets-timestamp]
Use for question about inserting a date, time or a date and time (timestamp) automatically into a Google spreadsheet.
1
vote
2answers
33 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 ...
-1
votes
0answers
14 views
Query or filter timestamp time and date
I am looking for a formula on Google Sheets that will allow me to provide 2 conditions from the timestamp. One is the date, which is easy =now()-1 for yesterday. What I am looking to query is ...
0
votes
1answer
27 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
0answers
49 views
How to create a timestamp based on multiple cells' values?
I've referred to this example from 2017 but need a modification: it works but I'd like to modify it so 1) a date is NOT automatically populated without the cell 2) being populated with specfic text "...
0
votes
1answer
38 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
55 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
80 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
1answer
68 views
Google Sheets: 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 ...
-1
votes
3answers
366 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 date of last modification on any cell of the G ...
0
votes
0answers
548 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
50 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
25 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
42 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
505 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
461 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
308 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
44 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
306 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: ...
0
votes
0answers
47 views
Time Stamp Every Last Date Each ROW is Updated [duplicate]
I've looked at other questions on this and I don't think this specific question has been asked. Is there any way to have a column, let's say column B, that could show the last date that particular ...
0
votes
1answer
267 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 ...
0
votes
0answers
36 views
Two Timestamps in diffrent cells to update seperately when data is put into a cell
I am trying to get two separate timestamps to fix to two different cells when data is put into a separate column.
E.g
If i enter a number in B3 i get a timestamp in D3
I also enter a number in C3 and ...
0
votes
0answers
409 views
Insert timestamp and last changed timestamp in a Google Sheet
I've been trying to make these two functions to a Google Sheet;
If any value in row C, then inject creation timestamp in ROW A (code 1)
If any value from ROW D and further, then inject last modified ...
0
votes
0answers
56 views
How to get the data value of NOW() and stored as text
this is the document.
https://docs.google.com/a/hitek.com.mx/spreadsheets/d/1IcrITujtSOJSInIlDc7gmVkTpekxz9qa6C5sL1J4FEU/edit?usp=sharing
Basically what it needs to happen is the following.
Column ...
0
votes
0answers
335 views
Insert timestamp when a criteria is met leaving the old cells with time stamp
I want to use the following code for two sheets with different columns to insert timestamp once the criteria have been met.
sheet1 = "Data Enrichment" & sheet2 = "Data"
/*Final working Script*/
...
1
vote
1answer
1k 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
756 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
420 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
1k 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
1answer
807 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
83 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
332 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
2k 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
672 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
2k 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
2k 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
16k 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
752 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
1answer
1k 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
148 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 ...
-1
votes
1answer
527 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/...
3
votes
1answer
695 views
Timestamp in two columns
As a teacher, I am trying to create a Google sheet for the students to use as they sign in and out of class. I have successfully used code to auto insert a time stamp into column A if Column C is ...
1
vote
1answer
70 views
Time stamp on last row of column for changes in predetermined range
I am looking for a way to add a time stamp to the last row of a column of figures any time there is a change in the above range. I have been able to find a number of examples where you can timestamp ...
4
votes
1answer
3k views
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 ...
2
votes
1answer
179 views
Auto calculate and display timestamp in a specific row and column
I have a spreadsheet with a formula that works to display the timestamp in the same row, but is there a way to set a column at the same time so I don't have multiple time stamps displaying along that ...
4
votes
1answer
273 views
Update column with last update of row in Google Sheets… except the header
I've been using this code to find the most recent update of a given row:
function onEdit() {
var s = SpreadsheetApp.getActiveSheet();
var r = s.getActiveCell();
if( r.getColumn() != 5 ) { //...
3
votes
1answer
698 views
Capture Created Date from form that allows for editing
I've looked through the previous posts and can only find information where it looks like the responder assumes that the form is completed in one go, so the TimeStamp column is the obvious answer to ...
1
vote
1answer
538 views
Triggering timestamp on formula input
I'd like to have a timestamp which triggers its input depending on a cell containing a formula like =IF(ISBLANK(cell),"", time ), and not upon manual input.
My script is the following and is working ...
3
votes
1answer
697 views
Google Spreadsheet Timestamp on Edit?
I got the major part of answer on this link:
Google Spreadsheet Timestamp?
The code on this link is below:
function onEdit() {
var s = SpreadsheetApp.getActiveSheet();
if( s.getName() == "Sheet1" ...
2
votes
1answer
313 views
Creating multiple timestamps on Google Sheets to make dependent drop-down boxes work
I need timestamps on two different sheets to make two different dependent drop boxes work. I use the scripts below but can only get one sheet to work and not both sheets:
Script time in
function ...
