Introducing 15 new Zoho Sheet functions
Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient textRequest for access
Hi everyone. Please help me. When I try to access a spreadsheet that a friend sent me by link it doesn't open, it says I'm not authorized to access the spreadsheet. Please help me. Thank youWill Zoho sheet continue after March 15, 2023?
Hi Team Zoho. I heard that zoho docs will be discontinued after March 15, 2023. I just want to make sure that it is zoho docs but not zoho spreadsheet. Please clarify. Thanks.Can Zoho be accessed/used in China?
I'm looking for an alternative to Google Docs (Spreadsheet specifically) that can be used in China. Can Zoho be accessed by users in China?#CIRCULARREF!
How come im encountering #circularref! error. i double checked the formula but they are correct. It seems that the synchonization to the server has an error. Thank youPerform customized calculations with the new LAMBDA functions!
We released the LAMBDA function in Zoho Sheet in 2021, enabling customized calculations inside predefined functions. Now, we're extending LAMBDA's capabilities with six new functions. Each of these functions applies LAMBDA to the given input, performsDate Format - YYYY-MM-DD
Why in the work would Zoho Sheets not support the date format YYYY-MM-DD - pretty universal - no confusion - and especially for data in a spreadsheet - can be sorted properly Blows my mind that this setting does not exist, or I can't find how to turnSheets date format dd-mm-yyyy - time, it seems, is at war with me.
Hi, I'm trying to set the format of a column to the date format we use here: dd-mm-yyyy. Unfortunately, this format does not show up in the options. There's no specification in Settings to specify it either, I can't seem to set a custom format, and whileCustom fonts are not exported in PDF
Hi! When I download my spreadsheet, the custom fonts I uploaded and set are all replaced by the fallback fonts. Why is this happening? I hope this can be fixed.Issue with API worksheet.records.add
Hello I am having an issue with using the method "worksheet.records.add" I am currently getting a 400 error. As a note, I have successfully gotten an access token (and get a new one every time I start a new session) and have successfully been able toNamed ranges will disappear from the sheet
I encounter this when attempting to delete one or more named ranged from the defined names in the management box. It's hit or miss; some range names that I deleted several times, keep reappearing and others that I wanted to keep will be deleted. WhenThe opposite of QUOTIENT or a non-destructive alternative?
I hope I'm not asking a too dumb of a question, but I'm trying to use the equivalent of DIVIDE, which according to the Knowledge Base is QUOTIENT. However, QUOTIENT seems to round the numbers down, as if it had ROUNDDOWN applied natively to the result.Unable to share a sheet.
Hi, i was trying a sheet with some of my collogues, they are registered on Zoho sheets with their email still when I try to share the sheet I get the following error. Share with non-Zoho user? You are about to share this file with @gmail.com who doesData Entry Form?
https://help.zoho.com/portal/en/kb/sheet/working-with-forms/articles/create-a-form-in-zoho-sheet Is it still possible to create a data entry form using ZOHO Sheet? I referenced the link above and I d o not see this option? ThanksCan I share my Zoho spreadsheet with others
As a data entry professional, I utilize Zoho for my work and I'm interested in knowing if I can share my Zoho spreadsheet and database with basketballist company. If so, I would like to know the steps involved in accomplishing this task. Any guidanceRestrict access to one spreadsheet
I have a file with three sheets . Each sheet is for a particular individual to enter data. how we restrict the user to view the other individual sheet except the ownerwhat is the zoho sheet formula equivalent to this google sheet formula?
In the google spreadsheet this is what I have I have forumula in column K: =unique(B2:C) Then I have formula in Column M: =map( filter(K2:K, len(K2:K)), filter(L2:L, len(K2:K)), lambda( model, trim, torow(filter(C2:G, B2:B = model, C2:C = trim)) ) ) WhenDisable download, Save As and copy option in sheets
Hi I am a free tier user. I was just testing out Zoho sheets for my use case. I wish to move my data from Google sheets to Zoho sheets. The problem is when I share a sheet with view access only to other user who has a private email like gmail, hotmailOffline Editing and Access
I can't seem to find how saving your sheets offline works. I don't see a button for it anywhere.zoho sheet - How do I create a list of values to choose from in zoho sheet
I want users to choose only a value on a list of items (as you can do in Excel). Can I do this in zoho sheet?Putting Watermark on Zoho Sheet
Can this be done?Scatter graph when x-axis is time becomes a line graph/chart
The difference between a scatter graph and a line graph is that the x-axis should be mathematical. Ie if the X data points are 1,2,4 , the '4' should be 2 intervals away from the '2'. On a line graph, they would be next to each other and equidistant toIs it possible to share my Zoho spreadsheet?"
Hello everyone, I am a data entry professional and I use Zoho for my work. I would like to know if I can share my Zoho spreadsheet and database with a wordparadox company. If so, how can I go about doing this? I appreciate any insights and advice. ThankTip #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.Editable sheet but can not distribute, save or email or etc...
Is this possible? I want the file to save in its existing location. But not for the user to be able to save a copy etc... this is disastrous. Is this possible? I can see that this has been asked in various forms up to 9 years ago and as far as I can tellImages Stored in Zoho Workdrive not displaying in Sheet after putting the image URL
I have generated a form from which images are uploaded onto zoho workdrive & the image URL is stored in a ZOHO Sheet. Now when i try to Display the image it shows a broken image link. When I try to go insert Image from the insert from URL, in the dialogHow to add a Trendline to a chart inside sheet?
Hello Zohos I am very please with the improvement of Zoho Sheet since I used it last time Im still missing one thing that I easily have access to in MS excel : Add trend trend line I found a way to calculate the regression line by: =FORECAST =SLOPE =RSQ But I'm pretty confused how to get the line on the chart with the data. Are there any solution to this?Introducing Forms in Zoho Sheet
We hereby bring you the power of forms in Zoho Sheet. Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether youWe'll be right back - URGENT
Hi, It has been like this for hours. Some sheets load and some don't. Sometimes the sheet opens, but it's empty. Thank you!Zoho Sheets Outage - We'll be right back
It has been like this for hours. I tested multiple sheets.Can I generate a PDF from a worksheet through API?
Hello, I'd like to use the Sheet API to inject data into a worksheet and then export that worksheet as a PDF. Is this possible?IMPORTRANGE not working
I am getting a #NAME! error when trying to use the IMPORTRANGE function.Collaborative spreadsheets on your smartphone.
Waiting till you're at your laptop to get your work done is a thing of the past. Stay on track with the mobile world with the Zoho Sheet app for iPhone, iPad, and Android devices—watch the video. Now you can: View and access all your spreadsheets—both owned and shared. Perform calculations in a snap with more than 350 functions. Visualize data with charts and conditional formats. Share and collaborate in real time with your team. Distribute files with shareable links. Insert hyperlinks, checkboxes,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 yourwhat's the equivalent of the "format as a table" function from excel in sheet?
I use this all the time in excel is there a quick equivalent function?zoho mail body sheet is not open
In zoho mail body any sheet not open as the box come ," something went wrong ,please try opening file again ".VLOOKUP in another file
Dear Zoho Sheet Team, I've been trying to find the way to use VLOOKUP() in another file (as OpenOffice and MS Office can) and haven't find yet. Is it possible? I tried this, for example: =VLOOKUP(A1;'one'$Sheet1.$A$1:$F$500;2;0) Thank you.Zoho Sheet Save To PDF Cell Border Has Broken Lines
Hi Folks! I have some cells where I put borders around them. However when I save them to PDF, I see broken lines on some of the cell border. Is there anyway we can prevent this from happening? See picture attached.WHAT DOES #TIMEOUT MEAN IN ZOHO SHEET
Hi. I've been organizing some sheets required for our work and been using formulas for it. the first one was working, however, when I was doing it to another tab in the sheet the #timeout keeps on showing up when I have the right formulaZoho Sheets Auto Updating Capabilities
I was wondering if Zoho had the capability to do this or not - I would like to put up our local television studio's TV Schedule online on the website I am creating for it. The scheduler program makes a .lst file which can be opened up in Microsoft Excel after doing an import wizard. I was thinking of writing a script for Excel to auto import the schedule once a day and save it as an .xls file. Then I was hoping to import this schedule .xls into Zoho Sheets, so I could embed the spreadsheet intoNext Page
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
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 Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the FormatAnnouncing Zoho Sheet's monthly webinar series
Hello there, At Zoho Sheet, we always strive to help you maximize your product experience. Hosting webinars has been one of the key ways for us to communicate product updates, share best practices, and engage the user community. To help you convenientlyIntroducing Dynamic Array Formulas to Zoho Sheet
We're happy to announce that Zoho Sheet has opened up the new dynamic array formulas to all our users! The addition of dynamic array functionality will make your spreadsheets and the formulas you use in them a lot simpler, while at the same time makingTip #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-relatedEdit History: Prevent data loss during collaboration
With teams moving to hybrid workplaces, remote collaboration has become routine. Zoho Sheet simplifies collaboration for distributed teams with user-specific access levels for file sharing, contextual commenting, and real-time editing tools. It also provides
Most Discussed Topics
Format change when Filtering
I have a large list of medical claims in a Zoho Sheet. Column A contains a picklist to update the status of each claim. Normally this works wonderfully, but lately, when I filter for a particular patient (or service, insurance company, etc), then workIssue with TEXT Function and Displaying Day of the Week (Zoho Sheets)
Hello, I'm using the formula =TEXT(DAY(A1);"DDDD") in Zoho Sheets to display the full day of the week for a date in cell A1. However, when I enter a date like 2/7/2024 (MM/DD/YYYY), the formula doesn't return the correct day (Wednesday in this case).Zoho Sheets Filter Issues
I appear to be having ongoing issues with my filtering in zoho sheets. Occassionally random cells will not filter in accordance with the rest of the sheet. Usually I filter by time, and then date - this allows the full sheet to order by correct date &Zoho Sheet and Zoho Flow integration
Hello, I have integrated a spreadsheet with two worksheets with Zoho Flow. The trigger 'Row created or updated' works well if I manually update the worksheet. However, I have enabled a macro through a button in one of the worksheet to modify the worksheetVBA to automatically update the current date.
Hello, I'm looking to have a VBA to keep the date of the day automatically updated without having to refresh or openmy Zoho sheet. I've tried this but it doen't work, can you please help? Here is what I tried: Sub date_update() Range("H1") = Date Application.Calculate
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Zoho WorkDrive Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Sticky Posts
Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the FormatTip #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-relatedFormat and analyze spreadsheet data with Zoho Sheet's Table
While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,Introducing Data Bars: Graphically represent changes in data within the cells
Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient methodZia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes
Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,
Top Contributors
Narendra Eswar G
Joel Biju
Anouncia P
Vinoth Kumar K
Lindsey