I am trying to get a row of data to move from one sheet to another based of the information in a column. I have researched and tried to fix this but its still not working. Trying to get row moved from sheet "Pending" to sheet "Confirmed" once an x is placed in column 10 or J. It won't work and I'm going crazy
function onEdit(event) {
// assumes source data in sheet named Pending
// target sheet of move to named Confirmed
// test column with yes/no is col 10 or J
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = event.source.getActiveSheet();
var r = event.source.getActiveRange();
if(s.getName() == "Pending" && r.getColumn() == 10 && r.getValue() == "x") {
var row = r.getRow();
var numColumns = s.getLastColumn();
var targetSheet = ss.getSheetByName("Confirmed");
var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
s.getRange(rowIndex, 1, 1, colNumber).copyTo(target);
s.deleteRow(rowIndex);
}
}
function onEdit(event) {
// assumes source data in sheet named Pending
// target sheet of move to named Confirmed
// test column with yes/no is col 10 or J
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = event.source.getActiveSheet();
var r = event.source.getActiveRange();
if(s.getName() == "Pending" && r.getColumn() == 10 && r.getValue() == "x") {
var row = r.getRow();
var numColumns = s.getLastColumn();
var targetSheet = ss.getSheetByName("Confirmed");
var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
s.getRange(rowIndex, 1, 1, colNumber).copyTo(target);
s.deleteRow(rowIndex);
}
}