Can I move a row that is updated from another sheet?

Question

I have 2 different sheets, the first is where all my data is stored and changes. On updating the first sheet it moves to the second sheet. I am trying to figure out if after the update, I can move a row from the second sheet to another tab in the second sheet based off of the data in column Q or col 17. Here is what I currently have, but it does not seem to be moving anything. Is this even possible?

function onUpdate() {

  var sheetNameToWatch = "Raw Data";
  var columnNumberToWatch = 17; // column A = 1, B = 2, etc.
  var valueToWatch = ["Full", "Partial", "Process", "Conditional", "Fail", "Exemption"];
  var sheetNameToMoveTheRowTo = (valueToWatch + " Certification");;

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getActiveCell();

  if (sheet.getName() == sheetNameToWatch && range.getColumn() == columnNumberToWatch && range.getValue() == valueToWatch) {
    var targetSheet = ss.getSheetByName(sheetNameToMoveTheRowTo);
    var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    sheet.getRange(range.getRow(), 1, 1, sheet.getLastColumn()).moveTo(targetRange);
    sheet.deleteRow(range.getRow());
  }
}

Thanks.

Ok, I've updated the current script:

function onUpdate() {
  var sourceSheet = "Raw Data";
  var columnNumberToWatch = 17; // column A = 1, B = 2, etc.
  var valueToWatch = ["Full", "Partial", "Process", "Conditional", "Fail", "Exemption"];
  var sheetNameToMoveTheRowTo = (valueToWatch + " Certification");

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getActiveCell();

  if (sheet.getName() === sourceSheet && range.getColumn() === columnNumberToWatch && checkMatch(range.getValue(), valueToWatch) === true) {
    var targetSheet = ss.getSheetByName(sheetNameToMoveTheRowTo);
    var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    sheet.getRange(range.getRow(), 1, 1, sheet.getLastColumn()).moveTo(targetRange);
    sheet.deleteRow(range.getRow());
      }
}

function checkMatch(value, array) {
  for (i in array) {
    if (value === array[i]) {
      return(true);
    }
  }
}

Alright,

I tried to specify a little more with it:

function onEdit() {
  var sourceSheet = "Raw Data";
  var columnNumberToWatch = 17; // column A = 1, B = 2, etc.
  var valueToWatch = ["Full", "Partial", "Process", "Conditional", "Fail", "Exemption"];
  var sheetNameToMoveTheRowTo = (valueToWatch + " Certification");

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getActiveCell();
  var cert = range.getValue();

  if (valueToWatch.indexOf(cert) === sourceSheet && range.getColumn() === columnNumberToWatch && checkMatch(range.getValue(), valueToWatch) === true) {
    var sheetNameToMoveTheRowTo = (cert + " Certification");
    var targetSheet = ss.getSheetByName(sheetNameToMoveTheRowTo);
    var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    sheet.getRange(range.getRow(), 1, 1, sheet.getLastColumn()).moveTo(targetRange);
    sheet.deleteRow(range.getRow());
      }
}

function checkMatch(value, array) {
  for (i in array) {
    if (value === array[i]) {
      return(true);
    }
  }
}

by defining cert and trying to define more clearly the array for valueToWatch.

Answer 1

You need to change your if statement. It should be "===" instead of "==". Here is a good explanation behind this.

Here is the final script that you can use

function onEdit(e) {
  var sourceSheet = "Raw Data";
  var columnNumberToWatch = 17; // column A = 1, B = 2, etc.
  var valueToWatch = ["Full", "Partial", "Process", "Conditional", "Fail", "Exemption"];
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var range = e.range;
  var activesheet = range.getSheet();
  var activesheetname = activesheet.getName();
  var row = range.getRow();
  var value = ss.getSheetByName(sourceSheet).getRange(row, columnNumberToWatch).getValue();

  if (activesheetname === sourceSheet && valueToWatch.indexOf(value) >=0) {
    var targetSheet = ss.getSheetByName(value + " Certification");
    var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    activesheet.getRange(row, 1, 1, activesheet.getLastColumn()).moveTo(targetRange);
    activesheet.deleteRow(row);
      }
}

Update You cannot make a script run on the second spreadsheet without manually editing a cell. Once the row gets pushed from first spreadsheet in two second, it will not trigger the onEdit function in the second spreadsheet. What you could do is set it to allocate the row to correct sheet from the first spreadsheet with something like this

 //This is part of a script on the first spreadsheet   
 if (valueToWatch.indexOf(value) >=0) {
        var targetSheetName = value + " Certification";
      } else {
        var targetSheetName = "Raw Data";
      }
        var targetSheet = SpreadsheetApp.openById("1bjLKWXUwM6UE4SHz2pbhH3F1E-8GKtvV0870YetOpKo").getSheetByName(targetSheetName);
        var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1,1,activesheet.getLastColumn());
        targetRange.setValues(activesheet.getRange(row, 1, 1, activesheet.getLastColumn()).getValues());
        activesheet.deleteRow(row);

    }