Questions tagged [google-sheets-timestamp]
Use for question about inserting a date, time or a date and time (timestamp) automatically into a Google spreadsheet.
104
questions
0
votes
0answers
8 views
How to set a script to delete a row that contain specific word in column D on google sheet and to auto delete the data after any hour set [closed]
I am new to this, I wanted to set an automation using UiPath every hour. However, The process to pasting and filtering certain row will take some time. If i can a have script to run on pasting and ...
2
votes
1answer
42 views
Removing Last Updated value when No data was selected from the column to check
I need help on my Google Sheet script. It is working fine on showing the timestamp of Last Updated at colB every time a new Call Status was set at ColA ; but when I deleted the status at colA, the ...
0
votes
0answers
26 views
Is there a way to pull first modification date from a cell with Google App Script? [closed]
I have a bunch of Google Spreadsheets with a lot of data (inputs from a webpage from past years), but unfortunately, there was no column with a timestamp at that time. Is there a way to pull from ...
0
votes
1answer
10 views
I'm having trouble getting this to export military time
Can you tell me how to modify the date/time format to give me military time?
I'm Los Angeles time which is GMT-08:00
It's giving me 07:28 but what I want is 19:28.
2
votes
2answers
54 views
Calculate Total DateDif Average Between 2 Columns (start, end) according to year expressed in days, hours, minutes
I'm having trouble getting a formula to work to calculate the total average time between times (start and end).
Sheet: https://docs.google.com/spreadsheets/d/...
0
votes
1answer
35 views
Google Sheet Script for automatically entering date/time stamp when the adjacent column
I've found a script on here for entering a timestamp in a column based on edits to the adjacent column:
Date and time stamp automatically added in column
if(e.source.getActiveSheet().getName() == &...
1
vote
1answer
99 views
How can I automatically timestamp rows in a Google Sheet? [duplicate]
I am entering data into a Google Sheet. I would like to have a column where each row will be automatically timestamped with the DateTime in which I entered (or last updated) the contents of the row.
I ...
1
vote
0answers
10 views
Google sheets - last updated
I've seen scripts for this but am absolutely clueless and cannot make it work :(
I want the Last Updated cell (D1) to update whenever the Destiny and Warframe scores update (D4 and D5). These values ...
0
votes
1answer
17 views
TimeStamp syntax to appear 24 Hrs Timestamp
I am using
var TIMESTAMP_FORMAT = "yyyy-MM-dd hh:mm:ss a";
var TZ = "GMT-7";
in my script code of Google document
I want it to be convert into 24 hrs timestamp
What changes should I do ?
0
votes
0answers
16 views
Time Stamp auto populate in three columns
Need a code so that when I edit Column B it auto populates the time in Column A, also when I edit the same row but in Column F it auto populates the time in Column G and lastly when I edit Column H it ...
2
votes
0answers
42 views
How to make a cell autopopulate the date dependent on another cell
I'm trying to make a recruitment sheet for an online community I help run. What I'm currently attempting to do is that when we record a person has joined the Discord to column B, it'll automatically ...
0
votes
0answers
48 views
timestamp when copying data
I am trying to enter a timestamp in google script for a google sheet with date/time & user in columns 14 (data entry) and 15 (last modification) with some conditions (the most important is data in ...
0
votes
0answers
23 views
Print First Modified TimeStamp of edited Cell in a Column range [duplicate]
This code by @Ruben prints out the timestamp for the first modification for A1 into B1. How to do the same but for the whole column so A2:A printing results into B2:B?
// Global variables
var origin =...
2
votes
1answer
47 views
How to count Hours and Minutes in one cell
I want to count # of hours worked by subtracting the Start & end time in 1 cell (as per my comp template) ( 9am - 6pm) .( No I can't alter the template to put start & end in different cells/...
1
vote
0answers
43 views
Date Formatting Issue in Google Sheets Query
I created a shared shipment tracker with google sheets where updates are made in a master tab, then filtered into several regional tabs via query function to better visualize shipment status by region....
0
votes
0answers
26 views
timestamp in a cell when another is modifyed
I'm not experience in scripts at all, but I need to time stamp DD.MM/HH.MM in cell "C16" when cell "A13" modifyed. This in a sheet called "T".
Can this be done?
Thanks for the support.
-1
votes
1answer
41 views
Google Sheets - If? ISBLANK? Not sure how to pull this one off
I am trying to find a formula for the following:
If cell A1 has a date in it, copy that date to cell F1. If A1 does not have a date in it, copy the date from cell B1 into cell F1.
I have a receipt ...
0
votes
1answer
31 views
Google sheets show open or closed at the moment
There is a client’s working time, it is necessary to display the client is currently open or closed. Is it possible?
1
vote
1answer
20 views
I have the formula I want to use but now sure how to change it with time another time zone
I have a formula setup that I want to use. But I have a separate sheet that I want to use in a different time zone. The one I have written is in EST. but I want another sheet to use the same formula ...
2
votes
1answer
498 views
Adding missing dates to Google Sheets
I'm pulling data from HubSpot to Google Sheets via 3rd party connector. I have a raw data set on Sheet 1 and then I'm pulling certain data from Sheet 1 to other Sheets with QUERY function.
For ...
0
votes
1answer
106 views
How to give a column a green border if the second row's holds a date = TODAY()?
I'm trying to make a useful schedule sheet to keep track of all of my class assignments:
I want to write a script in the script editor that says,
for(Column A-Z){
if(A2,B2,etc = TODAY()){
...
2
votes
1answer
369 views
How to sum amount with a criteria separately by day in Google Sheets?
I am using Google Sheets to track income and expenses. I have a separate file for each month and a master file to summarize each month.
The file for monthly account contains a couple of sheets - each ...
0
votes
1answer
202 views
Help needed with script that auto-updates cells in column in Google Spreadsheet showing last modify date
I'm looking for some help with a script for a spreadsheet.
I found a script (see below) that does half the trick for me, but I encounter two difficulties.
What I am trying to accomplish is the ...
1
vote
1answer
1k 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
126 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
369 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 ...
1
vote
1answer
1k 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
278 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
87 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 ...
1
vote
1answer
53 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 ...
2
votes
3answers
3k 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, ...
2
votes
1answer
104 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
73 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
454 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
78 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
210 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
325 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 ...
5
votes
3answers
17k 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] ...
1
vote
1answer
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 ...
0
votes
1answer
233 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
48 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
90 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 ...
1
vote
2answers
68 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
75 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
120 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
202 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
132 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
108 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
121 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('...
