# How can I filter a Google Sheets data source by certain factors?

**URL:** <https://community.thunkable.com/t/how-can-i-filter-a-google-sheets-data-source-by-certain-factors/1292821>\
**Category:** Questions about Thunkable X\
**Tags:** spreadsheets, data-viewer\
**Created:** [May 19, 2021, 4:19am UTC](https://community.thunkable.com/t/how-can-i-filter-a-google-sheets-data-source-by-certain-factors/1292821 "2021-05-19T04:19:08Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![jane](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jane/32/27575_2.png) [@jane](https://community.thunkable.com/u/jane)\
**Post date:** [May 19, 2021, 8:01am UTC](https://community.thunkable.com/t/how-can-i-filter-a-google-sheets-data-source-by-certain-factors/1292821/5 "2021-05-19T08:01:00Z")

</div>

Hey Kartik! 👋

@manyone’s solution on the Google Sheets end looks awesome, but since you mentioned trying out creating a local view in Thunkable and displaying that in your project, I thought I’d share a project that demonstrates this here.

[Here is the project.](https://x.thunkable.com/projectPage/60a4b5823fb2e80012ce772e)

As you can see, when a genre is selected from the List Viewer, I populate a local Data Source with items from my main Data Source that match this genre. Then I display the matching data in a Data Viewer.

I filter by one criterion, but you can easily modify this to filter by 2 or more criteria! Just add extra `filter list` and `filter criteria` fields as inputs to the `show filtered data` function, and link a few conditions together using and blocks in the `if` statement inside the function.

I’ll write a more detailed tutorial about this soon, since multiple Thunkers have asked about it, but I hope this demo project is helpful to you (or to someone reading)!

---

_[View the full topic](https://community.thunkable.com/t/how-can-i-filter-a-google-sheets-data-source-by-certain-factors/1292821)._