Moving rows to another sheet based on a cell value script

Question

Looking to move cells based on a value in google sheets using a script. Super green to all of this, just after watching some videos on the basics & using code found on a site, trying to make this work for my spreadsheet.

function doneCopy() {

 var app = SpreadsheetApp;
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheetNameToWatch = ss.getSheetByName("Current")
 var columnNumberToWatch = 8;
 var valueToWatch = "DONE" ;
 var sheetNameToMoveTheRowTo = "OLD";

 //var ss = SpreadsheetApp.getActiveSpreadsheet();//this has already been declared
 var sheet = SpreadsheetApp.getActiveSheet();
 var range = sheet.getActiveCell();

 if (sheet.getName() == "Current" && range.getColumn() == 8 && range.getValue() == "DONE") {
   var targetSheet = ss.getSheetByName("OLD");
   var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);

   sheet.getRange(range.getRow(), 1, 1, sheet.getLastColumn()).moveTo(targetRange);
   sheet.deleteRow(range.getRow());
 }

}

It appears to not being working at all. Here is a link to the spreadsheet: https://docs.google.com/spreadsheets/d/1iRMuKKhC83lot4TV2dbOfBlgdtVzSuZ0rkoWKyTOUIM/edit?usp=sharing

End Goal: When the "Status" Column is "DONE" the whole row is moved to the "OLD" sheet (adding a row on the bottom) & then deleted from the "Current" sheet

Answer 1

Try this:

SpreadsheetApp.getUi().createMenu('New Menu') {
  .addItem('Run', 'doneCopy')
  .addToUi()
}

function doneCopy() {
 var ss=SpreadsheetApp.getActive();
 var sheet=SpreadsheetApp.getActiveSheet();
 var range=sheet.getActiveCell();
 if (sheet.getName()=="Current" && range.getColumn()==8 && range.getValue()=="DONE") {
   var targetSheet=ss.getSheetByName("OLD");
   var targetRange=targetSheet.getRange(targetSheet.getLastRow() + 1, 1);//column one
   sheet.getRange(range.getRow(), 1, 1, sheet.getLastColumn()).moveTo(targetRange);
   sheet.deleteRow(range.getRow());
 }
}