onEdit.gs

function onEdit(event) {
  dateStamp(event);
  moveClosedCases(event);

}

function dateStamp(event) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  Logger.log(event.source)
  var s = event.source.getActiveSheet();
  var r = event.source.getActiveRange();
  //CORE VARIABLES
  // The column you want to check if something is entered.
  var COLUMNTOCHECK = 8;
  // Where you want the date time stamp offset from the input location. [row, column]
  var DATETIMELOCATION = [0, -3];
  // Sheets you are working on
  var SHEETNAMES = ['JC', 'JC2', 'JC3']

  //checks that we're on the correct sheet.
  if (SHEETNAMES.includes(s.getSheetName())) {
    //checks the column to ensure it is on the one we want to cause the date to appear.
    if (r.getColumn() === COLUMNTOCHECK) {
      var dateTimeCell = r.offset(DATETIMELOCATION[0], DATETIMELOCATION[1]);
      dateTimeCell.setValue(new Date());
    }
  }
}


function moveClosedCases(event) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var s = event.source.getActiveSheet();
  var r = event.source.getActiveRange();
  // Sheets you are working on
  var SHEETNAMES = ['JC', 'JC2', 'JC3']
  var COLUMNTOCHECK = 1 //1 = A, 2 = B etc.

  if (SHEETNAMES.includes(s.getName()) && r.getColumn() == COLUMNTOCHECK && (['Closed', 'closed', 'No Response', 'no response', 'No response'].includes(r.getValue()))) {
    var row = r.getRow();
    var numColumns = s.getLastColumn();
    var targetSheet = ss.getSheetByName("Closed Cases");
    var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    s.getRange(row, 1, 1, numColumns).moveTo(target);
    s.deleteRow(row);
  }
}