const SHEET_NAMES = {
  dev_jobs: "Dev Jobs",
  done: "Done"
};
function rows_move_status_done() {
  const SHEET_FROM_NAME = SHEET_NAMES.dev_jobs;
  const SHEET_TO_NAME = SHEET_NAMES.done;
  const EXPECTED_COLUMN_LABEL = "Status";
  const EXPECTED_COLUMN_VALUE = "Done";

  const sheet_from = SpreadsheetApp.getActiveSpreadsheet().getSheets().filter((sheet) => sheet.getName() == SHEET_FROM_NAME)[0];
  const sheet_to = SpreadsheetApp.getActiveSpreadsheet().getSheets().filter((sheet) => sheet.getName() == SHEET_TO_NAME)[0];

  const sheet_from_protection = sheet_from.protect().setWarningOnly(true);
  // if trying to edit, people will receive a warning asking for confirmation
  // it is to give enough time to avoid manual edits which could
  // change the data after rows is attained on next line, so moved data might is correct

  const rows = sheet_from.getDataRange().getValues();
  const status_index = rows[0].findIndex(value => value == EXPECTED_COLUMN_LABEL);
  //rows[0] is row number 1
  const remove_expected = (columns, row_number) => {
    if (columns[status_index] == EXPECTED_COLUMN_VALUE) {
      sheet_to.appendRow(columns);
      sheet_from.deleteRow(row_number);
      return true;
    }
    return false;
  }

  rows.forEach((value, index) => remove_expected(value, index + 1));
  //index + 1 to reflect excel expected row_number
  sheet_from_protection.remove();
}

function onEdit(e) {
  if (e.range.getSheet().getName() === SHEET_NAMES.dev_jobs) {
    rows_move_status_done();
  }
}

下面是将特定行移动到另一个工作表的示例。此过程仅适用于值，因为公式引用可能会中断。

function myTest() {
  try {
    let spread = SpreadsheetApp.getActiveSpreadsheet();
    let sheet1 = spread.getSheetByName("Sheet1");
    let sheet2 = spread.getSheetByName("Sheet2");
    let values = sheet1.getDataRange().getValues();
    // if you need to remove header then values.shift();
    let results = [];
    let rows = [];
    values.forEach( (row,index) => {
        if( row[3] === "Done" ) {  // Column D
          results.push(row);
          rows.unshift(index+1);  // which row needs to be deleted
        }
      }
    );
    sheet2.getRange(sheet2.getLastRow()+1,1,results.length,results[0].length).setValues(results);
    console.log(results);
    // now delete the rows from sheet1 starting with last
    rows.forEach( index => {
        sheet1.deleteRow(index);
      }
    );
  }
  catch(err) {
    console.log(err);
  }
}

参考资料

• getSheetByName（）
• getDataRange（）
• Range.getValues（）
• Range.setValues（）
• System.out.println（）
• Spreadsheet Best Practices