从mongodb shell安全写入(Safe write from the mongodb shell)

 您需要更改if语句。 它应该是“===”而不是“==”。 这背后有一个很好的解释。 
 
 这是您可以使用的最终脚本 
 
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);
      }
}
 
 更新如果不手动编辑单元格，则无法在第二个电子表格上运行脚本。 一旦在第二个电子表格中从第一个电子表格推送该行，它将不会在第二个电子表格中触发onEdit函数。 您可以做的是将其设置为从第一个电子表格中将行分配到正确的表格，如下所示 
 
 //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);

    }

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

    }