I have a sheet that has information in 8 columns starting in row 14. I would like I14:I310 to date stamp anytime there is an update in the corresponding row. I have tried a couple of different ways and haven't found anything to be successful as of yet. Ideas?

  • add this script to your sheet and change format and time zone if you need so
    ("GMT+1", "dd.MM.yyyy"):

function onEdit(event)
    { var sheet = event.source.getActiveSheet();
      // note: actRng = the cell being updated
      var actRng = event.source.getActiveRange();
      var index = actRng.getRowIndex();
      var cindex = actRng.getColumnIndex();
      var dateCol = sheet.getLastColumn(); 
      var lastCell = sheet.getRange(index,dateCol);
      var date = Utilities.formatDate(new Date(), "GMT+1", "dd.MM.yyyy");

demo spreadsheet

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.