I want to be able to delete a row if certain columns match the criteria. This is what I have so far:
function deleteEachRow(){
let tempSheet = SpreadsheetApp.getActiveSpreadsheet();
let sheet = tempSheet.getSheetByName("Intermediate");
var RANGE = sheet.getDataRange();
var rangeVals = RANGE.getValues();
}
from here I would like to find out if column[11] !=='' and column[12] ==='completed', if it meets the criteria then delete the row.
Any ideas?
function deleteEachRow(){
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sh = ss.getSheetByName("Intermediate");
const sr = 2;//data start row
const rg = sh.getRange(sr, 1, sh.getLastRow() - sr + 1, sh.getLastColumn());
const vs = rg.getValues();
let d = 0;
vs.forEach((r,i) => {
if(r[10] && r[11] == 'completed') {//column 11 and 12
sh.deleteRow(i + sr - d++);//d increments on each delete
}
});
}