Move Rows with 2 Sheets

This is moving rows between sets of sheets. Here I used "New Red" to "Complete Red" and "New Blue" to "Complete Blue." Important Note: • For a larger set of sheets, whether that be more elements in the set or more nodes on a path, I would use an array approach, rather than just the strict IF() statement. This approach is commented out on the script. Connect with me: • [email protected] • spencerfarris.me • www.linkedin.com/in/spencer-farris/ • Twitter @FarrisSpencer • Google Product Expert support.google.com/docs/profile/12305 Sheet (to copy): https://docs.google.com/spreadsheets/d/1o0SeSWaDnvK9h1Oscgk-NJgM5wXl3qxlUx59q7Nkx5U/edit#gid=0 Script: function onEdit(e) { if (e.value != "Complete") return; const sh = SpreadsheetApp.getActive(); const ss = sh.getActiveSheet(); var dest; // const inSheets = ["New Red","New Blue", "New Green"]; // const outSheets = ["Complete Red", "Completed Blue", "Complete Green"]; // dest = outSheets[inSheets.indexOf(ss.getName())]; if (ss.getName() == "New Red") { dest = sh.getSheetByName("Complete Red"); } else if (ss.getName() == "New Blue") { dest = sh.getSheetByName("Complete Blue"); } else return; ss.getRange(e.range.rowStart, 1, 1, 4).copyTo(dest.getRange(dest.getLastRow() + 1, 1, 1, 4)); ss.deleteRow(e.range.rowStart); }