Now filter your records by multi-select pick list values from a dropdown with additional operators

Now filter your records by multi-select pick list values from a dropdown with additional operators

Hi everyone, 

Here's an update to help you elevate your filtering experience. You can now say goodbye to the cumbersome string values in filtering places for your multi-select picklist fields and say hello to a dropdown interface.

It is now possible for you to filter your data with precision and accuracy with the convenience of displaying values in a dropdown just like in single picklist fields. For instance, when you filter your leads using the IS operator for a single picklist field, its values appear in a dropdown. However, in the case of multi-select picklist fields, the values needed to be manually entered and then they would appear in a string.This would prove to be quite challenging owing to the lack of awareness of all the values that existed in the system. It is to simplify that process that you can now view your multi-select picklist values in a dropdown and choose your option/s from it. 



Here's a GIF to help you understand the update better.


Introduction of new operators

Now that you have understood this feature update, let's move into the next update - the introduction of new operators, namely:

  • Includes All

  • Includes Any

  • Excludes All

  • Excludes Any

Note. You can select only 5 values for each multi-select picklist dropdown with the said operators. 

Includes All and Includes Any


Includes All

One of the multi-select picklist fields that the Zylker Travels has included in its leads form is Assistance Requirements.

The options it offers are:

  • Complete Package

  • Hotel Bookings

  • Travel Guides

  • Transportation

  • Flight Booking

  • Food Provision on Treks

A sales rep handling domestic customers wants to filter out leads who have selected Hotel Bookings, Travel Guides, and Transportation.

Robert Hamilton, Steven Whidden, and Larry Halstead are prospects who have opted for all three options. Therefore, while filtering out leads, when the rep selects the operator 'includes all', choosing all values, the said leads appear.

Includes Any

When the rep tries to filter out leads who have opted for any one of the options, the system throws up the names of eight records who meet the criteria.



Excludes All and Excludes Any


Excludes All

The rep wants to filter out leads who have not selected all of the following values from the activities provided:

  • Experience Fine Dining

  • Wineries and Vineyards

Following the same strategy (using the Excludes All operator) as has been mentioned above, the system throws the names of 10 records who meet the criteria. 



Excludes Any 

The rep now wants to filter out leads who have not opted for either of the said options. 



Note.

  • If a user opts for five multi-select picklist fields while filtering records with the new operators, they forfeit the ability to select any more multi-select picklist fields utilizing the same operators. The user can still opt for more multi-select picklist fields, but with different operators (not Include/Exclude).

  • In a custom view and smart filters together, only 5 multi-select picklist fields with the new operators can be used. For example, if a user utilizes four multi-select picklist fields in a custom view using the new operators, they can choose only one multi-select picklist field in smart filters using the new operators.


Here's a table to help you understand the behavior of some important operators:



Note.

The updates - both dropdown as well as additional operators - will be available for Custom Views, Smart Filters, Reports, Portals, Analytics and GDPR. Eventually, it will be added to other areas of CRM as well.

This feature is being released in a phased manner.

That's all for the announcement. Please share your feedback in the comments below. 


      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ



                                ご検討中の方

                                  • Recent Topics

                                  • Turn off Mobile Optimize

                                    Hello is it possible to stop the automatic mobile optimization of my site as it looks much better on a mobile in full site format rather than mobile format. Thanks
                                  • Tag Limi?

                                    is there any way to create more than 20 tags? 
                                  • How to select from pricebook when creating a salesorder or quote

                                    I am creating a sales order and when selecting the Products I do not see any where to select from pricebooks. How do i associate this to my orders?
                                  • API - Available Stock Definitions

                                    Okay, Zoho team... your copywriters fell down on the job for this one :) I think these warrant a bit more explanation as to what they include and what they don't.
                                  • Cross-application Deluge calls fail when application link name starts with a number

                                    I encountered an issue when calling a custom function in another Zoho Creator application within the same account. The target application’s URL/application link name began with a number, similar to: 27_example_application The following cross-application
                                  • Can I Build a Gaming Website Using Zoho? Need a Quick Roadmap

                                    Hi Dear Members, I want to create a gaming website using Zoho. Is it possible? My goal is to build a sleek, unique, easy-to-navigate, and fast-loading website for a gaming project. I want the site to look professional, user-friendly, and optimized for
                                  • Transformez vos webinaires en opérations automatisées

                                    Organiser un webinaire, c’est bien plus que passer en direct. Il faut gérer les inscriptions, suivre les participants, envoyer les enregistrements, mettre à jour le CRM… et s’assurer que chaque étape se déroule au bon moment. L’automatisation des workflows
                                  • Marketing Tip #1: Optimize item titles for SEO

                                    Your item title is the first thing both Google and shoppers notice. Instead of a generic “Leather Bag,” go for something detailed like “Handcrafted Leather Laptop Bag – Durable & Stylish.” This helps your items rank better in search results and instantly
                                  • Remove Due Date from Statements

                                    Is it possible to remove the Due Date on the Invoice transation line on statements? I have figured work arounds to get the Invoice detail on the Statement but cannot work out haw to simplify the stament by removing the "- due on xx/xx/2026" - it really
                                  • Cliq iOS can't see shared screen

                                    Hello, I had this morning a video call with a colleague. She is using Cliq Desktop MacOS and wanted to share her screen with me. I'm on iPad. I noticed, while she shared her screen, I could only see her video, but not the shared screen... Does Cliq iOS is able to display shared screen, or is it somewhere else to be found ? Regards
                                  • Displaying only unread tickets in ticket view

                                    Hello, I was wondering if someone might be able to help me with this one. We use filters to display our ticket list, typically using a saved filter which displays the tickets which are overdue or due today. What I'd really like is another filter that
                                  • How can I filter inactive/disable agent tickets?

                                    Hello, We have an user-agent that left the company and we inactive/disabled his agent. So, now I can no longer filter or search tickets that he is the current owner, or even create a rule to reassign tickets to another person when the ticket is reopen.
                                  • How do i move multiple tickets to a different department?

                                    Hello, i have several tickets that have been assigned to the wrong department.  I am talking about hundreds of automatically generated ones that come from a separate system. How can i select them all at once to move them to another department in one go? I can select them in "unsassigned open tickets view" but i can't find a "move to another department" option. I also can't seem to assign multiple tickets to the same agent in that same view. Could somebody advice?
                                  • Add Reauthentication Option for Zoho Bug Tracker Integration in Zoho Desk

                                    Hello Zoho Desk Team, We hope you're doing well. We would like to request an enhancement to the Zoho Bug Tracker integration within Zoho Desk. Current Limitation: At the moment, there is no option to reauthenticate the Zoho Bug Tracker integration in
                                  • Dashboards for Customers

                                    Is it possible to build dashboards for each customers in the community for their tickets?
                                  • Create Package From A Picklist

                                    Dear Zoho, Can it be made possible to create a package from a picklist? The reason our company makes a picklist is for that to become a package Our sales orders have 600-1000 items I hope that makes it clear that it's hard to delete 990 items when we
                                  • Migrating from Zoho Checkout to Zoho Billing

                                    I have an active Zoho Checkout account where I'm charging customers for subscriptions. Now I'm looking to upgrade and only use Zoho BIlling, in which my account in on read only mode at the moment. I can see is also tracking the customers and its payments.
                                  • API - Bank Accounts | Reconciliation Discrepancy

                                    Unless I'm reading it wrong, the documentation for the Bank Reconciliations API is inconsistent with itself. https://www.zoho.com/books/api/v3/bank-accounts/#create-a-bank-reconciliation The text definition says that the transaction_id should be a string,
                                  • another little issue

                                    So to get over showing prices with VAT we used the price lists and made the prices inclusive. The problem is now on the items it wants to show the orginal retail value which makes no sense. Ideas please
                                  • Handle Leading Zeros in a Number Field

                                    Hi, If I use a Number Field, set with Min 7 Digits and Max 7 Digits, and enter 0000001, it will result in 1 and an error as it removes the leading zeros, the same with entering 0012340 will result in 12340 and error. So I have to use a Text Field and
                                  • can't access zoho account

                                    I can't log in to my zoho account, can you help me
                                  • HTML PDF Templates / Build From Scratch option not visible for Custom Modules

                                    Hi everyone, I am working with Zoho Books Custom Modules and trying to create a custom 4x4 package label PDF template using HTML/CSS. According to the official Zoho Books documentation for HTML PDF Templates, there should be an option like: Settings →
                                  • Virtual Option for Fields

                                    Hi, I would like to be able to choose another option other than Read-Only or Disabled, such as Virtual. And with Virtual, the field is shown on the form and avilable in rules, but NOT saved to the Database. A use case is having multiple Large Lists of
                                  • Prefix & Suffix on Single Line, Number, etc.

                                    Hi, I would like to have the same Prefix and Suffix that was added to the Unique ID on Text and Number Fields. Use case could be as basic as temperature, as per another Idea I have to use Single Line (Text) for a number that might have leading zeros today,
                                  • Customer User Fields for use in Rules

                                    Hi, I would like to be able to add custom fields to the users, such as Department or Role, which can then be used in Rules, Reports, etc. as a condition. A use case is limiting Global lists or Choices based on the users Custom Field, so one form can be
                                  • Locked out of MFA due to changing phones

                                    I have been locked out of my Zoho Books account since i changed my mobile phone over. I can get the OTP through the ZOHO Books software but i cant confirm using my phone app as nothing appears to authorise. I need to know how to register/set up my new
                                  • 👍 Zoho CRM's Notes now gets Reactions and a new look

                                    Available in SA and JP DCs. Rolling out to other DCs in phases. Hello everyone, Notes help users capture important updates, collaborate with teammates, and maintain context for records. Now with Note Reactions, users can quickly acknowledge updates, express
                                  • All new Address Field in Zoho CRM: maintain structured and accurate address inputs

                                    Availability Update: 29 September 2025: It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition exclusively for IN DC users. 2 March 2026: Available to users in all DCs except US and EU DC. 24
                                  • Zoho books and venmo

                                    Hi, Is there a way to hook Venmo into zoho books? I have a Venmo business account and want to be able to sync that. I know you can do it with the paypal integration but I dont want to use paypal for the fees and that doesnt allow me use/integrate my current
                                  • Updating Unit Code for New Item Creation, Quote and Invoicing is so inconvenient

                                    The Zoho Team has implemented many updates, but these updates should be optional. Before rolling out any new feature, they should already have a solution in place that allows users to remove or disable it if they choose not to use it. Just yesterday,
                                  • Payroll needs to automatically remit taxes, not just give me the calculations

                                    Wagepoint, PayEvo, Waveapps, etc... All your competitors deposit employee payroll, but they ALSO remit taxes automatically. Get with the program, your Payroll app is extremely sparse.
                                  • Creating new Teams meeting from CRM doesn't enable Team functions in the meeting

                                    Hi I'm trying to set up the meeting integration and I've seen that when I create a Meeting in the CRM and set the location to Online and the Provider to Teams, and complete the boxes, add a participant etc, whilst the meeting is created in Teams, the
                                  • Approval Process configuration is now more flexible and fully customizable

                                    The Approval Process is back with an improved user experience designed to make it easier to build structured, flexible, and intuitive approval workflows. Here’s a look at some of the key enhancements: Name Your Rules & Stages You can now give each approval
                                  • Admin Logging in as another User

                                    How can a Super Admin login as another user. For example, I have a sales rep that is having issues with their Accounts and I want to view their Zoho Account with out having to do a GTM and sharing screens. Latest Update (27th April 2026): With the early
                                  • Introducing Approval SLA for Approval Processes

                                    Approvals can sometimes be delayed when approvers do not respond within the expected timeframe, which can slow down your recruitment processes. With the new Approval SLA in Zoho Recruit, you can set deadlines for approval requests and define automated
                                  • Introducing Microsoft Word Integration in Zoho Contracts

                                    We are excited to announce a new feature that brings contract authoring and negotiation in your familiar environment — the Microsoft Word Integration. What This Integration Brings The Microsoft Word Integration connects Zoho Contracts with the Microsoft
                                  • Map My Client Locations for Zoho CRM Extension: Turn CRM Addresses Into Action

                                    Hello everyone, Your CRM knows who your customers are. Now, see where they are on the interactive map directly from Zoho CRM. Introducing Map My Client Locations for Zoho CRM, an extension built for businesses that rely on sales visits, field service,
                                  • Scheduled and Automated Report Delivery from Zoho Projects

                                    Zoho Projects has useful reports including task reports, timesheet summaries, and workload charts. However, there is currently no way to schedule these reports to be automatically delivered to stakeholders on a recurring basis. This means: Project managers
                                  • Collaborate Visually with Whiteboard in Zoho Projects

                                    Whiteboard in Zoho Projects allows you to collaborate visually by creating diagrams, annotating designs, and sketching project workflows using shapes, text, and images within project modules. Team members can work simultaneously, improving productivity
                                  • Fields in MS-Word Template

                                    With the new MS-Word integration, how does one create fields in an imported MS-Word document which can then automatically be populated with an Intake Form?
                                  • Next Page