Cannot Print Landscape with Zoho Sheet
I am noticing that when using the Zoho Sheet desktop for Mac, that even when selecting landscape as the print option, once you choose "Print", a second system dialog opens that automatically makes the view portrait again, and does not allow printing inPick List Issues
I have created a pick list that looks at a table in a sheet, it selects the column I want fine. Various issues have come along. The option to sort the pick list is simplistic, only allows an ascending alphabetical sort. Bad luck if you want it descending.Published sheets don't work anymore
Hi, Published sheets don't work anymore. The display of values is very very slow and calculations are not displayed at all. Thanks!Formatting of cells changing by itself and formulas not always calculating automatically
I'm new to Sheets and have been setting up a budgeting template that has many linked tabs. It's going fairly well except certain quirky things have been happening from time to time. 1- sometimes when I scroll up or down I lose formatting from a randomPublish a single Sheet stopped working
I used to have a published sheet on my Zoho Spreadsheet and that stopped working. If I want to publish it again, I only get the message that says "Published externally", but that does nothing, and if I change tabs and come back, the sheet gives me theSTOCK function showing #N/A! even thought the Stock symbol is valid
Zoho Team, I use STOCK function on Zoho Sheet to fetch the recent Last Closing Price. Some stock symbols are valid but when the STOCK function is applied, it shows #N/A! Attaching an image for reference.Sheets are unbearably slow
I'm doing some extremely simple sheets. Like 2 sheets each with 200 lines and 10 columns and a simple vlookup. ABSOLUTLY can not wait 20 secs to flip between sheets. What's up? anyone else having this trouble? Been this way for about 4 days now. BothIMPORTRANGE Spreadsheets
I am trying to importrange a spreadsheet into another, but an error keep appearing saying NOT LINKED. Noting that I've linked it. I've tried to publish both sheets and re-apply the formula many times but nothing is working. I don't know what can I doSearch function in Zoho Sheet mobil app on android - not working
Hello, Im new here and registered for Zoho Sheet. Than i installed the android mobile app on my tablet (redmi note pro 5g). But I cant use the search function for my added excel table. When I use the web version for zoho sheet with the same imported tableAn edit in Sheets is not being updated in CRM
An edit in Sheets is not being updated in CRM. Does the Sheet need to be manually re-imported?inability to apply filter on zoho sheet
I've been unable to apply filter on zoho sheet for the past two days..please help outUrgent: Server Error & Broken Files in MS Office
Hi, We have attempted to reach you multiple times via chat, email, and this platform but have not received a response. We are experiencing the following issues: When opening a document for editing, we receive a "server error" message (see attached screenshot).Zoho Sheet import error
The error "Sorry! Couldn't import the spreadsheet. Please try again later." appears when trying to either of the attached spreadsheets, and I'm not sure what the reason is.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, AnnricaData 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 checkedAnyone 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.zohosheet keep loading and don't know how to fix it
one of my zoho sheet is getting slow. How to fix it.How to Avoid Impacting Other Users When Hiding Columns in Zoho Sheet
Hi Team, We’re experiencing a challenge with the column-hiding feature on Zoho Sheet during collaborative sessions. When one user hides a column, it becomes hidden for all users working on the file, which disrupts others' workflows. In comparison, ExcelRecent 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 reportCredit 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?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, statusVBA 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 longeri cant find my spreadsheet data
i cant find my spreadsheet data on zofo sheetChanging 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 workingOpenAI 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? Thanks1 Sheet was delete , How to recover?
Dear Authority , Hope you are well. I have face the problem when was opening the Zoho , Suddenly delete or missing the one sheet unfortunately for share the picture for demo. Need this missing file . It's very important file . How can I recovery thisGridlines disappeared
Gridlines disappeared on sheet. If i add the gridlines again, then close the sheet and reopen it, the gridlines are missing again.formulas don't work
Good afternoon, the formulas in the table do not work, I can provide access and screenshots if necessary=COUNTIF - formula issues - when value shows in one cell, show certain value in another cell
Hello, I have used "=IF(COUNTIF)" formula successfully in one workbook to look to see if cell D15 contains "plasterboard - 2.4m" and if it does to show "2.88" in cell E15. I then managed to add additional keywords to look for which would display differentCan't View Embedded Sheet From Mobile Devices
I've embedded a portion of a sheet as an iframe to html. It works perfectly on my computer. But when I try to pull up the same page on my phone, regardless of browser, a message comes up that says "Sorry! There's a problem with the server. Please tryZoho 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 worksheetZoho 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 &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 workData Validation Rules dissapear for no reason
I set up all my data validation rules in zoho spreadsheet, and now this is the 3rd time that they have dissappeared!! Every Single data rule i set up! Why does this happen? Is this a bug? Im getting really tired of having to redo it every timedrop down dv not working with table
I've decided to swap out my working DV sourcing a cell range, to a table. I table create the data and redo the DV. I select the source data and it automatically loads "Table 11" into the DV box, but when completed there is not drop down arrow at all inWith what formula can I find the last month of the year?
Hello. You did what Google did not do. Firstly, thank you. I turned the Google sheet into a Zoho sheet. With which formula can I find the last month of the year and the last month of the previous year? Now an incorrect result is coming. For example, forHow to reference cells from another workbook
Hi, I just like to ask for help on how to reference a cell from another workbook. Thank you. HarroldRed dashed line around cell
I have a red dashed line appearing around a cell. It does not go away when I clear formatting and I'm not sure how to get rid of it. The formula in the cell is quite simple and the cell is displaying the correct result. The outline also persists if IList Range In Zoho Sheets Data Validation
Hello, I have 2 worksheets "Sheet 1" & "Sheet 2". I want to set data validation in Sheet 1 but using a named range for the drop-down list. I have set a dynamic named range CSID "OFFSET(Sheet2.$A:$A;0;0;19999;0)". I tried typing in CSID in the list or cell range but it didnt work like Excel. Please help, thanks.Zoho API accessing another drive which is not mine
I used my email to register my organization on zoho, I want to access my sheets with zoho api. But it's giving me the files in the organization workdrive instead of my personal workdrive. Since I used my email to register the organization, there are duplicateNext Page
Access your files securely from anywhere
New to Zoho Recruit?
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
Import your Google Docs Spreadsheets into Zoho Sheet
You can now import your Google spreadsheet into Zoho Sheet. This will be useful if you want to switch to Zoho Sheet or if you want to simply try out Zoho Sheet. If you don't have an account with Zoho, you can still try this by signing in with your Google account. Here is a video on how to do this. Note: Existing charts won't appear in spreadsheets you import from Google Docs as the Export functionality of Google Docs doesn't give out the charts. Check out the announcement in our blog: https://blogs.zoho.com/general/import-google-docs-into-zoho-productivity-suiteIntroducing 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 youMeet the latest feature of Zoho Sheet: Lock Cells
We are happy to announce the release of one of the most awaited features in Zoho Sheet. You can now lock the cells that you wish to keep secure. Once you are done with editing cells, you can lock them so that they won't be modified anymore. We believe that this feature will be a great addition to our existing set of collaboration features and is intended to improve your collaboration experience. You can access this new feature Lock from Data tab. Apart from being able to lock individual cell ranges,New features released: Data from Picture for Web, Pattern Fill, and Translation in Zoho Sheet!
Hello Sheet users, In 2024, the Zoho Sheet team focused on research and development to bring new features that add to functionalities like productivity, data management, collaboration, and more. This year, we're all set to roll them out incrementallyFeature enhancement: Highlight rows based on a cell value
Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw
Most Discussed Topics
filter broke my data
I uploaded a file recently from Sheets and it has top 2 rows frozen, with table headers in second row and each one is filterable. somehow my first 2 columns became unfiltered and no matter what I do I cannot reapply the filter?? also didn't realize theycustom color palette for picklist in Sheet
Migrating over from Google Sheets and missing the ability to customize the individual item colors of my picklist/dropdown menus. Is this something that is possible? A search showed me creating a custom color palette in Analytics is possible but I am not
Zoho Developer Community
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
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
Zoho CRM Resources
Sticky Posts
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 youMeet the latest feature of Zoho Sheet: Lock Cells
We are happy to announce the release of one of the most awaited features in Zoho Sheet. You can now lock the cells that you wish to keep secure. Once you are done with editing cells, you can lock them so that they won't be modified anymore. We believe that this feature will be a great addition to our existing set of collaboration features and is intended to improve your collaboration experience. You can access this new feature Lock from Data tab. Apart from being able to lock individual cell ranges,Feature enhancement: Highlight rows based on a cell value
Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to drawRevamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.Slicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,
Top Contributors
Vinoth Kumar K
Murugalakshmi S
jennifergordon1021
Actify Team
Narendra Eswar G