Good day! I have two scripts

The first under the written function

function onEdit(event) { SmartDataValidation(event); }

The second substitution of the date of change:

 function onEdit(event) { var sheetName = event.source.getActiveSheet().getSheetName(); var sheet = event.source.getActiveSheet(); var idCol = event.range.getColumn(); var idRow = event.range.getRow(); if (idCol === 13 && sheetName === 'Заказы'){ sheet.getRange(idRow, idCol +8).setValue(new Date().toString()); } };

But they do not work together, overlap. How to make both scripts work?

  • It was solved simply function onEdit (event) {SmartDataValidation (event); var sheetName = event.source.getActiveSheet (). getSheetName (); var sheet = event.source.getActiveSheet (); var idCol = event.range.getColumn (); var idRow = event.range.getRow (); if (idCol === 13 && sheetName === 'Orders') {sheet.getRange (idRow, idCol +8) .setValue (new Date (). toString ()); }} - Marinka Teslenko

0