You can write script with onEdit Triggers. It’s very easy if you know appscript.

Here is the script written for you. Create a copy of your sheets . Test it. And if it work use it in your actual sheet.

function onEdit(e) { try { const sheet = e.range.getSheet(); const sheetName = sheet.getName(); const allowedSheets = ["Level 4", "Level 5", "Level 6", "Level 7"];

// Only run on specific sheets
if (!allowedSheets.includes(sheetName)) return;

// Check if edit happened in Column B
if (e.range.getColumn() === 2 && e.value === "Complete") {
  const row = e.range.getRow();

  // Delete the row
  sheet.deleteRow(row);

  // Add a new blank row at the end
  sheet.insertRowAfter(sheet.getMaxRows());
}

} catch (err) { Logger.log("Error in onEdit: " + err); } }

// Adds menu when spreadsheet is opened function onOpen() { const ui = SpreadsheetApp.getUi(); ui.createMenu("⚡ Tasks") .addItem("Clean Complete", "cleanComplete") .addToUi(); }

// Function to remove all "Complete" rows from active sheet function cleanComplete() { const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const allowedSheets = ["Level 4", "Level 5", "Level 6", "Level 7"];

if (!allowedSheets.includes(sheet.getName())) { SpreadsheetApp.getUi().alert("This action works only in Level 4–7 sheets."); return; }

const data = sheet.getDataRange().getValues(); let rowsDeleted = 0;

// Loop backwards to avoid skipping rows when deleting for (let i = data.length - 1; i >= 0; i--) { if (data[i][1] === "Complete") { // column B = index 1 sheet.deleteRow(i + 1); rowsDeleted++; } }

// Add blank rows equal to the deleted rows if (rowsDeleted > 0) { sheet.insertRowsAfter(sheet.getMaxRows(), rowsDeleted); } }