# Search and filter by using several keywords in one cell (google sheet)

**URL:** <https://community.thunkable.com/t/search-and-filter-by-using-several-keywords-in-one-cell-google-sheet/4107704>\
**Category:** Questions about Thunkable X\
**Tags:** help\
**Created:** [October 1, 2025, 12:23pm UTC](https://community.thunkable.com/t/search-and-filter-by-using-several-keywords-in-one-cell-google-sheet/4107704 "2025-10-01T12:23:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![robert.lundelli4pcye](https://avatars.discourse-cdn.com/v4/letter/r/f08c70/32.png) [@robert.lundelli4pcye](https://community.thunkable.com/u/robert.lundelli4pcye)\
**Post date:** [October 1, 2025, 12:23pm UTC](https://community.thunkable.com/t/search-and-filter-by-using-several-keywords-in-one-cell-google-sheet/4107704/1 "2025-10-01T12:23:54Z")

</div>

Hi

I have an app that filter through a google sheet and display the rows containing one keyword that mach the searchterm.

I now would like to add several keywords in the same cell and have thunkable search through all. I need to do some filtering by the “,” but I do not know how.

Also. Where do I add the “lowercase” object to make it case sensitive.  
And last “problem” to solve. Make the result to show everything containing the string text written in the search field. If the user write car, it will show carshow, carproblems, carvideos (not that I have car in my sheet but just as an example)

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/5/b557bc2f45ed1943bfc2b7275533de02eaf80038.png)

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [October 2, 2025, 2:19pm UTC](https://community.thunkable.com/t/search-and-filter-by-using-several-keywords-in-one-cell-google-sheet/4107704/2 "2025-10-02T14:19:43Z")

</div>

I would consider creating a formula in the Google Sheet to do all of that and then access the results from Thunkable. That also allows you to use AI to generate a complex formula.

---

<div class="post-metadata">

**Author:** ![robert.lundelli4pcye](https://avatars.discourse-cdn.com/v4/letter/r/f08c70/32.png) [@robert.lundelli4pcye](https://community.thunkable.com/u/robert.lundelli4pcye)\
**Post date:** [October 3, 2025, 7:13am UTC](https://community.thunkable.com/t/search-and-filter-by-using-several-keywords-in-one-cell-google-sheet/4107704/3 "2025-10-03T07:13:09Z")

</div>

Did not know that was a possibility. Will look into that. Thank you

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [January 1, 2026, 7:13am UTC](https://community.thunkable.com/t/search-and-filter-by-using-several-keywords-in-one-cell-google-sheet/4107704/4 "2026-01-01T07:13:54Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.