0

In Google Sheets, I need to hide rows if column H says, "Completed"

My preference would be to cut and copy the row to a new sheet if column F reads "Completed", but sounds more difficult.

If you have the time to explain this, it would be great.

Currently, I have a Query function on another sheet which will copy a row if that rows column F reads, "completed", but if I then delete the row off of the original sheet, then of course it disappears.

0

use this script which will check H column and when it finds Completed it will move the whole row (A:Z) from Sheet1 into Sheet2 and then delete row from Sheet1

function copyrange() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Sheet1'); //source sheet
  var testrange = sheet.getRange('H:H'); //range to check
  var testvalue = (testrange.getValues());
  var csh = ss.getSheetByName('Sheet2'); //destination sheet
  var data = [];
  var j =[];

  //Condition check in H:H; If true copy the same row to data array
for (i=0; i<testvalue.length;i++) {
  if ( testvalue[i] == 'Completed') {
  data.push.apply(data,sheet.getRange(i+1,1,1,25).getValues());
  //Copy matched ROW numbers to j
  j.push(i);
 }
 }
//Copy data array to destination sheet

 csh.getRange(csh.getLastRow()+1,1,data.length,data[0].length).setValues(data);

//Delete matched rows in the source sheet
  for (i=0;i<j.length;i++){
  var k = j[i]+1;
  sheet.deleteRow(k);

//Alter j to account for deleted rows
  if (!(i == j.length-1)) {
  j[i+1] = j[i+1]-i-1;
}
}
}

protected by Community Oct 2 at 21:10

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.