- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 04, 2024 09:32 AM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 04, 2024 09:40 AM
No worries - found an answer -
?filterByFormula=REGEX_MATCH({column_name, "apple")
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 04, 2024 09:40 AM
No worries - found an answer -
?filterByFormula=REGEX_MATCH({column_name, "apple")
