Filter data using quick and custom filters
Zoho Sprints has an advanced filter capability to facilitate narrowing down to relevant data amidst voluminous information. You will be able to curate and view required details based on predefined or custom conditions.
Let's assume you are the workspace owner and you have multiple projects catering to different streams of your business, like development, design, testing, marketing, implementation, and so on. The data associated with all these projects is available for you.
However, you need to view data of one particular stream, let's say implementation and in particular implementation projects that had started two weeks before. All you need to do to view those details is to filter using appropriate criteria. When the criteria is applied, the data that match the criteria will be displayed.
Types of filters
There're two types of filters: Quick and Custom filters.
Quick Filters: These are predefined filters that are available in Zoho Sprints. The conditions are built using the key components and details that are part of your application and projects. You can select a single attribute or multiple attributes based on which you need your data filtered.
Custom filters: These are advanced filters that allow you to build your criteria one by one, creating a criteria pattern that performs the function of a filter. You can select the fields and define the conditions and their values. Apply the filter to view the data that match the criteria pattern.
Saved filters: You can save and reuse the filters. For example, if you've specified multiple criteria in quick or custom filters, you can save them as a single filter and reuse it later.
Benefits
- It helps you sift through copious amounts of data.
- Applying conditional criteria enables you to fetch data with precision.
- Quick filters are effort saving because they are predefined and ready to use.
- Custom filters help create unique filter criteria.
- Saving the filters helps you reuse the filters, eliminating redundancy of effort.
- Exporting filtered records is supported.
- Filter capability is available across modules.
Apply quick filters
- Navigate to the all projects window. (Or, to the respective modules like backlog, epic, release, meeting, timesheet, or portfolio view.)
- Click the Filter icon at the top.
- Select Quick Filters option in the dropdown menu. The Quick Filters window with predefined filters will appear.
- Select the required filters.
- Click the Apply button. The data matching the applied criteria will be displayed.
- Click the Reset button to undo selection.
- Click the Save Filter option to give a name and save the group of criteria as a filter.
- Click the Clear button to remove the applied filter.
Create and apply custom filter
- Navigate to the all projects window. (Or, to the respective modules like backlog, epic, release, meeting, timesheet, or portfolio view.)
- Click the filter icon at the top.
- Select Custom Filters option in the dropdown menu. The Custom Filter window will appear.
- Select a Field.
- Select a Condition.
- Enter a value.
- Click the +Criteria button to add another row of criteria.
- Specify if it is an AND/OR condition.
- Fill the fields accordingly.
- Click the Apply button. The data matching the applied criteria will be displayed.
- Use the edit option in the criteria pattern to group conditions and define the order of execution of the criteria.
- Click the Save Filter option to give a name and save the group of criteria as a filter.
- Click the Clear button to remove the applied filter.
Apply saved filter
- Navigate to the all projects window. (Or, to the respective modules like backlog, epic, release, meeting, timesheet, or portfolio view.)
- Click the filter icon at the top.
- Select the required filter from the Saved Filter option in the drop-down menu. The data matching the applied criteria will be displayed.
Click the in-line edit or delete icons to edit or delete saved filters.
Export filtered data
- Navigate to the all projects window. (Or, to the respective modules like backlog, epic, release, meeting, timesheet, or portfolio view.)
- Click the filter icon at the top.
- Select Quick Filters option in the dropdown menu. The Quick Filters window with predefined filters will appear.
- Select the required filters. Or, create a custom filter.
- Click the Export option at the bottom of the filter window.
- Select the format for export.
- Set grouping, if needed.
- Set a recurring schedule for export, if needed.
- Click the Apply & Export button. The data matching the applied criteria will be displayed, while the export is also initiated.
- Click the Export icon available on the right navigation bar.
- Download the exported file.
Navigate to Export History to download the exported file.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Manage default and custom status
Status refers to the position of level of progress of a work item. Zoho Sprints provides you with a few standard terminologies to identify the status of your item. Assigning status and promptly moving the item to the successive status enables you to ...Export sprints
You can export the sprint data in an xls or csv file and download it to use outside of the application. This can be used to transform data from Zoho Sprints into a file that you can process in third party apps or other in-house devices. Benefits ...Manage default and custom priority
When it comes to handling work, we need a system to identify the level of priority of a particular task. Based on this, members can take action as required. In Zoho Sprints, there are default priority levels to choose from. These levels are common ...Create custom project status
You can create custom project status that best defines that status of your projects based on your business requirement. There're default status options available. Planning In Progress Quote Negotiation Implementation Completed Closed Abandoned But if ...About custom functions
Zoho Sprints comes with the capability for you to create custom functions and automate your business process. A Custom Function is composed of a group of deluge statements that are combined to perform a certain task. This function can be invoked ...
New to Zoho LandingPage?
Zoho LandingPage Resources