Google Sheets filters as Array operators

[Justas]

Hey there,

I have an issue with Google Sheets search rows that I can’t resolve.

So basically I have a Google Sheet with column A. The Column name is Material.

It has such values as rows:

Glass
Metal
Plastic

I use “Array operators: Contains” as a filter to return matching rows when I pass an array like this:

[“Glass”, “Metal”]

However, it still doesn’t return any rows for me. What am I doing wrong here? And is there a way to search rows if I have an array of values and I need to search those values that are in the array?

P.S. Using an array iterator is not an option in this case.

[Donald_Mitchell]

Hello @Justas,

Your operator operates on the value above the operator. So in your case you can’t use an Array Operator on a text string. You can just try switching your variables, putting array above the operator and text below.

I hope this helps!

[Justas]

Okay, got it.

Thanks for your reply!