Tip #20 - Three things you probably didn't know you can do with picklists

Tip #20 - Three things you probably didn't know you can do with picklists

Hello Zoho Sheet users!

We’re back with another quick tip to help you make your spreadsheets smarter. Picklists are a great tool to maintain consistency in your spreadsheet. Manually entering data is time-consuming and often leaves typos and irregular formatting. With a picklist, you can give a fixed set of options to select from, which helps keep your data clean and structured. Here are some advanced Picklist options that will make data entry super easy while maintaining data quality.

Here’s a sample use case for better understanding:

1. Multi-select in your picklist

Let’s say you are collecting personal information during a hiring process, and you also want to know the languages each candidate speaks. Instead of using multiple columns or stuffing everything into one, simply use a multi-select. This allows you to select multiple languages in one cell without any errors. Here's how you can do it:

Step 1: Select the range of cells you want to insert the picklist to.

Step 2: Insert a picklist using Insert > Picklist > Create Picklist.

Step 3: In the Picklist setup panel, switch to Multiselect.

Step 4: Enter your dropdown options and click Create.

Your multi-select Picklist is ready to use, as you can select multiple options in one.


Notes
The COUNT() function lets you count how many times each item has been entered, even if multiple entries are listed in the same cell.


 

2. Format your picklist

Want your dropdown to communicate urgency visually? Color-code your picklist options using red, yellow, and green. This works with both single- and multi-select picklists.

 

3. Turn existing data into drop-down options 

Want a set of data in your spreadsheet to serve as your picklist source? Simply link your data directly—no need to retype it.
Here's how you can do it:

Step 1: In the Type section of your Picklist setup panel, select Cell Range 

Step 2: Select the range of cells that contain your dropdown options

Step 3: Choose whether you want your data arranged Vertically or Horizontally

Step 4: Click Create






Now, your Picklist will always stay in sync with your source—great for frequently updated spreadsheets.

    • Recent Topics

    • Calendar won't load

      I run into this problem about once a week, where I try to open my Zoho calendar in a web browser, and it just gets stuck, waiting forever to load (see attached screenshot). I'm usually using Edge or Duck-Duck-Go browser. Sometimes it loads just fine,
    • Change 'default' project dashboard

      Is it possible to change the default project dashboard for all projects? Both in layout and in what widgets are shown? We have a lot of (short-running) projects and I want to quickly see the tasks and milestones when I open a Project, but I don't want to change the layout for all my projects manually. Thanks, Menno
    • Multiple subscription plan line items in Zoho Billing quotes

      I run an IT company and sell a lot of licences. A client might have multiple subscription plans including software licences in different categories. A client might have Microsoft licences, antivirus licences, web hosting and maintenance package services.
    • [ZohoDesk] Improve Status View with a new editeble kanban view

      A kanban view with more information about the ticket and the contact who created the ticket would be valueble. I would like to edit the fields with the ones i like to see at one glance. Like in CRM where you can edit the canvas view, i would like to edit
    • Live connection to DS files in Zoho Creator / ChatGPT

      As an idea, we are using ChatGPT to build with Zoho Creator (outside of Zia), which is works brilliantly to assist write deluge, provide test suggesitons etc. Currently we are uploading the DS files which are very point in time, it would be great to have
    • Unable to integrate Whatsapp Messaging into Zoho CRM - Business Messaging

      Hello, I want to set up Business Messaging in our Zoho CRM and am struggling to set it up. I have logged into the account and our facebook business page, our business shows in the dropdown for WhatsApp Business Account but does not for WhatsApp Business
    • Files in Teamspaces: keep your team's documents where the work happens

      Release Note: This feature is available for all accounts across all DCs Hello Everyone, A Teamspace is built around a specific team and a shared objective, and it holds the modules and projects that team works with every day. The document that team depends
    • Script to access a CBPX file from zoho crm

      Hello everyone, I'm planning to write a script in Python or Java in Zoho CRM functions, to access a CBPX file. Is it possible to write this script in the dev console of Zoho? What are the best practices to do this ? Would you have references in the Zoho
    • Calculate hours

      Is there any chance that the the "formula" will have the ability to do calculation using the "time" field in the future? Our company has a form set up for tracking hours worked and we use 2 time fields currently. One for the clock-in time, and one for the clock-out time. It's great for keeping that record, but if there were a way to calculate the hours to show on the report would be awesome. Previously we had used JotForm and their calculator had that ability, but it seems that Zoho doesn't accept
    • Introducing parent-child ticketing in Zoho Desk [Early access]

      Hello Zoho Desk users! We have introduced the parent-child ticketing system to help customer service teams ensure efficient resolution of issues involving multiple, related tickets. You can now combine repetitive and interconnected tickets into parent-child
    • Zoho Books | Product Updates | November 2026

      Hello users, As the year winds down, we've introduced several enhancements to make compliance, inventory management, and everyday bookkeeping easier in Zoho Books. This month's updates include an improved TDS experience, a new way to exchange transactions
    • Zoho Writer workflows now support custom stages, parallel reviews, and external approvers

      Hello everyone, Zoho Writer now lets you build your own approval chains. The pre-built workflows also get new review modes, completion criteria, and external approver support. What’s new Custom workflows: Design review and approval processes from scratch,
    • Expanding sales, marketing, and support capabilities in Zoho CRM Plus 3.0

      Hey everyone, It's been more than 10 years since we launched Zoho CRM Plus back in 2014. This is quite a milestone, and we've come a long way in empowering you with everything you need to offer an exceptional customer experience. On that note, we expanded
    • Erase function in Zoho PDF editor does not truly redact

      Using the "erase" function in the Zoho PDF editor online does not redact the text underneath when opening the file in Adobe. When I used the erase function to whiteout the areas I didn't want to be seen, I opened the supposed redacted files in Adobe.
    • Error creating an XML file

      I am creating an xml as string in the function Employee.generatePartA_XML_String, and then I want to save it as a file to the field "Part_A_XML", but I get the response: {"code":3700,"message":"Unable to upload a file. Please check and try again."} How
    • Thunderbird cannot authenticate Zoho on android

      I keep getting a message from Thunderbird on Android that it could not authenticate for my account, dadashton@zoho.com., and to update my server settings. Now the settings are exactly the same for my other devices (1 Windows, 1 Mac and 2 Linux) Can anybody
    • Mailchimp Integration

      Hello, I am needing some help. Does anybody have a recommended source for information on the Zoho-Mailchimp integration. We are working on a system to import large amounts of records into Zoho that will sync into Mailchimp for us to run a mail campaign out of. Let me explain what the process we are trying to implement - any information or advice is appreciated. Import record data base into Zoho Leads module --> use Lead source to ID records that are part of this mail campaign Zoho Leads (specific
    • [Free webinar] Zoho Creator meets AI with MCP | Creator Tech Connect (November 2026)

      Hello everyone, We are excited to invite you to another edition of the Creator Tech Connect webinar. About Creator Tech Connect The Creator Tech Connect series is a free monthly webinar consisting of purely technical sessions, where we dive deep into
    • Invalid Client - Client ID passed does not exist

      I tried connecting the Zoho campaign with the "Uncanny Automator". It shows an error " Invalid Client - Client ID passed does not exist". There is no option to add manual API. URL: https://accounts.zoho.eu/oauth/v2/auth?response_type=code&client_id=1000.MSFIUOA1G8YBK7IFRL9Z0NINM6DW9C&scope=ZohoCampaigns.contact.ALL&redirect_uri=https%3A%2F%2Fapi.automatorplugin.com%2Fv2%2Fzoho-campaigns&prompt=consent&access_type=offline
    • Field of Lookup - 5 Field Association Limit.

      This query relates to the post at: https://help.zoho.com/portal/en/community/topic/introducing-the-field-of-lookup-in-crm-public-early-access-2023 My simple (and common) scenario: I select an account / customer lookup and want their address pulled into
    • Task status - completed - other options

      I have a dumb question I know i can make custom statuses for the tasks - but is there anyway to make additional "completed" statuses like for instance if i have a task "call back customer" and i leave a vm for them to call back marking it "completed -
    • #20 I've Sent It and It's Wrong

      Meera spots a mistake in an invoice just four minutes after sending it. She has billed a photoshoot at the half-day rate instead of the full-day rate. Her first thought is to delete the invoice and start again. But is deleting the right thing to do? It
    • Zoho Forms API

      Is there any way to get all form entry list using API? Looking forward to hear from you
    • BNZ Bank Feeds No Longer Available

      The BNZ (New Zealand) bank feeds are still failing and it's been months since they last worked! Uploading bank statements (CSV's) mean waiting to the end of the month when they become available. It is unacceptable to keep my clients waiting for payment
    • MCP is now easier to access and configure in Bigin

      Greetings! We hope you're all doing well. We've previously introduced Zoho MCP for Bigin, which lets you connect Bigin with AI tools and interact with your Bigin data using natural language. Now we're making MCP easier to access and configure directly
    • Launch agents from more custom button locations and attach files in Ask Zia

      Hello all, Your agents now meet your team where the work happens. You can add agents to custom buttons in list views, create and edit pages, and related lists, so users launch them without leaving the page they’re on. What’s new Agents in more custom
    • Phone system to integrate with Zoho CRM

      I am looking for phone software that would allow my agency to do the following within Zoho CRM: Make calls from zoho Track calls and notes Leave pre-recorded messages after reaching voicemail of lead Only 2 members, so need company who will allow just
    • Introducing PRM: Build, manage, and scale your partner ecosystem

      Growing a partner ecosystem is a good problem to have. What starts as a handful of partners can quickly turn into a maze of spreadsheets, emails, and disconnected processes. More partners mean more opportunities, greater reach, and new ways to grow
    • Zoho Projects connector with Zoho CRM (Related List module) features

      Hi community, I use Zoho Projects connected to Zoho CRM, where we associate Projects with Deals, clients, etc.. I am looking to change/edit the fields that are available in the integration. Currently it shows Project Status, Project Completion, Milestones,
    • Feature Request: Render Markdown (.md) files in Zoho Cliq

      Hi, We regularly share Markdown (.md) files in Zoho Cliq. However, when we open these files in Cliq, the content does not render as Markdown—it displays as plain text. This forces us to copy/paste the content into an external Markdown viewer to read it
    • Free webinar: Zoho Sign for Microsoft apps

      Hello, Did you know Zoho Sign works right inside the Microsoft apps you already use? A signature request shouldn't mean leaving Teams for another tab, or downloading an Outlook attachment just to sign it. Zoho Sign integrates with Microsoft 365, Teams,
    • Users can now notify the contact while adding a 'Resolution' to the ticket.

      Hello, In the latest version of the Desk iOS mobile app (v2.6.4), users can now notify the contact while adding a 'Resolution' to the ticket. Also, the 'Resolution' UI has been tweaked to support edit and delete option.   Please update the app either
    • Better Time Tracking

      We need better time tracking customization for IT MSPs. We also need reporting that is built in, rather than having to try and fumble with creating custom reports. We also need to be able to mark whether a ticket has been billed or not, I don't think
    • Introducing Custom Fonts for Career Sites

      Your Careers page is often the first place candidates interact with your organization. From exploring job opportunities to submitting applications, a consistent visual experience helps candidates recognize and connect with your brand. To give you more
    • Need help with importing expenses

      I'm using the template downloaded from the application. When I try to import my expenses, I get the message: Duplicate entry in the Expense Date column. Ensure it contains unique values. None of the rows will import. There are duplicate dates, but they
    • time tracking on zoho crm cases

      Is there a time tracking feature in zoho crm cases? I need calculate time spent in calls, tasks and events Thanks in Advance  
    • Integrate with Power BI

      Hi, How to connect Zoho CRM dashboards & reports with POWER BI ?
    • Unbundle feature for composite items

      We receive composite items from our vendors and sell them either individually or create other composite items out of them. So, there is a lot of bundling and unbundling involved with our composite items. Previously, this feature was supported in form
    • Zoho Recruit: Time to Step Up Your AI Game!

      I've been using Zoho Recruit for many years and I love it. But let's be honest, it's starting to feel a bit like a relic from the pre-ai era. I recently tried out new systems that have ai resume screening and ai interviewing capabilities, these systems
    • Zoho mail app throwing network error

      Zoho mail app is throwing network error and I do not know how to fix the issue.
    • Next Page