How to use filters
This feature allows your users to easily filter the list of items by one or several criteria, e.g, Category, Size, Type, Availability etc.
![](https://storage.crisp.chat/users/helpdesk/website/918f9541750fe800/ss-producthunt-filters_jgxxcy.gif)
Go to the Content tab
Check Enable filters
Select filterable columns
![How to enable filters](https://storage.crisp.chat/users/helpdesk/website/918f9541750fe800/image_19b7w42.png)
For each selected column a filter dropdown will appear on the website. A column name will become the filter name, and the distinct values of that column will become the filter values.
Pro tip: In your Google Sheet use comma-separated values if you want an item (row) to fit multiple values for a filterable column. E.g. Red, Green
To display filters in a sidebar, switch the corresponding toggle on:
![](https://storage.crisp.chat/users/helpdesk/website/918f9541750fe800/sidebar_yzlu57.png)
You can easily change the order of filters by dragging and dropping the filter columns in the menu:
![](https://storage.crisp.chat/users/helpdesk/website/918f9541750fe800/dd-filters_atfngo.png)
Our filters have AND logic between the filters but OR logic inside one filter:
![](https://storage.crisp.chat/users/helpdesk/website/918f9541750fe800/cleanshot-2021-12-13-at-175930_afejxn.png)
![](https://storage.crisp.chat/users/helpdesk/website/918f9541750fe800/ss-producthunt-filters_jgxxcy.gif)
How to enable filters
Go to the Content tab
Check Enable filters
Select filterable columns
![How to enable filters](https://storage.crisp.chat/users/helpdesk/website/918f9541750fe800/image_19b7w42.png)
For each selected column a filter dropdown will appear on the website. A column name will become the filter name, and the distinct values of that column will become the filter values.
Pro tip: In your Google Sheet use comma-separated values if you want an item (row) to fit multiple values for a filterable column. E.g. Red, Green
Display filters in a sidebar
To display filters in a sidebar, switch the corresponding toggle on:
![](https://storage.crisp.chat/users/helpdesk/website/918f9541750fe800/sidebar_yzlu57.png)
Change the order of filters on the website
You can easily change the order of filters by dragging and dropping the filter columns in the menu:
![](https://storage.crisp.chat/users/helpdesk/website/918f9541750fe800/dd-filters_atfngo.png)
Filter Logic
Our filters have AND logic between the filters but OR logic inside one filter:
![](https://storage.crisp.chat/users/helpdesk/website/918f9541750fe800/cleanshot-2021-12-13-at-175930_afejxn.png)
Updated on: 25/04/2024
Thank you!