I have a script to move a row to my 2nd sheet based on a checkbox.
It does move to the sheet intended, however, on the first sheet the row is not being deleted, and the thick box changes to unthick, I am not sure where my script is wrong, I’m new to code, thanks.
function onEdit() {
var mainSheet = “Observations Data”;
var sheetToMoveTheRow = “Failed Observations Follow Up”;
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = SpreadsheetApp.getActiveSheet();
var range = SpreadsheetApp.getActiveRange();if(sheet.getName() == “Observations Data” && range.getColumn() == 26 && range.getValue() == true) {
var row = range.getRow();
var numColumns = sheet.getLastColumn();
var targetSheet = ss.getSheetByName(“Failed Observations Follow Up”);
var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
sheet.getRange(row, 1, 1, numColumns).moveTo(target);
sheet.deleteRow(row);
else if(sheet.getName() == “Failed Observations Follow Up” && range.getColumn() == 26 && range.getValue() == false) {
var row = range.getRow();
var numColumns = sheet.getLastColumn();
var targetSheet = ss.getSheetByName(“Observations Data”);
var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
sheet.getRange(row, 1, 1, numColumns).moveTo(target);
sheet.deleteRow(row);
}
}
Liliana Perez-Roberts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.