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 regardsIs Zoho Sheet available for Mac OS ?
Is Zoho Sheet available for Mac OS ?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 spreadsheetAlways 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!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.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 thisShapes, 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?Gridlines 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 necessaryCan'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 visible area, to correct that we just have to refresh the page so the scrolling side bar would appear and then everything works normal, it never happens in a list like candidates' view, clients, contacts or interviews it mostly happens when adding=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 refreshingHow to create “Table” in Zoho Sheet (and adjust colours) on iPad?
I am trying to figure out how to create/define table in the Zoho sheet app on iPad. Mainly so I can adjust colours/have alternating row colours. The format menu just doesn’t exist?!Excel Answer to Zoho, it seems
I can’t edit zoho spreadsheets in chrome on my mobile, period. They were created on my laptop with no collaborators. I’ve installed ZS app on my mobile, and I can edit but all of the DVs are corrupted - intact but in the wrong places. I am very frustratedHow to make some cells invisible to some users
Hi there, I am collaborating with some colleagues and would like to hide some of the information in our shared spreadsheet (a few cells - not rows or columns). Would love to know if it is possible and how. Thanks, O-RenCreate a missing values LIST after using the "find missing value" function.
Zoho sheets data cleaning does a great job of finding missing values function when comparing two columns. But then it wants to fill in the columns that are missing. What I want to do is create a LIST of the missing values in a separate column. Make sense?hide zero values
Excel has a feature where you can show or hide zero values for each worksheet. How do I do that in Sheets?Can'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 trySet print area
Is there a way to set the print area like I can with ExcelRun a custom function in VBA Macro
Hello, I have a custom function to update a record in CRM through a worksheet, but I would like to trigger this custom fuction to a button using VBA, it is possible?Why Are Columns Reset When Deleting Entry
Hello, this is quite annoying. We use forms as a questionnaire for candidates, we filter entries by removing columns, when we delete an entry the columns reset. Every "delete" the columns reset, why!? Thank youHow to change sheet alphabet color ?
HelpNext 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
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 manyOpenAI 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? ThanksRun 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 regards6 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 thatHow 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 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
chrishall57
Anouncia P
Narendra Eswar G
Vadivel K
Vinoth Kumar K