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 beHow 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, TermconVBA/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 SheetIs 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 inError 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 regardsZoho 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.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 spreadsheetZoho 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 problemCan'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 theNo 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?Is Zoho Sheet available for Mac OS ?
Is Zoho Sheet available for Mac OS ?Always Match Destination Formatting while Pasting
How do I always match destination formatting when pasting in Zoho sheets?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.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 thatWhen 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?Zoho Sheet for Desktop
Does Zoho plans to develop a Desktop version of Sheet that installs on the computer like was done with Writer?Is Zoho Sheet available for Linux ?
Is Zoho Sheet available for Linux ?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 noticeUsers 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 sheetMultiselect 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".Conversion of functions from Google Spreadsheets
Hello! I use this formula "=QUERY(ResumoOrdemVencimento!A3:O38;"SELECT A,B,C,D,E,F,G,H,I,J,K,L,M,N,O WHERE C != '' ORDER BY C,G")" in Google Sheets but when importing my spreadsheet into Zoho Sheets the formula was not converted. The QUERY function brings data from another spreadsheet, and then I sort and apply conditional formatting. The order of data will change automatically as I update the source spreadsheet. What Zoho Sheets function is equivalent to QUERY? I have some other spreadsheets toOpenAI 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? ThanksOccurrences 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 manyDate 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 turnSlicers 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,How do you debug formulas in Zoho Sheet?
I have a workbook with a lot of extensive formulas. Debugging them is awful. Are there tricks I'm missing? I don't think you can step through or F9 like Excel, correct? I would love to hear everyone else's thoughts, tricks etc.1 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.Open with Options
Hi Need Help. A file (Spread sheet or word / zoho writer) that is shared with me gives me an option to open with (web / desktop) options. However, it is not the same with all the files. What is the general behavior and how can I change it? - Regards,Sheets: Tags, labels or multiple pick list items in a cell
Is there a way to list multiple items (tags, labels, etc.) from a picklist or similar tool into a cell? I am doing a repetitive step during an audit/reconciliation process of having to manually write in different nomenclatures on multiple lines for multipleformulas 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 differentOur pivot tables just had a pivotal update!
A pivot table can help you summarize rows and rows of data in a single table. This means you are readily provided with the insights that you need from your data. Zoho Sheet has now made this process a little more easy with the new pivot table enhancements like auto-refresh, auto-expand and has made it possible to experiment a little as you create your pivot tables. Keep working on the data; we'll keep up with you! Here's a classic issue with the traditional pivot tables. You'll have to keep refreshingNext 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
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 thatThemes 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 noticeSlicers 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,Our pivot tables just had a pivotal update!
A pivot table can help you summarize rows and rows of data in a single table. This means you are readily provided with the insights that you need from your data. Zoho Sheet has now made this process a little more easy with the new pivot table enhancements like auto-refresh, auto-expand and has made it possible to experiment a little as you create your pivot tables. Keep working on the data; we'll keep up with you! Here's a classic issue with the traditional pivot tables. You'll have to keep refreshingCheck 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 Format
Most Discussed Topics
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 SheetTransitioning 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 beMake 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?
Zoho Developer Community
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
Zoho CRM Resources
Sticky Posts
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 thatSlicers 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,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,
Top Contributors
Anouncia P
Narendra Eswar G
Tony Trabucco
Pawan
Balaji V