Automatic timestamp update upon edit-CodePudding

so I have a spreadsheet with multiple Gollum's when any collum gets update I need it to update the timestamp on colum 5 which is our timestamp column https://docs.google.com/spreadsheets/d/1zOKwPL0LMtWpcbhji6XDi-8Sx3-WfxRXnboZ_Le0wZo/edit?usp=sharing

but I can't for the life figure out why it won't work

CodePudding user response：

try this answer from stackexchange

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);
   };
 };
}

You can try adding a Google Apps Script to capture when a cell is edited and add a timestamp to a different cell

CodePudding user response：

Please Follow This You'll Get The Multiple Ways To Resolve This How To Insert Timestamp in Google SpreadSheets