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 you
Perform 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, performs
Sheets 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 while
Custom 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 to
Named 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. When
The 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 does
Data 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? Thanks
Can 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 guidance
Restrict 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 owner
what 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)) ) ) When
Disable 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, hotmail
Offline 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 to
Is 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. Thank
Tip #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 tell
Images 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 dialog
How 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 you
We'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 your
what'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 formula
Zoho 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 into
Spreadsheet Formatting Issue On Ipad / Iphone
Hi Folks! Need some help here. My spreadsheet is formatted nicely, i.e. the width and height of the cells were adjusted so I can see all the information in the cell at one glance on the desktop version. However when I open the spreadsheet on ipad or
Share a Sheet template
Hi I would have create a spreadsheet which I would like my organization to be able to access. I have added it to the Org Templates. However when a user goes to "New from Template". Choose "Org Template" Then clikc "Use" on the template, nothing happens.
can I rename a spreadsheet with VBA in zoho sheet?
I know that I can rename the spreadsheet (ie the whole file) by clicking on the title in the GUi and renaming it. And I know when I am in the list of all spreadsheets, I can rename it using the menu, eg the context menu. But I would like have a VBA macro
Setting row limit to my colleague
I have csv files which i will be uploading to zoho sheets and will share with my co worker/staff and give them access to edit, they can either remove and replace with new data but they are not allowed to add new rows to what limit i set. For example i
Next Page