Questions tagged [google-sheets-timestamp]
Use for question about inserting a date, time or a date and time (timestamp) automatically into a Google spreadsheet.
120
questions
0
votes
1
answer
22
views
How to create a linked sheet that checks a box for a day if found and inserts text from another column
I'm trying to create a sheet in Google Sheets for my team that shows me what runners have run on what day of the week. Their activities are automatically imported via Zapier with dates from Strava ...
- 1
0
votes
1
answer
35
views
How do I put the if function inside the lookup? - Daily Routine sheet
I have a sheet - daily routine which has two columns: activity and time as shown here
Activity
Time
Sleep 😴
6:00 am
Toilet 🚽
6:15 am
Get ready for gym 🤸♂️
6:30 am
Exercise 💪
7:50 am
... ...
- 101
0
votes
0
answers
33
views
Please help me create a "stopper" for this timer that I made in Google Sheets
After much research and finding and utilizing solutions I've found for creating a long term "stopwatch timer" in Google Sheets, I've done it. It works the way I want it to and it displays ...
- 1
0
votes
0
answers
18
views
Running a script on select tabs in Google Sheets [duplicate]
I am not a coder, but I can normally do enough trial and error to get my script to function in the way I want my google sheet to work.
The goal of my script:
I want cell A to time stamp anytime that ...
- 1
0
votes
0
answers
8
views
Date of today when an item is sold [duplicate]
Got a question regarding dates. At the moment i have 2 columns: Order date & sale date.
I just fill in order date whenever I order something and then the sale date is: =IF(N66="";;TODAY()...
0
votes
0
answers
34
views
How to draw multiple time series lines in google sheets?
I want to draw sequences of two different configurations over time. I have the data in a table like that.
serial
mode2
mode 3
1
0.079
2
0.088
3
0.094
4
0.095
5
0.095
6
0.096
7
0.096
1
0.076
...
- 101
0
votes
0
answers
24
views
How can I make current Data and time show up in cell a1 and c1 respectively when I type a text in cell b1?
I am using sheets and I want my cell to auto-populate with the date today in one cell and the time now to populate in another, so this is what I've tried doing.
I added the forumla in column C to show ...
- 1
0
votes
1
answer
50
views
Google sheets formula to calculate hours elapsed between two datetime stamps & exclude weekends
What is the best formula to calculate the hh:mm:ss lapsed between end datetime and start datetime and also exclude weekends? I know I can simply subtract end and start datetime ( End Datetime - Start ...
0
votes
0
answers
31
views
Timestamp on change google sheets 3rd party data entry
i have been looking for a way to timestamp my google sheet,
its working if i edit the cell and it work great exactly how i want it, however.
im not the on editing the sheet, its through a 3rd party ...
- 1
0
votes
1
answer
63
views
Input timestamp into last cell
I work on a script to input timestamp in the lastcell when all previus cells are modified. The following is not working.
function timestamp() {
var archivo =SpreadsheetApp.getActiveSpreadsheet();
...
- 3
0
votes
2
answers
508
views
Conditional Formatting for cells that are within 1 hour of the date and time posted within a cell
I have a Auction that I am updating and posting bids to on a Google Sheet that bidders can view.
The condition to the auction is that the item will be sold to a bidder if no one has bid on said item ...
0
votes
1
answer
288
views
How can I use the onEdit() trigger to timestamp a cell if another cell in the same row is checked "TRUE" in apps script?
I am able to add a timestamp in column 5 using a conditional when I'm comparing the column to a number, but what I am actually trying to do is add a stamp to the corresponding cell in column 5 if a ...
0
votes
1
answer
331
views
Multiple timestamps in multiple columns on multiple Google Sheet tabs
I am trying to work out what script is required to have multiple timestamps on several tabs however each one I have tried doesn't work for me. I am new to this.
When text is added to column 2 I need ...
- 1
0
votes
1
answer
125
views
Adding Multiple timestamps, One with Checkbox
I am looking to add a second timestamp, connected to a checkbox. I currently have it set to put a timestamp in Column D when B is filled in. I would also like a timestamp in Column O when Column A ...
1
vote
1
answer
63
views
Google Sheets - COUNTIFS with timestamp
I have a column in a table that contains the date and time. This is the form
15.06.2020 09:43:24
17.06.2020 08:21:04
18.06.2020 12:11:34
or also
2021-01-21 11:57:34
2021-01-21 11:58:02
2021-01-21 11:...
- 13
0
votes
1
answer
292
views
Is there a way to prevent spreadsheet from updating the date to today's date in formula? [duplicate]
I'm trying to print the date when I change the value on a cell (status column). But spreadsheets update the date to today's date. I wish it could save the date from when the status was changed.
The ...
- 1
0
votes
0
answers
72
views
Script For Google Sheet With Changing Names
We have a Google Sheet and the names of the Sheets will change based on the date. So, we will have a string of
Mon 2.15
Tue 2.16
Wed 2.17
Etc...
The sheets are copied and then a new name given to ...
- 1
1
vote
0
answers
65
views
How do I have a date stamp entered when a cell is changed?
I want to autofill the date of an edit in one cell into the next cell. Specifically:
When I enter something into any cell in column 2, I want the cell next to it in column 3 to autofill the date.
I ...
- 11
0
votes
0
answers
51
views
How to solve situation where I need timestamp script to work on cell auto entry, not manual
Can someone help me with this problem.
I have timestamp script running in google sheet and it work fine when I manually change value in cell. But I can't find any solution how to have timestamp ...
- 1
0
votes
1
answer
343
views
Is there a way to add a new sheet tab to a Google Sheet based on the timestamp date?
Students take a weekly survey on Google Forms, and it is transferred to a Google Sheet. I want the Google Sheet to automatically generate a new tab based on the date (timestamp) so that each week has ...
- 1
2
votes
1
answer
72
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 ...
- 21
0
votes
1
answer
14
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.
- 11
2
votes
2
answers
365
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/...
- 23
0
votes
1
answer
106
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
1
vote
1
answer
2k
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 ...
- 113
1
vote
0
answers
19
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 ...
- 11
0
votes
1
answer
164
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 ?
2
votes
1
answer
94
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 ...
- 43
2
votes
1
answer
81
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/...
- 23
1
vote
0
answers
242
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....
- 11
-1
votes
1
answer
49
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
1
answer
83
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
1
answer
22
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 ...
- 11
2
votes
1
answer
2k
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 ...
- 21
0
votes
1
answer
170
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
1
answer
2k
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 ...
- 21
0
votes
1
answer
579
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
1
vote
1
answer
2k
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
1
answer
320
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?
...
- 1
0
votes
1
answer
507
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 ...
- 103
1
vote
1
answer
3k
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 ...
- 11
-1
votes
1
answer
489
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
1
answer
110
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 ...
- 13
2
votes
1
answer
65
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 ...
- 39
2
votes
3
answers
11k
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
2
answers
376
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 ...
- 23
1
vote
1
answer
129
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 ...
- 25
0
votes
1
answer
531
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 ...
- 3
0
votes
1
answer
241
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)... ...
- 75
1
vote
2
answers
314
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 ...
- 75