It was really in response to a question. Sadly, these videos don't have the same interest or views as others, but I know it's a useful trick to get those trackers working and looking great!
Is there a way to send the onEdit to a specific Column/Row? For instance I would like to have it always update on Column H as I may update info on Column B through G. While the Offset I can make work, it's not optimal for my current project.
1. If a cell contains a formula and the feeding cells to that formula change, then the cell auto-updates. why doesn't this code capture that? is there a way to tweak the code so it does? 2. I would like to have the time stamp of whenever anything in that entire sheet was updated into one single cell - not individual cell updates. (i am maintaining stock of a service centre in a sheet and want to know the last date of stock update, not particularly interested in which individual cells were updated) how do i do that?
If you just need to check when a specific cell in a spreadsheet was last edited you can just right click the cell and select history and it will tell you all the edits and time of that cell.
Revision history is helpful, and what makes it all work. But this is a way of having these updates visually there as part of the file rather than manually checking :-)
Also, what if I want to check all the cells of a row to see if any of them were updated, and have that last modified date land in the same column every time?
assuming my "last Edit" is on Column I, I changed the last row in the code to: rangeModified.offset(0,(9-rangeModified.getColumn())).setValue(new Date)
![NLE Choppa - Or What ft. 41 (Orchestra Mix) [Official Music Video]](http://i.ytimg.com/vi/biOFASEgSOM/mqdefault.jpg)
Love how you are getting into app scripts!
It was really in response to a question. Sadly, these videos don't have the same interest or views as others, but I know it's a useful trick to get those trackers working and looking great!
Is there a way to send the onEdit to a specific Column/Row?
For instance I would like to have it always update on Column H as I may update info on Column B through G. While the Offset I can make work, it's not optimal for my current project.
1. If a cell contains a formula and the feeding cells to that formula change, then the cell auto-updates. why doesn't this code capture that? is there a way to tweak the code so it does?
2. I would like to have the time stamp of whenever anything in that entire sheet was updated into one single cell - not individual cell updates. (i am maintaining stock of a service centre in a sheet and want to know the last date of stock update, not particularly interested in which individual cells were updated) how do i do that?
type =now() into a cell
can we make it into a stopwatch stye so I can have an if function that tells the cell to turn N/A every 2 months
If you just need to check when a specific cell in a spreadsheet was last edited you can just right click the cell and select history and it will tell you all the edits and time of that cell.
Revision history is helpful, and what makes it all work. But this is a way of having these updates visually there as part of the file rather than manually checking :-)
Also, what if I want to check all the cells of a row to see if any of them were updated, and have that last modified date land in the same column every time?
assuming my "last Edit" is on Column I, I changed the last row in the code to:
rangeModified.offset(0,(9-rangeModified.getColumn())).setValue(new Date)
Are you able to also add a column next to the Last Edit, with the User who performed that last edit? Say it's a shared Google Sheet.