Solved

filterByFormula contains or like

Hi,

I want to search for 1 item in a table which contains multiple items in a cell - apple, banana, grape.

The filterByFormula with the = only works if there is only 1 item in the cell. If they are multiple items, I get an error.

I tried using "contains" and "like" but they don't work.

What should I use?

Thanks

Steve

Best answer by SynopsisLabs

No worries - found an answer -

?filterByFormula=REGEX_MATCH({column_name, "apple")

Did this topic help you find an answer to your question?

No worries - found an answer -

?filterByFormula=REGEX_MATCH({column_name, "apple")

1 reply