Organizational Charts
Hi, I usually create org charts in excel using shapes. Since Sheets does not have Shapes function, does any one have any suggestions on how to create an org chart in ZoHo family of apps? thanks DavidValue of last populated cell in a column
Hello: I want a formula to return the value of the last populated cell in a column. In Excel and Google Sheets, the following formula works. =LOOKUP(9.99E+307,F:F) However, in Zoho, this formula returns the largest value in column F, not the last value.Why is "Generating Preview" freezing/ go blank when I try to Print?
In Zoho Sheets, when I go to print it freezes when it's trying to generate the preview, and I cannot print or save as PDF. I've tried refreshing the page, restarting my computer, logging out/in, using a different browser... still stuck with a blank screenHow to add a hyperlink to a cell or image? (Not text)
Hi, Is it possible to add a hyperlink to an cell or image? And as a follow up question, upon pivot table creation, will the image/cell with link be taken into the pivot table? Thank you, TiemenIs it possible to collaborate online on ZohoSheet not sharing all information ?
I want to collaborate on the zoho sheet with multiple people who will input their own data but I don't want to show them the consolidated sheet and also other peers' data. I understood that (at least at the moment) I can't share a single sheet or individual sheets with different people in zoho sheet. Then I want to give to my collaborators an access to the individual work books with editing permissions and then fetch/synchronize these data into my main workbook automatically. So, could you clarifyImport 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-suiteDisable copy/cut/export for guests
I need to share a large spreadsheet with lots of formulas so that the guest can edit data to see if the model will work for their needs. However, this is rather sensitive data and I do not want them to be able to copy anything from the spreadsheet and paste it into their own spreadsheets. Is there a way to disable the cut/copy option for guests, but still allow them to edit data?group and ungroup
How do I group and ungroup columns and rows jakob_kishonHow do I use the filter in the Zoho Sheets Mobile App
When pressing on the filter icon in a Zoho sheet on a mobile app nothing happens. How do I activate the filter from on a sheet in the zoho mobile app?Use Relative Reference feature inside the zoho sheet
I have 2 pages inside one of my zoho sheet spreadsheets. One of them is the factor of the customer and the other one is the database of all of the customers' factors. I need to have a record by macro that whenever I run it, the information inside theData 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 timeRefine by Zia: a smart way to improve data quality
Zia in Zoho Sheet has been helping users with recommended charts, pivot tables, and offering insights about their data. While there is an exclusive smart data cleaning tool, from now on Zia will also include data quality suggestions for error-free analysis,Bitcoin
How can I get the current price of Bitcoin using a function similiar to the "stock" function?Countif for ANY text String
Pulling over formula from Google Sheet of =COUNTIF(B2:B11;"*") to tabulate cells in the set with ANY TEXT. What is the converted formula in ZOHO to achieve this?No Side Scrolling In Sheet
Hey there, I've been having an issue that's recently come up where my scroll bar for horizontal scrolling is locked in position. The bar will move but the page does not and upon release, the bar immediately goes back to the far left of the scrolling range.Select multiple options in a dropdown?
Hello! I am trying to create a column in which you can choose from multiple options. In this case, it's venue categories as an example (weddings, social events, concerts, corporate). I may wish to choose both "social events" and "weddings." I used the picklist for other columns, but I can only choose one. Thoughts on how best to incorporate this (or another way I could set up this information)? Thank you!How to remove hyperlink when there is additional text inside the cell?
Greetings, I hope find you all well and safe. I have a cell with an email address plus a text between parenthesis, like email@email.com (info) When I type just the email, I am able to remove the hyperlink normally, but when I type the additional textZoho Sheets Not Linking Anymore to other Zoho Sheets with Formula =IMPORTRANGE
I have multiple Sheets using a formula =IMPORTRANGE which were working prior to the recent crash. Every time I either get a Not Link error (so I re-link the sheets) and give me an error #EVAL! I have attempted to create two new sheets and attempted toAnyway to disable autofill?
When in putting In strings of text in multiple cells. The auto complete can cause a lot of problems in make it almost impossible to enter what you want. It almost makes it unusable.Is the beginning of a long string of text is the same it will try toHow can i add up times with format "mm:ss,000"?
Hi! I want to be able to add up times with minutes, seconds and milliseconds. That is easy to get in Excel by formatting cells as mm:ss,000, but Zoho Sheet doesn't recognize it where import the .xsl file. I was looking all different options but I did not find how to format cells like this way. For example: 1:29,002 1:32,010 -------------- 3:01,012 Any workaround? Thank you very much.Webinar: Learn how to instantly clean your spreadsheet data
Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration. In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid ofIs there any option to directly download my spreadsheet in csv or json?
Is there any option to directly download my spreadsheet in csv or json? If yes then, how many requests per second Thank youADR Stock Prices
Hello, It appears as the stock price function for ADRs is one day behind. For example BAYRY, at the close of 7/12/2021, shows $15.15 for the share price. That was the previous day's close (7/9/2021) because the current day's (7/12/2021) close is $15.08.Unlocking a shared spreadsheet
I was just testing out the shared spreadsheet feature (one of the things we are most excited about!), and am uncertain how to unlock a spreadsheet after I'm done editing it. For instance: * my husband & I are both logged in to Zoho Sheet. * I have given him read/write access to one of my sheets, which he is currently editing. * He saves the sheet, and then selects another sheet to edit. * At this point, I expect to be able to select our shared sheet, and edit it myself. Instead, I receive a messageHow 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-RenAuto shapes in Zoho sheet.
Does Zoho sheet supports inserting auto shapes (rectangle, circle...). I did not see any option to do so. If its not supported currently, is there any plans on bring in this features. Any timelines ?Deleting shared spreadsheets
Hello I was just wondering what happens to a spreadsheet that I've shared when I delete it. Does it delete it from everyone or just me?Zoho Sheets seem to be down
Zoho sheets keeps saying there is an error or loading a white screen.Docs Sheets very slow?
Are Sheets always this slow? We have been testing ZOHO Sheets as a replacement to Google Docs, but we keep hitting patches of the day where it grinds to a halt. It is either really slow or it will load only a few lines from a sheet and just hang and we have to log out and back in again to get it working,.... We are experiencing it on several computers on various OS and Browsers. We are in Spain, but on 100Mbps Fibre so I don't think it is an issue on our end. Any advice or solutions? Thanks AlexQuestion about the functionality of zoho sheet
Can I add footer to sheet?Use of Unique function in Data Validation for Zoho Sheets
Hi There, Can I use the Unique function to a data validation so that the dropdown only populates the attributes of a column. Or do that with a cell reference. In Microsoft excel, this can be done by adding a # so that the cell reference picks up all theWon't Print - Server Error
In typical Zoho fashion, something doesn't work and an ultra-vague, totally unhelpful error appears. This time, I'm trying to print my spreadsheet. Okay, I did try again. Still doesn't work. Now what? I'm extremely frustrated with this program. I madelink to tab in Zoho Spreadsheet
Is there an easy way to link directly to a tab in a spreadsheet from an external site? For example, I want to link to Tab2, but the zoho sheet only provides a single URL. How do I direct traffic to one particular tab in a spreadsheet, and have another link that directs to another tab? ThanksRecommended Broswer for Zoho Docs
All my Zoho apps work great except for Docs. It simply runs slow buggy compared to all other Zoho apps. This is regardless of using Windows 7 or Ubuntu 12.04. I have tried Chrome, Firefox, IE 9 on Windows and Opera. is there a recommended browser OS combination for Docs? Also, I have not been able to get offline mode to work, all I get is a blank page that has the loading message.Cut -> Paste values and formats in single Spreadsheet
Hello, I am stuck with CUT-PASTE with the following behaviour of spreadsheet: 'Sheet-1'.A:A has [conditional formatting] and [data validation] and 'Sheet-2'.A:A has the same configured rules for [conditional formatting] and [data validation]. When I cutRotating text
It would be very useful to be able to use text vertically and not just horizontally.importXML function and related use case
Hi, I would like to know is the spreadsheet roadmap plans to implement the importXML function? My use case is as following: - I need to get date from a web page and then to compil them - I would like to publish the result in a blog in a form of the dynamic table. The table value must be updated as per the web value. - Because many people ask the way to do that with an online spredsheet, I prefer zoho then Google spredsheet, because when you share a range, the user can style edit it whithout modifyingRemove Total from Pivot Table
Can I remove the Total and Grand Total of my Pivot table?Sheets oauth scopes
Is there a list of OAuth scopes I should use for API access to Zoho sheets?Zoho Sheet Embed options
I would like to be able to embed an active sheet into a web page, i.e visitors to the page can enter data to see changed results but cannot edit the sheet in any other way. Regards PETER J WILLS Business Consultant & Adviser ABN 53 964 553 113 www.bcaservices.com.au pjpw2320Next Page
Zoho DataPrep Resources
New to Zoho DataPrep?
Zoho CRM Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
-
Zoho サービスのWebセミナー
-
その他のサービス コンテンツ
ご検討中の方
有料プランをご利用の方
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-suiteRefine by Zia: a smart way to improve data quality
Zia in Zoho Sheet has been helping users with recommended charts, pivot tables, and offering insights about their data. While there is an exclusive smart data cleaning tool, from now on Zia will also include data quality suggestions for error-free analysis,Webinar: Learn how to instantly clean your spreadsheet data
Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration. In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid ofIntroducing Dynamic Array Formulas to Zoho Sheet
We're happy to announce that Zoho Sheet has opened up the new dynamic array formulas to all our users! The addition of dynamic array functionality will make your spreadsheets and the formulas you use in them a lot simpler, while at the same time makingAnnouncing IMPORTRANGE and cross-spreadsheet linking in Zoho Sheet
We are pleased to announce the much-requested IMPORTRANGE function in Zoho Sheet. With this function, you can now link or refer to cell ranges across spreadsheets in an instant. Refer across spreadsheets You can use IMPORTRANGE just like any other predefined function in Zoho Sheet. Start with an equal sign, select the function, and fill in the parameters. For this function, the source spreadsheet link and the desired cell range to import are given as input. Once you allow access to the source
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Zoho Desk 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
Most Discussed Topics
Why is "Generating Preview" freezing/ go blank when I try to Print?
In Zoho Sheets, when I go to print it freezes when it's trying to generate the preview, and I cannot print or save as PDF. I've tried refreshing the page, restarting my computer, logging out/in, using a different browser... still stuck with a blank screenValue of last populated cell in a column
Hello: I want a formula to return the value of the last populated cell in a column. In Excel and Google Sheets, the following formula works. =LOOKUP(9.99E+307,F:F) However, in Zoho, this formula returns the largest value in column F, not the last value.Organizational Charts
Hi, I usually create org charts in excel using shapes. Since Sheets does not have Shapes function, does any one have any suggestions on how to create an org chart in ZoHo family of apps? thanks DavidHow do I use the filter in the Zoho Sheets Mobile App
When pressing on the filter icon in a Zoho sheet on a mobile app nothing happens. How do I activate the filter from on a sheet in the zoho mobile app?Data 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 time
Sticky Posts
Refine by Zia: a smart way to improve data quality
Zia in Zoho Sheet has been helping users with recommended charts, pivot tables, and offering insights about their data. While there is an exclusive smart data cleaning tool, from now on Zia will also include data quality suggestions for error-free analysis,Webinar: Learn how to instantly clean your spreadsheet data
Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration. In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid ofAnnouncing IMPORTRANGE and cross-spreadsheet linking in Zoho Sheet
We are pleased to announce the much-requested IMPORTRANGE function in Zoho Sheet. With this function, you can now link or refer to cell ranges across spreadsheets in an instant. Refer across spreadsheets You can use IMPORTRANGE just like any other predefined function in Zoho Sheet. Start with an equal sign, select the function, and fill in the parameters. For this function, the source spreadsheet link and the desired cell range to import are given as input. Once you allow access to the sourceNew look, improved usability, and more: the exclusive Zoho Sheet app for iOS and iPadOS
We are constantly working on improving the Sheet mobile app and its usability in terms of speed, design, features, and overall performance. With these aspects in mind, we are excited to announce an exclusive Zoho Sheet app for iOS and iPadOS that willTab Colors and New Currency Symbol of Indian Rupee
Zoho Sheet has recently added support for the following 2 new features: Tab Colors: Since last month, you can set a color to your worksheet tabs. Use colors to quickly identify/highlight specific worksheets or to group similar worksheets together. This option is available on the right click context menu of the worksheet tab. Add color to your worksheets! Indian Rupee Currency - New Symbol: The new Indian Rupee Symbol, ₹, is now supported in Zoho Sheet. This replaces the old "Rs." currency symbol
Top Contributors
Gautham Balaji G
Mohammed Ibrahim
leonard.nika
david
Rohith V K