function onEdit(e) {

    var ss = e.source,
        sheet = ss.getActiveSheet(),
        range = e.range,
        targetSheet,
        columnNumberToWatch = 8; // column A = 1, B = 2, etc
    if (sheet.getName() === "Call Submitted" && e.value === "Call Completed" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Call Completed"
    } else if (sheet.getName() === "Call Submitted" && e.value === "Creating Link" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Creating Link"
    } else if (sheet.getName() === "Call Submitted" && e.value === "Unlock Submitted" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Buyout/Unlock"
    } else if (sheet.getName() === "Call Completed" && e.value === "Call Submitted" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Call Submitted"
    } else if (sheet.getName() === "Call Completed" && e.value === "Creating Link" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Creating Link"
    } else if (sheet.getName() === "Call Completed" && e.value === "Unlock Submitted" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Buyout/Unlockxa"
    } else if (sheet.getName() === "Call Completed" && e.value === "Faded" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Faded"
    } else if (sheet.getName() === "Call Submitted" && e.value === "Faded" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Faded"
    } else if (sheet.getName() === "Creating Link" && e.value === "Call Submitted" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Call Submitted"
    } else if (sheet.getName() === "Creating Link" && e.value === "Call Completed" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Call Completed"
    } else if (sheet.getName() === "Creating Link" && e.value === "Faded" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Faded"
    } else if (sheet.getName() === "Creating Link" && e.value === "Unlock Submitted" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Buyout/Unlock"
    } else if (sheet.getName() === "Buyout/Unlock" && e.value === "Ported" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Ported"
    } else if (sheet.getName() === "Faded" && e.value === "Call Submitted" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Call Submitted"
    } else if (sheet.getName() === "Faded" && e.value === "Call Completed" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Call Submitted"
    } else if (sheet.getName() === "Faded" && e.value === "" && e.range.columnStart === columnNumberToWatch) {
        targetSheet = "Call Submitted"
    }
    ss.getSheetByName(targetSheet)
        .appendRow(sheet.getRange(e.range.rowStart, 1, 1, sheet.getLastColumn())
            .getValues()[0])
    sheet.deleteRow(e.range.rowStart);
}

function onEdit(event){
  var sheet = event.source.getActiveSheet();
  var editedCell = sheet.getActiveCell();

  var columnToSortBy = 8;
  var tableRange = "A3:P"; // What to sort.

  if(editedCell.getColumn() == columnToSortBy){
    var range = sheet.getRange(tableRange);
    range.sort( { column : columnToSortBy, ascending: true } );
  }
}