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
0
votes
1answer
211 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
133 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
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
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
130 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('...
2
votes
1answer
118 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
2k 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
1k 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
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.
0
votes
0answers
102 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
3k 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: ...
1
vote
1answer
780 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 ...
5
votes
1answer
14k views

Show a time-stamp in one cell when another cell is updated in Google Sheets [duplicate]

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 ...
1
vote
1answer
1k 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 ...
3
votes
1answer
12k views

Dating When a Cell is Edited in Google Sheets

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. ...
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
2k 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
126 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
867 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
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 ...
1
vote
1answer
16k 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 (...
4
votes
1answer
2k 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
4k 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(); ...
2
votes
1answer
6k 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?
-1
votes
1answer
2k 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
2answers
11k 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
2k 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
226 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 ...
2
votes
2answers
3k views

How to add current date to cell if the rest of the cells (or some cells) in that row are edited, but only the first time?

I have a column A4:A (heading = Date), and other columns after it B4:O. I want column A to fill in today's date automatically when I fill in any other columns (some of these B4:O maybe empty, but ...
-1
votes
1answer
5k 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
1k 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
113 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 ...
5
votes
1answer
6k 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
347 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
640 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
1k 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
794 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
1k 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
776 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 ...
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 ...
2
votes
1answer
2k views

Add timestamp to two different columns in Google Spreadsheets

Need help in adding another function using the below script. I would like to have a timestamp "start" and "end" on two different columns, whenever the other two separate columns are edited. Based on ...
8
votes
2answers
44k views

How to show “Last edited” date and user on Google Sheets?

I've got a Google sheet that is updated quite regularly by a few people. I'd like to be able to view the doc, and at a glance—have a cell that shows a date (last modified) and another cell (user that ...
13
votes
7answers
44k views

How to stop NOW function from auto-updating?

I'm using Google Spreadsheet's NOW() function as a shortcut to insert the current timestamp now. However, the value in the cell changes whenever the spreadsheet is modified in any way, even when the ...
3
votes
1answer
661 views

Script to only show timestamp when a specific column is changed?

I want to take an existing script from a Google Spreadsheets and change it so it only updates the last column when I make a change to a specific column in the last row. I can't get it to only key off ...
0
votes
1answer
300 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 = ...
1
vote
1answer
1k views

Limiting range in OnEdit timestamp script

I would like to be able to limit the range of cells being assessed by this script to the first column. Apply the timestamp to the last column and only have the script run on a specific sheet "Short ...
5
votes
2answers
14k views

Add a 'creation date' value when a new line is edited

I have a Google Spreadsheets that is used by different people to add tasks for my team. Here's an example. People can add tasks to column B and I will assign them to the right people in the team, ...
2
votes
1answer
1k views

Create new Google Spreadsheets with timestamp

I'm trying to create a new spreadsheet once we select the specific function from the custom menu item that's selected. I want the new spreadsheet to be "Sheet" and "Timestamp". I have this created ...
34
votes
9answers
115k views

How to insert the current date into a Google Spreadsheet?

I've got a spreadsheet in Google Drive and one column is meant for the date the entry is made. Is there a button to do this? I'm aware of the functions =NOW() and =TODAY() but their description says "...
3
votes
1answer
3k views

Why would this Google Spreadsheets onEdit script be so slow (2 secs to change cells, 3 secs to update)

I've put together a script for a spreadsheet based on what I have seen here and other sources that should provide a simple username and timestamp function. I have another spreadsheet that uses a very ...