This is what I use to allow Google Sheets to auto-populate the date/time in column "N" whenever any cell in that row is updated.
function onEdit() {
var s = SpreadsheetApp.getActiveSheet();
var r = s.getActiveCell();
if( r.getColumn() != 8 ) { //checks the column
var row = r.getRow();
var time = new Date();
time = Utilities.formatDate(time, "GMT-04:00", "MMM/dd/yy, hh:mm:ss");
SpreadsheetApp.getActiveSheet().getRange('N' + row.toString()).setValue(time);
};
}
I want to be able to auto populate the Google user/name who made an any changes when a cell in that row is updated.
Is this possible?