google sheets
When I see that somebody has changed a document I am working on in Google Drive, I normally want to see where exactly the change happened. Using File > See Revision History… is not really helpful when the document is large or I have multiple sheets in a spreadsheet.
Isn't there some function that allows me to jump to the change in the document, so I can immediately follow what happened?
You can try adding a Google Apps Script to capture when a cell is edited and add a timestamp to a different cell. Here's a previous answer that is similar: Google Spreadsheet Timestamp?
function onEdit() {
var s = SpreadsheetApp.getActiveSheet();
if( s.getName() == "Sheet1" ) { //checks that we're on the correct sheet
var r = s.getActiveCell();
if( r.getColumn() == 13 ) { //checks the column
var nextCell = r.offset(0, 1);
if( nextCell.getValue() === '' ) //is empty?
var time = new Date();
time = Utilities.formatDate(time, "GMT", "HH:mm:ss");
nextCell.setValue(time);
};
};
}
It shows data in advanced edit mode, and in View mode:
Best Answer
Unfortunately the history revision in Google Docs Editors, don't include a jump to the tracked changes, just a color highlighting and strikethrough for deletions.
By the other hand, recently was launched a "suggestion mode". It inserts a comment automatically. They could be navigated through the comments panel.
An alternative could be use Google Apps Script to insert a comment or note on changes.
References
See the history of changes made to a file - Docs Editors Help
Suggest edits in a document - Docs Help Editor