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


          • Sticky Posts

          • Nimble enhancements to WhatsApp for Business integration in Zoho CRM: Enjoy context and clarity in business messaging

            Dear Customers, We hope you're well! WhatsApp for business is a renowned business messaging platform that takes your business closer to your customers; it gives your business the power of personalized outreach. Using the WhatsApp for Business integration
          • Introducing ICR in Zoho CRM: Transform your printed text into digital data

            From writing on papyrus in the ancient times to creating a humble record in your CRM, the world may have evolved with how it used to record data, but data entry as such has not been simplified. It is still a repetitive and arduous chore on which businesses
          • Flex Your Creativity – A New component to Canvas in Zoho CRM

            Hello Everyone We’re excited to introduce Flex, a new component for Canvas in Zoho CRM! Flex is here to give you greater control over how your data is displayed in your layouts. This component enables responsive layouts that adapt across different screen
          • Presenting ABM for Zoho CRM: Expand and retain your customers with precision

            Picture this scenario: You're a growing SaaS company ready to launch a powerful business suite, and are looking to gain traction and momentum. But as a business with a tight budget, you know acquiring new customers is slow, expensive, and often delivers
          • Enrich your CRM data and keep them updated

            You spend a lot of your time and efforts in generating quality leads for your business. While generating leads is a challenge in itself, the real deal begins when sales reps try to nurture these leads and convert them as customers. So how equipped is your sales team with information about your leads matters a lot.  For example, you might be using webforms to generate leads and collect customer information from your website. The lesser your webform fields are, the more your sign-ups right? From optimizing

          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

                                  • Option to Delete Chats in IM

                                    Currently, there is no option to delete any chats in IM, regardless of their source.
                                  • Introducing Assemblies and Kits in Zoho Inventory

                                    Hello customers, We’re excited to share a major revamp to Zoho Inventory that brings both clarity and flexibility to your inventory management experience! Presenting Assemblies and Kits We’re thrilled to introduce Assemblies and Kits, which replaces the
                                  • Installing EMAIL Setup in New Domain

                                    Respected Support team, I'm facing an issue with cloudflare in Pakistan, I want to setup Zoho Mail Setup but I Don't know how to enable Zoho mail setup without cloudflare. My Website https://stumbleguymod.com/ is using CF, and I want a different Zoho
                                  • Stop completed task lists from disappearing?

                                    Is there any way to stop projects from making tasks lists disappear when all the tasks in the list are completed? That's one of those little things where we're constantly fighting the product. For instance we have some projects which are ongoing - no start and end date. We use Kanban view to show the various task lists. We don't want the kanban list to disappear every time the items on it happen to be closed out. Thanks
                                  • Adding Coloured Picklist Based On Email Body Text

                                    Hey All, So i am having this problem, Im currently trying to automate a coloured picklist so that when the body of an email contains a specific word it will assign one of my coloured picklist i have created automatically, But it appears this only works
                                  • Automation #11 - Auto Update Custom Fields with Values from Emails

                                    This is a monthly series designed to help you get the best out of Desk. We take our cue from what's being discussed or asked about the most in our community. Then we find the right use cases that specifically highlight solutions, ideas and tips to optimize
                                  • Email notification for followers

                                    Is there a way to enable email notification for followers of a support ticket? ie: Ticket #123 is owned by Agent#1, Agent#2 adds themselves as a follower. Whenever ticket #123 receives an email from the customer, Agent#1 receives an email. Agent#2 would
                                  • Unified WhatsApp Number Management in Zoho Desk and SalesIQ

                                    Dear Zoho Desk Support Team, We are currently utilizing both Zoho Desk and Zoho SalesIQ for our customer support operations. While both platforms offer WhatsApp integration, we are facing challenges due to the requirement of separate WhatsApp numbers
                                  • Add picklist in subform lookup

                                    Hello, I am trying to rewrite a script that works on a from as parent form, to the same form when is is a subform. Here is what I did in the form itself : RefCat = Offre_de_produits.distinct(Categorie_OFFRE); clear Categorie_LIGNE; for each Record in
                                  • Zoho Desk is extremely slow

                                    Hi Team, We are facing extreme latency issue with Zoho Desk. It is currently unusable. I have submitted a ticket already could you please look into this asap. Regards, Priya Sharna
                                  • Zoho Desk is extremeley Slow

                                    Hi, Zoho Desk seems to be extremely slow for the last 15 mins for everyone in our team (5 people). https://status.zohocloud.ca/ didn't show any status in this regard. Would it be possible to have an idea what is happening and when this should be resolved?
                                  • Help Centre - Widget or Tab for Customer Downloads

                                    USE CASE: We are a software vendor, using Zoho Desk (as part of a Zoho One subscription) to help mange support issues from our customer base. Customers can log tickets via email or Help Centre portal. QUESTION: I need to provide the capability for our
                                  • Integración Books para cumplir la ley Crea y Crece y Ley Antifraude (VeriFactu)

                                    Hola: En principio, en julio de 2025, entra en vigor la ley Crea y Crece y Ley Antifraude (VeriFactu). ¿Sabéis si Zoho va a cumplir con la ley para cumplir con la facturación electrónica conectada a Hacienda? Gracias
                                  • How to let only account-bound products visible to users

                                    Hello friends, I'm trying to leave only the Products linked to the accounts visible to Zoho Portal users. If the user clicks "All Products," they can open tickets incorrectly for products that do not belong to the account that are registered. Is it possible
                                  • Work Orders / Bundle Requests

                                    Zoho Inventory needs a work order / bundle request system. This record would be analogous to a purchase order in the purchasing workflow or a sales order in the sales cycle. It would be non-journaling, but it would reserve the appropriate inventory of
                                  • Try CRM for everyone button in the way of workflow

                                    Please consider using the bottom bar for offers. Using the top bar for offers like "Try CRM for everyone" really gets in the way of my day to day workflow.
                                  • Markdown for Desk?

                                    Hi, my company wants to use markdown for formatting text in Desk (in all modules there, especially Tickets and Helpcenter). Zoho already offers use of markdown in several products (see https://help.zoho.com/portal/en/kb/backstage/microsite-guide/formatting-with-markdown/articles/formatting-with-markdo)
                                  • Limits on workflow never disclosed, not documents and now being applied. I feel scammed and there is no reply for support.

                                    Hello everyone, I’m facing a critical issue with Zoho Recruit and would appreciate any insights from fellow users or someone from Zoho. For months, I’ve been receiving daily emails stating that I have reached the maximum workflow custom functions limit.
                                  • Unable to invite contacts

                                    Hi! I'm unable to invite contacts as end-users from my trial account. The green pop-up displays "Invited succesfully" but the email never arrives, nor the re-invitation - even though it's "sucessfully" as well. Tried with several e-mail accounts, even
                                  • Variables in Zoho Mail Signatures defined by Administrator

                                    Good afternoon, I'm looking at the Admin component of Zoho Mail, and I see we have the capability to define signatures for end users. We also have the ability to associate with multiple email addresses. Are we able to use any variables such as [FirstName}
                                  • Invoice status on write-off is "Paid" - how do I change this to "Written off"

                                    HI guys, I want to write off a couple of outstanding invoices, but when I do this, the status of the invoices shows as "Paid". Clearly this is not the case and I need to be able to see that they are written off in the customer's history. Is there a way
                                  • report on lead status history in zoho crm

                                    I have enabled the lead status history. I want to understand how many days a lead is waiting in which stage and the number of leads vs. stage history, like 0 days, 1-4 days, 5 days above, and 10 days above.
                                  • Cannot send a Campaign. No Send or Proceed button

                                    I have built a Campaign. I had to drop Leads and only use Contacts because only one group can sync. But now I do not see any errors but I do not see anyway to proceed with sending the campaign?
                                  • Default Lookup Field Value based on Picklist

                                    How do I change a lookup field value based on another field's value, while creating/editing a record using form? I have a picklist of different types of Loans. For example: PPP, EDIL, Term, etc. When I create a record using the form, if I choose PPP from
                                  • Accounts module not displaying in Campaigns sync

                                    When syncing CRM to Campaigns, I can only sync Leads and Contacts. Accounts module is setup and not sure why I can't select it. I won't be able to make segments for all our email campaigns. What is the resolution?
                                  • Trouble fetching custom fields from Zoho Booking

                                    I'm following the instructions from here : https://help.zoho.com/portal/en/kb/flow/user-guide/app-specific-documentation/articles/zoho-bookings#1_Problem_with_accessing_custom_fields But I can't get this to work. Here is the result of a test booking :
                                  • Zoho Desk - account and contact lookup by phone

                                    Hi team, Does Zoho Desk allow to lookup Accounts and Contacts by phone or not? I am using this endpoint- GET https://desk.zoho.eu/api/v1/accounts/search?phone=987-654-3210 But I am getting this error- { "errorCode": "UNPROCESSABLE_ENTITY", "message":
                                  • Missing Date Field Type Blocking VAT Calculations in Custom Zoho CRM Module

                                    I'm working on a custom VAT calculator within Zoho CRM where I need to store the purchase date of a product and calculate VAT based on that date, since VAT rates can vary over time. However, while creating custom fields, the only available data type is
                                  • Different Page Numbering

                                    I want the page numbers not just 1,2,3... but i,ii,iii,iv,... or even I,II,III,IV.... How can I do this?
                                  • Remote Control Functionality During Screen Sharing in Zoho Cliq

                                    Hello Zoho Cliq Team, We would like to request the addition of remote control functionality during screen sharing sessions in Zoho Cliq. Currently, while screen sharing in Cliq is very useful, it lacks the ability for another participant to take control
                                  • How to validate Rich Text in Zoho Creator! Urgent!

                                    Hi members, Recently I just started to use Rich Text field. Now I have a requirement where I need to validate to ensure this Rich Text field must contain a value. Meaning must contain something. I use the below script if(input.Rich_Text == null) { alert
                                  • Real-Time Screen Annotation During Zoho Cliq Screen Sharing

                                    Hi Zoho Support Team, Hope you're doing well. We’d like to request the addition of real-time screen annotation tools during screen sharing sessions in Zoho Cliq video calls. 🔍 What We're Looking For: The ability for the presenter—and optionally, other
                                  • Simplify ticket replies with intelligent writing and content analysis tools

                                    Introducing a smarter, faster way to handle ticket responses with generative AI-powered capabilities, now available in the ticket detail view. These enhancements are designed to reduce agent effort, improve clarity, and elevate the overall support experience.
                                  • Zoho Books - Feature Request - Show Custom Template Preview

                                    When using a custom template is would be a great user experience if the custom template could be previewed when viewing the record. I have found that it's very confusing for users, when they see an invoice preview but the out put file is different. Additional
                                  • run a macro on a contact that bounced from crm email merge

                                    how would one run a macro on a contact that bounced from crm email merge? how would i tell zoho to run a macro that SIGNALS said bounced?
                                  • Workflow : Update a multiline text field

                                    Hello, I'm creating a workflow to update a multiline text field. But it looks like I only can format my text as a one-line. How can I format the text to multiple lines ? Thanks
                                  • Search handwriting using sketch card and OCR

                                    Hi It's possible using Sketch Card for handwriting and search them using AI and OCR in Pro edition? Thanks
                                  • Autoresponders in Zoho CRM will be discontinued—transition to Cadences for enhanced engagement

                                    Zoho CRM’s Autoresponder feature will be discontinued by September 30, 2025. If you're currently using Autoresponders to automate email follow-ups, we recommend switching to Cadences, a more powerful, flexible, and multi-channel engagement tool for today's
                                  • Recovering a note

                                    Hi, I accidentally deleted an important academic not from my notebook. Can I recover it? Thanks
                                  • Unable to schedule posts!

                                    Hi everyone, I'm on the free account. I just realised it doesn't give me the options to schedule posts anymore, I can only 'post now'. I don't understand why I can't even see what I scheduled before. Can anyone help? Thanks, Benedetta
                                  • Next Page