Tip #10: 3 helpful ways to use data validation in your spreadsheet
Data validation in spreadsheets makes data entry processes more efficient, while helping reduce inconsistencies and errors in your data sets. In this article, we'll look at three ways you can use data validations to create useful dropdown lists in your spreadsheets.
Dynamic data validations
Dynamic validations help you create a new dropdown list based on an existing dropdown list or range of values. Let's say the first dropdown has the names of all the departments in your organization. You can now create a secondary dropdown list that displays designations based on the value chosen from the first dropdown!
Dynamic data validation can be achieved using the lookup functions based on the number of criteria required. Here's a
published spreadsheet
for a hands-on experience!
Dropdowns with symbols
You might need to include symbols in your spreadsheet for comprehension or visual presentation. Create a validation with a list of desired text symbols and easily access them when needed.
Note: Only text icons can be used in data validation. There are many sites offering free text icons for easy use via copy-paste.
Condition-based validations
Apart from dropdowns, you can use data validation to restrict or allow data entry, and set conditions on a range based on values in other cells. This way, you can restrict edits on a range without using Lock!
Join the
Zoho Sheet community
and stay up to date on the latest features, interact with fellow users, and learn from the team behind Zoho Sheet. For more exciting tips, follow our
Tips and Tricks
forum.
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
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
New to Bigin?
Topic Participants
Jaya Shankari S
aarronpina
Kiruthika Jennifer V
Sticky Posts
Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements thatTip #16: Ask Zia your data-related questions and get powerful insights
Zoho Sheet provides a variety of tools and functionalities to help you analyze your data from end to end. But what if you could analyze all your data sets with a single AI-powered tool? Meet Zia, our smart virtual assistant who will answer all your data-relatedTip #17: Easily share spreadsheets with non-Zoho account users
With efficient, collaboration-friendly options, Zoho Sheet is a popular choice among users. Sheet's external share links help you collaborate more effectively by sharing your spreadsheets with anyone outside your organization, including users who do notTip #7: Four things you didn't know you can do with Conditional Formatting
Conditional formatting helps you highlight and visualize data in your spreadsheet based on provided rules. Zoho Sheet offers three types of conditional formatting: Classic, Color Scales, and Icon Sets. If you're already familiar with how Conditional Formatting works, here are some bonus tips for Classic formats: Customize rules with formulas Zoho Sheet allows you to create personalized rules based on formulas. For example, in a task list you can use customized formulas to highlight tasks which areTip #15: Stop guessing and start estimating with Zoho Sheet's Goal Seek
Goal Seek is an ideal spreadsheet tool for devising estimates, as it helps you retrieve your desired output value when the input values are not known. In other words, Goal Seek does back-solving to find input values once you've provided an output value.
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
How to find the number of companies within contacts
I'm trying to track our database growth and want to find out how many companies we have in our database. is there an easy way to do this? Moderation Update: I'm locking this post, as we have an ongoing discussions in this linked post. You can follow theWant to setup automation
I would like to send mail automatically after 7 days when stage is approved using Bigin Automation. Can you guide. I tried and attached the screenshot but it seems to be not working well.Generate a Zoho Sign link
From time to time I get a response "I never received your you e-document for electronic signature" is there a way to generate a Zoho Sign link to share.Highlight a candidate who is "off limits"
Hello: Is there a way to highlight a candidate who is "off limits"? I would like to have the ability to make certain candidate and / or Client records highlighted in RED or something like that. This would be used for example when we may have placed a candidate somewhere and we want everyone in our company to quickly and easily see that they are off limits. The same would apply when we want to put a client or former client off limits so no one recruits out of there. How can this be done? Cheers,Feature Request - Approval Processes
Hi Team, I think it would be really valuable to add the approval process feature like what is currently available in the CRM. The problem with the current approval support is it can't be automated to send the approval to set people based on the values of fields within the tickets. Is this something that could be considered for the roadmap? Thanks, HarryWhat is VoC "Unique count", counting?
Using the "Response based sentiment analysis" dashboard, here is our VoC "Overall Count by Sentiment" VoC uses Zoho Survey and email...and we have almost certainly touched (via email) more than 401 Contacts since January 1, 2025.Knowledge base articles is now available in the Zoho Desk mobile app!
Hello all, As a customer service agent, every day you might have to deal with many questions and issues reported by the users. With Knowledge Base, you can reduce the issue resolution life cycle for your organization. We are delighted to announce that we have brought in support for 'Knowledge Base articles' in the Zoho Desk iOS mobile app. This feature is already available for Android users. KB articles are available to iOS users in the latest version of the app (v2.4.9). You can update theDocument data extraction and import into CRM.
I've been trying to solve this for a while and I can't come up with a workable solution: In our business, we utilize many subcontractors around the world (without Zoho user accounts) to produce reports and client sites which they then submit back to usNotifications API - how to handle channel expiry
The Documentation doesn't give a lot of detail on how the Notification API should be used. Am I correct that I can only open a channel for a maxmimum of 24 hours? And once the channel_expiry date has passed, I will no longer receive notifications? WhatIntroducing 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 businessesSync Books quote value into Deal amount
I have books integrated into deals in CRM and I want to sync the quote value into the deal value automatically. Can anyone provide me some guidance?Can I add Conditional merge tags on my Templates?
Hi I was wondering if I can use Conditional Mail Merge tags inside my Email templates/Quotes etc within the CRM? In spanish and in our business we use gender and academic degree salutations , ie: Dr., Dra., Sr., Srta., so the beginning of an email / letterRepeat script N number of time with some incrementation
Hi, I have a script I want to repeat a certain number of time, depending on a value from a variable NumberOfDelivery, and at a certain frequency depending on a variable DaysBetween (wich would afect my addday function on the last line). Here is the basicZoho Books | Product Updates | April 2025
Hello partners, We’ve rolled out new features and enhancements to elevate your accounting experience. From FEC report to BillPay Add-on, these updates are designed to help you stay on top of your finances with ease. Export Transactions in Factur-X FormatFilter a report for a specific bank and a specific transaction type (interest income)
I am trying to run a report - any report - on a specific bank account for the interest income. I do not see it as an option. I can see the Bank Account under Account in the Filters, and I can see the Interest Income under Account in the Filters But IPin multiple columns and adjust column widths in CRM subforms
Hello all, Subforms act as secondary forms or tables in which you can associate multiple line items to a primary record and thereby ensure more structured and comprehensive data organization. We've made some recent enhancements to subforms. Here's what'sExchange Rate Updates
Hi, It would be great that when you work with multiple currencies, the exchange rate updates automagically every day (as seen on Zoho Books) or at least that when you create/update an opportunity the exchange rate could be manually updated, or maybe both!Add Video block needs improvement
I regularly send out links to videos in my campaigns and I find that built in video block is never good enough to use in my campaigns, so I have to make a thumbnail in Canva and upload it or screenshot the actual video on YouTube. The concept of the videoFunction #35: Close all tasks associated with a lead and create a new task.
Welcome back everyone! Last week, we learnt how to close all tasks of a deal depending upon the deal stage. This week, let's look at a custom function that lets you close all of the tasks associated with a lead while simultaneously creating a new task, like when you need to halt all progress towards a lead while the lead is not available at the moment but create a reminder task. Business scenario: The success of a company, in one way or another, is determined by the leads it gets. Each lead is justNo Teamspace found in CRM Sandbox
I created a new Sandbox and selected a custom Module I have admin role but still when I open the sandbox I get this, how can I resolve thisHow do I create a time field?
I want a field that only records time. I can only see how to create a date-time field. If I do that and enter a time, without a date, nothing is recorded. If I create a number or decimal field, I cannot use it in time calculations. All I want is a fieldMS Teams Meeting to Zoho CRM
Has anyone figured out a good way to push MS Teams meeting info on a trigger of "meeting end" to Zoho CRM? We're looking for a way to take attendees of a meeting and meeting duration and push it into Zoho CRM after the meeting has ended. If I can justRun automation on quiz completion
Hello, We're exploring Zoho Learn as a possible solution to creating some training courses to external users on our system. We'd like to run a workflow/ integration to Zoho CRM when a course is completed. Is this possible?MArking as NOT SPAM
I have just been checkign my SPAM folder and it seems that markign mails as NOT SPAM makes them disappear. I cannot find them in my mailbox with a search.Data Import validations
Hi, I currently have a CSV file download from a 3rd party SFTP server prior to performing the data transform. When we don't have any transactional data, a file is still uploaded by the 3rd party to the server, but it is blank. This causes the transformCustom Extension, create a trigger button in custom module to launch the app, or any workaround
Hello Have created a custom extension , publish as private, all working But I'm facing an issue For my test I create a button in accounts or Contacts module to launch the app. But how I can handle to create same button in a custom module (not createdNew Customization options in the module builder: Quick Create and Detail view
Hello everyone, We have introduced two new components to the module builder: Quick create and Detail view. The Quick Create Component It is a mini form used to create a record and associate it to the parent record from a lookup field. For example, if you have a Deals lookup in the Contacts module, then you can associate existing deals or create a deal and associate it with the contact. You can customize this Quick Create form by adding standard as well as custom fields. There is no limit to the numberHow to abort a report email schedule if query is empty?
I am needing a way to create scheduled condition alerts when certain criteria exist in our Zoho Reports databases. I don't want to send a report/alert email if the query/condition is nonexistent/empty. How would I do that with the Zoho Reports Scheduling feature?Can External users upload files or images to WorkDrive?
I want to know if it is possible for someone externally through a link and PW be able to upload files and images onto WorkDrive?Zoho Creator HTML Page
Hello Team, I have a query related to the HTML page I created in Zoho Creator. I would like to apply some filters on this page without passing them through URL parameters. Could someone please guide me on how this can be achieved? Thanks & Regards, PiyushTables for Europe Datacenter customers?
It's been over a year now for the launch of Zoho Tables - and still not available für EU DC customers. When will it be available?Payroll in Saudi Arabia
Zoho is a popular software platform that offers a wide range of business solutions, from customer relationship management to finance and accounting tools. However, one major drawback for businesses operating in Saudi Arabia is the lack of a payroll featureクライアントスクリプト 新規作成を禁止する
■概要 あまりニーズはないと思いますが、、、、Zoho CRM 程度作り込んで来ると「このカスタムタブのレコードは商談から Deluge でコピーしたものだけにしたい」と言う場面になりました。 レコードの新規作成は制御できない様でしたが、保存ボタンはクライアントスクリプトで無効化できることがわかりました。これを使って新規作成したレコード（各項目には何も値が入っていないレコード）保存できない方法をご紹介します。 出典： ZOHO CRM Client Script Disable Save Button【Zoho CRM】Deluge による自動番号の開始番号リセット
■概要 商談番号を「自動番号」フィールドで設定している際、年度が変わったら「開始番号」を 0001 から再度スタートしたい。 参考URL：https://help.zoho.com/portal/de/community/topic/resetting-auto-number-on-new-year ■対応策 「スケジュール処理」に以下の様な関数を組み込み、「自動番号」フィールドのプロパティ「開始番号」を自動で変更する。 ■実行環境 Zoho CRM Plus ■関数 ■関数の解説 ・invokeapiExploring the Red Robin Food Menu — Need Your Favorites!
Hi everyone, I’m diving into the Red Robin food menu lately and it’s honestly overwhelming (in a good way!) with all the choices — from gourmet burgers to bottomless sides and seasonal treats. 🍔🍟 Since this is such a helpful community (and after checkingOpen a popup window from inside Record A and stay on the record after saving Record B
Hello community, Perhaps you can help me with the following topic. I have a form A with a decision box. When this decision box is checked, a form B pops up. Once Form B is saved, I need to stay on Form A to continue entering data. I've observed the followingZoho CRM API, Python SDK v7 Quoted_Items
Hello. How do I use this SDK to retrieve the Quoted_Items from a Quote and downstream the items in a Sales Order I can see references to a constant INVENTORY_MODULES_ITEMS = ["invoiced_items", "quoted_items", "purchase_items", "ordered_items"] But I cannotAssign default Location + warehouse to Customer / Vendor
Hello there. With the introduction of Locations I'm having to enter the warehouse for every single transaction which is getting really tiring and causes errors (easy to fix, but still). Does anybody know if there's a way to assign a default Location andIMAP Connection Issue – "Disconnect called before connection setup" (Zoho + Freshdesk Integration)
Hello, Since April 25, 2025, we are facing a critical issue with our Zoho Mail integration with Freshdesk. Incoming emails are no longer being received in Freshdesk. Freshdesk Support has confirmed that their system is trying to connect to our Zoho mailbox,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 theNext Page