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?
Zoho Sheet - Desktop App or Offline
Since Zoho Docs is now available as a desktop app and offline, when is a realistic ETA for Sheet to have the same functionality?I am surprised this was not laucned at the same time as Docs.
Transitioning FESCO Bill Project to Zoho Sheets and Integration Options
Hello Zoho Support, I'm considering transitioning my FESCO bill project from Google Sheets to Zoho Sheets and wanted to know if there are integration options to seamlessly migrate our existing work. You can view our platform here, any guidance would be
Suppress "spreadsheet will not be saved" message on published sheet
I have published a sheet and have one column on that sheet that the user can edit (a dropdown picklist where the user can select the status for each line). Is there a way to suppress the Zoho Sheet message "Any changes made to this published spreadsheet
Can we share the URL of My zoho Sheets on other websites?
Hello everyone? I have sheets on Zoho and I want to share them on other websites like daraz, homeshopping, gepco duplicate bills, etc. I don't have much knowledge about online sharing question forums? I am a student and have a short survey about online
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
can I use zoho sheet for survey?
Hi I wanna use zoho sheet for my ARY to know consumer better so i wanna have permission to do so
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.
Always Match Destination Formatting while Pasting
How do I always match destination formatting when pasting in Zoho sheets?
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
Sheet Access
How do you set a spreadsheet to only allow certain people to access certain sheets? Like if I wanted to have someone view one sheet that pertains only to them, they can't see the other sheets on the spreadsheet while allowing someone else to view theirs but not others.
Zoho Sheet for Desktop
Does Zoho plans to develop a Desktop version of Sheet that installs on the computer like was done with Writer?
Collaborators are not able to upload images
Good afternoon, We have a sheet with 2 current collaborators and when they try to upload an image , a pop up comes up ' server error, there was a problem saving your last edit. Please try again' Can you kindly assist?. Thanks, Annrica
Is Zoho Sheet available for Mac OS ?
Is Zoho Sheet available for Mac OS ?
VBA attached to button no longer works on external shared sheet
Hi - we have a Sheet that our clients use, which requires them to press a button once they've entered data. The button then triggers a flow via a webhook. The button works fine when editing within Zoho Sheet - however when shared externally it no longer
Create QR code in Zoho Sheet
Hello, Is there a way to generate a (permanent) QR code in Zoho Sheet? Thanks in advance! Jurgen
Zoho Sheets not compatible with Excel/Google Sheets
In order to share a copy of a Zoho sheet with someone that does not use Zoho, it must be downloaded as MS Excel format and then added to an email. This is a labor intensive, and frankly confusing process. I have forgotten to do this before, only to
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
VBA/Macro, Transpose
Hi everyone! I am trying to transpose the highlighted or any selected row from "Raw Data" to "View". However, whenever I click the button, it will just copy the A1 cell in Raw Data and not the selected Row. Can someone help?
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 get NSE/BSE Stock Prices in Zoho sheets?
I've been looking for a function that provides me with the NSE/BSE listed stocks price in Zoho Sheets like GOOGLEFINANCE in Google sheets, but I found none. Please help if there is any way to het stock prices?
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
No option to change the ownership of the zoho sheet
In zoho sheet app there must be some option to change the ownership of the sheet , even super admin also does not have any such option available. Community what's your views on this ?
Shapes, arrows and other similar components in Zoho Sheet
Hi Team, Do we have shapes and arrows in Zoho sheet or Is there any plans to release it to the Zoho sheet?
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.
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 that
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?
Is Zoho Sheet available for Linux ?
Is Zoho Sheet available for Linux ?
Next Page