Saved Filters

Modified on Wed, 31 Jul at 5:53 PM

Introduction

Gigasheet makes it easy to save a filter for later use, either in the same sheet or in different sheets.


Imagine every month you get a report on sales activity. Every month, you want to run the same complex filter. Instead of recreating it every month, simply save the filter for later use. 




How to Get There

Login to Gigasheet > Filters > Save Filters


Saving a filter:


Loading a saved filter:


Steps to Save and Load Filters


First, build out as complex a query as you need:


Then, before hitting Apply, click Save in the top right. You'll be given the option of naming the query 



Click that blue check box, and your query will be saved. 


You can then apply your filter and continue your analysis. 


To rerun that query at a later time on the same sheet, or even on a different sheet, you'll open the Filter builder and click on your saved filter dropdown list 

 

If the columns in the saved query are present in your current sheet, your query will load into the Filter box.

 

You can then apply the filter, or modify the filter as need be, as you continue your analysis. 




   


 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article