Google Apps Script

.en.md

Move a row

• Move row of data to a new sheet depending on yes/no answer
• How to video

Code.gs

function onEdit() {
  // moves a row from any sheet to an archive sheet when a magic value is entered in a column
  
  var columnNumberToWatch = /* column Q */ 3; // column A = 1, B = 2, etc.
  
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var as = SpreadsheetApp.getActiveSheet();
  var cell = as.getActiveCell();
  var track_val = cell.getValue().toUpperCase(); // If the names of sheets needed exactly skip .toUpperCase()
  
  if (as.getName() !== track_val && cell.getColumn() == columnNumberToWatch) {
    
    var targetSheet = ss.getSheetByName(track_val);
    if(!targetSheet) 
    {
      ss.toast(Utilities.formatString('The sheet with the "%s" name is not found', track_val), 'Toast');
      return;
    }
    var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    as.getRange(cell.getRow(), 1, 1, as.getLastColumn()).moveTo(targetRange);
    as.deleteRow(cell.getRow());
    targetRange.activate();
  }
}