основной метод onEdit
var SHEET_NAME = 'Referees';
var COLS = [5, 7, 11, 14];
function onEdit(e){
onedit(e);
}
function onedit(e){
try{
var cols = COLS;
if (e.range.getSheet().getName() !== SHEET_NAME)
return;
if (cols.indexOf(e.range.columnStart) > -1) {
e.range.getSheet().getRange(e.range.rowStart, 15, 1, 1)
.setValue(new Date());
}
}catch(err){
SpreadsheetApp.getActiveSpreadsheet()
.toast(Utilities.formatString('%s\n%s', err.message, err.stack), '', 5000);
}
}