How to move a row to another sheet by condition?

Question

Google Sheets

Good afternoon.
Please tell me how it can be implemented.

When the status of the application is changed to "Completed", the entire line is transferred to another sheet.

Answer 1

If via Google Script:

let ss = SpreadsheetApp.getActiveSpreadsheet();
let zayvkaSheet = ss.getSheetByName('Заявки'); //или как нужно лист назвать
let doSheet = ss.getSheetByName('Выполнено');

function onEdit(e) {
  let cell = e.range;
  if (cell.getSheet().getSheetName() === zayvkaSheet.getSheetName()){ // проверка на то, что изменение происходит именно на листе со списком заявок
    if (cell.getValue() === 'Выполнено'){
      zayvkaSheet.getRange(cell.getRow(), 1, 1, zayvkaSheet.getLastColumn()).copyTo(doSheet.getRange(doSheet.getLastRow() + 1, 1)); //перенос на другой лист
      zayvkaSheet.deleteRow(cell.getRow()); // удаление строки из листа
    }
  }
}

Add, save, run once through the script editor (it will ask permission to change the text in the table) and still
add data validation for the dropdowns

Answer 2

• Formula (see FILTER(); only it will not be a transfer, but a display / output).
  
• An add-on for Google Spreadsheets (see Reactor).
  
• Integration service (Zapier, Integromat, automate.io, etc.)
  
• Google Apps Script.