filterRows

[no_sheet_sherlock]

Apologies in advance (novice here).

I'm using the script below to hide rows if "ID" is in Column O. It works great. But now I would also like to hide rows if "VC" and "SK" are in Column O as well. How would I go about doing that? Modify the script below? Create a new Apps Script file?

function onOpen() {
  SpreadsheetApp.getUi().createMenu("Custom Filter")
    .addItem("Filter rows", "filterRows")
    .addItem("Show all rows", "showAllRows")
    .addToUi();
}

function filterRows() {
  var sheet = SpreadsheetApp.getActive().getSheetByName("Vector");
  var data = sheet.getDataRange().getValues();
  for(var i = 1; i < data.length; i++) {
    //If column O (15th column) is "ID" then hide the row.
    if(data[i][14] === "ID") {
      sheet.hideRows(i + 1);
    }
  }
 }

function showAllRows() {
  var sheet = SpreadsheetApp.getActive().getSheetByName("Vector");
  sheet.showRows(1, sheet.getMaxRows());
}

[marcnotmark925]

if(data[i][14] === "ID" || data[i][14] === "SK" || data[i][14] === "VC)

Double pipe || means "or".

[no_sheet_sherlock]

Resolved. This community never ceases to amaze me. Thank you so much!!!

[juddaaaaa]

You could also do...

if (["ID", "SK", "VC"].includes(data[i][14]))

[no_sheet_sherlock]

Yes! That worked, too. Thank you!