Linked Questions

-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 "...
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
49 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 ...
0
votes
0answers
46 views

Auto update date in google sheets based on edit in range of cells [duplicate]

I want to update a timestamp based on the last time any cell in a range is updated. I added this script: function getDate() { return new Date(); } In a cell I use the formula: =getDate(D5:AF5) ...
6
votes
3answers
23k views

Auto date insert when opposite cell is populated

I am creating a spreadsheet which will contain records of my daily expenditure. Something like the following: A | B ---------- 0 | 50.04 0 | 20.00 0 | 19.99 0 | 2.40 What I am trying to achieve ...
5
votes
1answer
35k views

Google Spreadsheet Timestamp? [duplicate]

I'm looking for some help with my Daily Work Log spreadsheet. I've search and read many different version of making a "TimeStamp" in Google spreadsheet. And it seems I don't have enough experience for ...
3
votes
1answer
11k 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. ...
0
votes
1answer
4k views

“Last Modified” function

I have a problem in using Google Sheets. My sheet is shared with others so I want to add a "Last Modified" function in each row, so I can know when it was last modified. I've searched Google for a ...
2
votes
1answer
1k views

A spreadsheet column with the last modified date of files in a Google Drive folder

I am creating a spreadsheet with a list of procedures and instructions that are currently scattered in a shared Google Drive folder. I am planning to make a column that would show the last modified ...
0
votes
1answer
432 views

Auto-updating column in Google Spreadsheet in a specific sheet

I'm using a function that I found on another thread here on stackexchange, but I would like to limit the function to only work in 1 specific sheet at the time. I have old sheets with history that is ...
0
votes
1answer
227 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:...