Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [google-sheets-timestamp]

Use for question about inserting a date, time or a date and time (timestamp) automatically into a Google spreadsheet.

Filter by
Sorted by
Tagged with
1 vote
0 answers
36 views

Google Sheets Arrayformula for timestamps of checkboxes changed

I am looking for LAMBDA-based formula for hundreds of rows which will add timestamp based on checkbox changed for that particular row. Need it to be ARRAYFORMULA/BYROW, as number of rows grows ...
wass rubleff's user avatar
1 vote
1 answer
312 views

Track elapsed hours in Google Sheet

I have a table in Google Sheets that I use to track the time elapsed between a TIME IN and a TIME OUT. As you can see below, my TOTAL formula in D3 works, calculating the elapsed time from 5 AM to 3 ...
ZenLife18's user avatar
1 vote
0 answers
12 views

Need Help with Timestamp Function

As entered, every time I check ANY box, ALL timestamps update. I'd like only the corresponding cell to provide a current timestamp. All others to remain as previously stamped. https://docs.google.com/...
Jay B's user avatar
  • 11
1 vote
1 answer
80 views

Timestamp on change of another range

I have a Planning sheet that I use to follow budgets that are reported every week. I'd like to have K7:18 stamped with a date when there is a change in the corresponding cell of I7:I18 range. I cannot ...
user318609's user avatar
0 votes
1 answer
142 views

Google Sheets Date/Time Stamp

I have a Google Sheet with a dropdown menu in column U.I would like column V to timestamp when column U is changed. I've used the following code however this only timestamps the first time that column ...
Martin Kings's user avatar
2 votes
2 answers
83 views

How to automatically add 00 minutes to hours in Google Sheets?

We have cells that store time in the H:MM format (24-hour time without a leading zero for hours). However, I don't like typing values such "8:00". Ideally, I'd like to type just a single ...
Johnnyjanko's user avatar
-1 votes
1 answer
95 views

How do I use formulas to find the midpoint and other milestones between two dates?

I am trying to make a Google Sheets document for work that will contain the date someone signed, the date that the wedding is occurring, when the first and second payments are due, and when to send ...
logan james's user avatar
0 votes
1 answer
22 views

Can I convert abbreviated duration info to timestamp info in Google Spreadsheets?

I have the following duration input in Google Spreadsheets and I'd like to get an average of all the inputs. But I couldn't find any way to do it. Does anybody know if it's possible? The input is: 1d ...
cwtl372's user avatar
0 votes
1 answer
761 views

ARRAYFORMULA - Return of Text if cell is not blank and DATE earlier than TODAY

After some unsuccessfull workings hours, I definitely need your support. I am trying to create an ARRAYFORMULA, so that new rows can be added manually with the wished formulas already implemented in ...
Pierre's user avatar
  • 1
0 votes
2 answers
270 views

How to calculate the remaining working days in a month

I have =INT(B8-NOW())currently running in a cell to show me the remaining days in the month (B8 being a date) I want to know if there is a way that the output number can calculate only working days, ...
Joshua Rolloos's user avatar
1 vote
1 answer
119 views

Google sheets - Conditional formating between 2 dates in function of real time

Is it possible to make a cell automatically highlighted during a time interval relative to the instant T, in real time. The cell should only be highlighted when the time comes and it becomes ...
Bazu's user avatar
  • 53
1 vote
1 answer
43 views

is Google sheet too basic?

Basically earlier I wanted to extract time from a full "date time" record, and after googling it I literally found nothing you can check for yourself, I found a split option and another ...
Ahmed Ben Ammar's user avatar
1 vote
1 answer
208 views

Time stamping in multiple cells (making them freeze) base on one cell value

I'm trying to modify my spreadsheet. Below is my original spreadsheet with the formula I used. Which works great for what I needed. But my boss is wanting time stamps for 3 different actions from ...
Brenda's user avatar
  • 11
0 votes
0 answers
127 views

Google Sheets, SumIf date in cell matches another date

I have two sheets one with date/times, and names in columns that gets populated automatically from a form submission, and a second one that has dates only across the columns with names down the rows. ...
Keegan Miller's user avatar
-1 votes
1 answer
31 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 ...
Brendan's user avatar
0 votes
1 answer
37 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 ... ...
Arun's user avatar
  • 101
0 votes
0 answers
30 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 ...
PhilHand's user avatar
1 vote
1 answer
747 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 ...
GoogleNovice's user avatar
0 votes
1 answer
84 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(); ...
Jeff's user avatar
  • 3
0 votes
2 answers
2k 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 ...
Akito Tennouji's user avatar
0 votes
1 answer
653 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 ...
NeophyteLou's user avatar
1 vote
1 answer
641 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 ...
Sophie's user avatar
  • 11
0 votes
1 answer
335 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 ...
user271449's user avatar
1 vote
1 answer
388 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:...
Marcel's user avatar
  • 13
0 votes
1 answer
770 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 ...
Seyfertt's user avatar
0 votes
0 answers
141 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 ...
Joe's user avatar
  • 1
1 vote
0 answers
92 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 ...
Mr Olivas's user avatar
0 votes
0 answers
73 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 ...
Marko's user avatar
  • 1
0 votes
1 answer
754 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 ...
Ariana's user avatar
  • 1
2 votes
1 answer
104 views

Removing Last Updated value when No data was selected from the column to check

I need help with my Google Sheet script. It is working fine when showing the timestamp of "Last Updated" at col B every time a new Call Status was set at col A; but when I delete the status ...
graceR's user avatar
  • 21
0 votes
1 answer
16 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.
Jody Heath's user avatar
2 votes
2 answers
743 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/...
Purevibe's user avatar
2 votes
1 answer
164 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() == &...
Alan's user avatar
  • 21
1 vote
1 answer
3k 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 ...
Simona's user avatar
  • 113
1 vote
0 answers
45 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 ...
Han's user avatar
  • 11
1 vote
1 answer
814 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 ?
Paresh Paresh's user avatar
2 votes
1 answer
114 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 ...
Nomadik's user avatar
  • 43
2 votes
1 answer
162 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/...
Stan's user avatar
  • 23
1 vote
0 answers
308 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....
BBRODIN's user avatar
  • 11
-1 votes
1 answer
53 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 ...
Tyler Smith's user avatar
0 votes
1 answer
178 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?
Vladimir Melnikov's user avatar
1 vote
1 answer
28 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 ...
user231775's user avatar
3 votes
1 answer
3k 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 ...
Mike's user avatar
  • 31
2 votes
1 answer
3k 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 ...
Pat's user avatar
  • 21
0 votes
0 answers
642 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 ...
Ralph's user avatar
  • 9
1 vote
1 answer
3k 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-...
Steven Lipton's user avatar
0 votes
1 answer
392 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? ...
Fred S's user avatar
  • 9
0 votes
1 answer
538 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 ...
Majid's user avatar
  • 105
1 vote
1 answer
4k 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 ...
Fred's user avatar
  • 11
-1 votes
1 answer
569 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,-...
OS Imagtor's user avatar