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
1answer
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 ...
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 ...
1
vote
1answer
1k 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.
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 ...
1
vote
2answers
5k 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
117 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 ...
1
vote
1answer
796 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 ...
1
vote
1answer
1k views

How do I put the timestamp in the "check in" or "check out" column based on the user's response in the Google form?

I created a Google form that allows users to clock in/out. The form asks two questions: their pin number and whether they want to check in or out. When the user clicks on "check in" and submits, the ...
1
vote
0answers
48 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 ...
1
vote
0answers
15 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 ...
1
vote
0answers
149 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....
1
vote
1answer
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-...
1
vote
1answer
2k 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
vote
1answer
96 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
95 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 ...
1
vote
2answers
282 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 ...
1
vote
1answer
116 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
124 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
vote
1answer
135 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('...
1
vote
1answer
1k views

Script for GoogleSheets that inserts date, time, and user names of everyone entering text in a specified cell?

I wanted to ask for your help in building a script in Google spreadsheet that would allow users to respond to comments left by different users in the same cell (cell where the initial comment was ...
1
vote
1answer
807 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 ...
1
vote
1answer
17k views

Cell last modified date & user stamp Google Sheets?

I want the cells of two columns in my Spreadsheet to auto-update with the date (m/d/y) and name of user when cells in a certain range are edited. For instance, Catherine goes to sheet on 3/6/2017 (...
1
vote
1answer
134 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
8k 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 ...
0
votes
1answer
2k views

Timestamp for columns B & D? [duplicate]

Found this script on one of the questions answered in the forum but I don't know enough to make it work. I would like it to time-stamp date and time in column B when they check in and then a separate ...
0
votes
1answer
13 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.
0
votes
1answer
519 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
1answer
266 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:...
0
votes
1answer
136 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
113 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
308 views

Provide a timestamp when a particular row is edited

I noticed this code from a thread I was reviewing as I needed the same functionality to provide a timestamp when a particular row is edited in a Google Spreadsheet; function onEdit() { var s = ...
0
votes
2answers
78 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
1answer
63 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
1answer
159 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 ...
0
votes
1answer
66 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 ...
0
votes
1answer
57 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 ...
0
votes
0answers
7 views

Need to only display table results in between 5 hours ago and now

I Have a table with data, the first column containing a timestamp. I want to display only rows in that table with times between 5 hours ago and the current time. I've been trying to filter with the ...
0
votes
0answers
39 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 ...
0
votes
0answers
33 views

How to lock a range of cells in Google Sheets after a certain date?

I have this Google Sheet where I track the metrics of the different teams in my office. I have as many as 19 people using the sheet to enter their respective data. But off late I see that people go ...
0
votes
0answers
38 views

Date Modified & Time modified + Date entered & Time entered

I can't read code and previously found this really easy to read article to enter in my date modified timestamp and I messed it up when I was trying to edit it for a second column for date and time ...
0
votes
0answers
44 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 ...
0
votes
1answer
90 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 ...
0
votes
1answer
77 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() == &...
0
votes
1answer
47 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
1answer
57 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?
0
votes
1answer
142 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()){ ...
0
votes
1answer
522 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 ...
0
votes
1answer
260 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
469 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 ...
0
votes
1answer
510 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 ...