Data not visible in sheet cells
I'm having an issue where my data is not visible in my sheet cells. If I click on an individual cell, the data does display above in the little "fx" box. But all the boxes in the sheet just look blank. My collaborators do not have this issue. I have checked
use of comma as a decimal separator
Hello, I wish to find a way to customize the number format for my proper use. I have to use french data, where the "," is used as the decimal separator : for example the french way to write "3.99�" is "3,99�" Is it possible to do it in Zoho Sheet ? If this is not actually the case, I'd love this feature to be implemented !
Zoho Sheets hide or unhide columns. How it impacts other users
Hi I would like to know, when someone hides a column in the Zoho sheet, the hidden column is also hidden from everyone else that is using the file. The collaboration feature seems to not work.
Always Match Destination Formatting while Pasting
How do I always match destination formatting when pasting in Zoho sheets?
Set print area
Is there a way to set the print area like I can with Excel
How to concatenate to make clickable url?
Hello, When I type url in cell it automatically creates hyperlink. Now, if I CONCATENATE two cells like this A1:http://www.domain.com/ B1:blog to make C1: http://www.domain.com/blog it doesn't create a clickable link. Why not?
Anyone else having a problem with the macros?
After I have made a macro and saved it, I went to the manage section, but it does not show the macro (or any macro) I've made. Suggestions or solutions would be much appreciated.
The server is unable to handle the formula cells in your spreadsheet
The above warning has come up on the top of my screen. I can't find how to find out what formula is the issue. There is a lot of data in the workbook, are there any limits to the data. I can remove rows if needs be I just need to balance the amount of
zohosheet keep loading and don't know how to fix it
one of my zoho sheet is getting slow. How to fix it.
SUMIF with "=" condition giving #NAME! error
I have =SUMIF(H21:H27;=&B55;I21:I27) which is throwing an error. Have tried =SUMIF(H21:H27;=B55;I21:I27), =SUMIF(H21:H27;"="&"B55";I21:I27) and =SUMIF(H21:H27;"=B55";I21:I27)
Workbook Open Trigger executing twice
I have some simple VBA code in the Open trigger for a workbook that increments the open count so I can track how many times a workbook has been opened. However, it appears that it is being executed twice whenever the workbook is opened, as the count gets
Data overlapping error - data connection schedule
Hello, I created a spreadsheet and connected it via data connection to zoho analytics, asking to fetch data monthly from a table in analytics. I want the data in the spreadsheet to be replaced each month with the newest data in the analytics' table. Each
Zoho Sheet - Conditional Formatting - Formatting the entire row
How can I apply formatting to an entire row based on the text value in one cell? I tried it, and it seems to work on that cell itself.
Recent Maintenance
Dear Zoho Sheet Team The recent 'Improvements' gave me considerable problems. I can't evaluate the extent of these problems, they could range from fixable to disastrous. I can't check more then 300 sheets quickly. A lot of my images have suddenly disappeared, this seems to be the major problem. Where have the gone and how can they be recovered? Another thing I noticed - you have taken away the 'SAVE' button. Clicking on 'FILE' doesn't give a 'SAVE' facility either. I will keep working and report
Credit Limit Exceeded in Zia
When I enter any word, sentence, phrase... anything into the AI Bot question box, the only "answer" I get it is "Credit Limit Exceeded." I'm using a paid version. I cannot even search a single word. It gives the same reply. What credits?
Grouping rows in Pivot table
Hi, I have created a pivot table with months and total sales for 4 years month on month. I want to group the rows to make it year on year and see the sales number. The option is not seen but it is not highlighted hence I cannot group it. Kindly help.
Set-content-to-row API Call Error
Hello, I created a custom function to set content to row, however, I got the following error. {
error_message : "Internal server error. Please report this issue to support@zohosheet.com",
method : "row.content.set",
error_code : 2866,
status
Is Zoho Sheet available for Mac OS ?
Is Zoho Sheet available for Mac OS ?
Create QR code in Zoho Sheet
Hello, Is there a way to generate a (permanent) QR code in Zoho Sheet? Thanks in advance! Jurgen
i cant find my spreadsheet data
i cant find my spreadsheet data on zofo sheet
Changing the ownership of the zoho sheet
In zoho sheet there is no option for the super admin to change the ownership of the zoho sheet if that sheet has created by different user in the organization. Recently one of our employee has left the organization and she has created some client working
How to get Filename in Zoho Sheet using Macros
Hi Guys, I wanted to pass filename as a parameter to custom function. I tried to get file name with in built CELL function, but it doesn't worked. I think using macros we can get filename. So please help me to resolve this. Thanks in Advance Regards, Termcon
Can't Edit Unlocked Cells in Embedded Sheet (Calculator)
I've had an embedded Sheet for several years that allows visitors to my website to input their info and see the results (calculator type application). It is understood that the changes aren't saved on my original copy. I've made some updates to the Sheet
Is it possible to display formulas in cells instead of calculated results?
I want to export my Zoho sheet as tab separated text without losing the formulas. In excel, I would use the settings Options - Advanced - show formulas in cells instead of their calculated results then save as tab separated values. How do I do this in
Error in Safari
I have embedded my spreadsheet on my web page its shows fine in google chrome and firefox but it gives and error in safari it reads "cookie is disabled in your browser. please enable the cookie [?] and reload this page" but cookies are enabled in my browser.
Make Zoho sheet clears cells automatically?
I have a sheet I use to calculate prices and other data. I want the sheet to automatically clear the data in A3:A100 either when opening or when closing. Is this possible?
Currency Invalid Symbol
Hello everyone! The formula is correct! =CURRENCY(1;"USD";"BRL") Why does the value appear as invalid symbol?
Run macro automatically/on a schedule
I have a macro that I would like to run automatically in Zoho Sheet. However, I do not see any way of doing that. Has anyone got an idea on how to do that? Kind regards
How to integrate the zoho sheets with your Application
Hello Zoho Developers, Here are some tricks and ideas for Zoho Sheets. Zoho sheets. Zoho Sheet is an online spreadsheet application that's part of the Zoho Suite. It allows users to create, edit, and share spreadsheets in real-time, similar to other spreadsheet
Zoho slow
i am eko in indonesia. i have 20 users under my corporate account. i recently experience slowness when open zoho sheets. is there any problem
Can't scroll the page down unless I refresh the page
Hello, This issue has been going on with me and a lot of other users in my organization, we can't scroll down! the scrolling side bar doesn't appear and scrolling down through mouse or keyboard keys doesn't work, it seems that the page just ends in the
Lets increase the 25MB Limit of spreadsheet file size to at least 50MB.
Lets increase the 25MB Limit of spreadsheet file size to at least 50MB.
When might we get "advanced" range, sheet locking?
I need more thorough locking capabilitiies, most importantly ability to lock a sheet from structural changes. Any plans for more locking functionality?
Themes in Zoho Sheet: Keep your spreadsheet's formatting consistent
Formatting a spreadsheet is now even easier with Themes. With Themes, Zoho Sheet empowers you to select, customize, and apply a uniform formatting style throughout the entire spreadsheet. When working on a data set with collaborators, you might notice
Users having trouble accessing shared Sheet
Hi, Some of my users are having problems accessing our Sheet. When they use the link sent in the original invitation email, they can get to the shared sheet with no problem. When they log into Zoho without using that link, the sheet doesn't appear in their shared folder. Any suggestions would be appreciated!
How can i set Multiple Owner?
How could i set multiple Owner (all writers) to a sheet? All "writers" want to have a change email if one writer changed the sheet
Multiselect Pick List items not showing in CRM data fields
I'm creating a Zoho sheet and using the Data Connection to connect to the CRM. This is working well except for a couple of fields that do not show up in the data connection field list. The two that are not showing are listed as "Multiselect Pick List".
OpenAI issue
Hi, I've tried to enable OpenAi in Zoho Sheet as in this article Simplify your spreadsheet tasks with ChatGPT integration | Zoho Sheet Help Guide but I get this error below in the AskZia console: Credit limit exceeded. Any ideas? Thanks
Occurrences in rows
Hi all, need some advice! I have the table below with details on the attendance of people at a class. What I want to do is to add up how many people (ID) have been in attendance anytime in the last 5 months measured from May. Note this is not how many
Date 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 turn
Next Page
