The value entered violates data validation rules set in cell E6
Hi, I was trying to shift a data from sheet 1 to auto paste into sheet 2 by press from row and colume at = 'e6' from page 1 and press enter then there have an error pop up said: The value entered violates data validation rules set in cell E6. Please advice what is the solution and what is going on?Embed With Formula Bar and Headers Not Visible
Is there a way to embed the sheet on an external page without the formula bar or headers showing? Love the product and it's an awesome way to present users with tools and calculators but for aesthetics, it would be great to remove these for a cleaner look. Thanks!Apply conditional formatting to a row
I would like to apply conditional formatting to a row. This can be really helpful for project based sheets where each row might be associated with a task/to-do. When the task is complete, a cell within the row is Checked/True, or updated to 100% orDisable 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?Is there a way to disable Create and Copy Sheet in external share?
Is there a way to disable Create and Copy Sheet in external share? VBA would be fine, but I'm not seeing it. For our business, large table-style data entry is a must for our orders. I've been able to push Sheets a long way, but I still need more excel-likeAuto 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 ?Do you know any zoho sheet professional, who I can hire?
I am looking for any zoho professionals, who I could hire when I need to deal with my zoho apps. I think, many of us do not have time to learn everything about sheets, flow etc but we are keen to learn as we go with ours needs for solutions. I need toSort data in Pivot Table
Is it possible to sort by a data field. I can gruop and filter, but I culdn't find how to sort the results. Tank You.Can't share, no response
Hello, I emailed sheet, writer, email & WD over 12 hours ago because other than email, nothing is working & I can't work. NO ONE has responded back to me. What is going on???use of comma as a decimal separator
Hello, I wish to find a way to customize the number format for my proper use. I have to use french data, where the "," is used as the decimal separator : for example the french way to write "3.99�" is "3,99�" Is it possible to do it in Zoho Sheet ? If this is not actually the case, I'd love this feature to be implemented !Zoho Sheets Row Height Issue
I am having issue with adjusting the row height. The row height for my Zoho sheets have to be at least 47px, sometime as high as 61px. If I decrease the height i cannot see any contents in that cell. This happens to few columns like A or B while columnCannot select cells
I am using the Android app and don't seem to be able to do the most basic thing: selecting a group of cells. Whether for the purpose of formatting or generating a chart, for some reason I am not able to select the cells I wish to format or chart. WhenText Boxes
Any plans on being able to add text boxes and cell merging in the near future?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!Quicktime movies
Can I upload quicktime movies from my camera and have other people play them from one of these apps. Vince MIntroducing 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 makingHow to change my sheet to landscape format?
Please help me, I can't seem to find how to change the orientation of my spread sheet, I need it to be landscaped not portrait. Thank you!Insert/Delete Table Rows macro
Anyone know how to write macros to insert or delete table rows? I use these buttons in Excel all the time for expanding/shrinking BOM tables. I tried recording a macro. But, it is empty after performing the insert table rows command. Looked into writing[Function Zoho Analytics] - Is there a query function in Zoho Analytics?
Hello team zoho, Is there a Google Cheats query function in Zoho Analytics? If not, how can I replacement?Stock Prices using STOCK function
Hello, I've been using the STOCK function for over a year without any problems. Today, however, the prices are not getting updated. Might anyone know if there is a problem with this feature? Thank youPDF tables to Sheet tables
Hi, I am looking for a way to convert PDF tables to Sheet tables. I am unable to find a way to do it. Two additional info for background. (a) The PDF (basically a credit card statement I am trying to get the transactions into Sheet) is password protectedPublished sheet download error
I have a published sheet embedded into my website, but when I click the download button, it says that download has failed. I have enabled downloads in the sheet publish settings.How do I print a worksheet with VBA code?
I want to create a print button on an embedded sheet on a website. How do I create a macro that will print the active worksheet?Print
does zoho macro support print related function? thanksformula to get current sheet name
What formula can I use to get the current sheet name? In excel I could use - MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) In zoho sheet, there is the "sheet" function but how do I get it to return the sheet name instead of the sheet number. The reference page is not very clear on this thanksRemove Rows with Duplicate Cells
I need to search a column for duplicates, then remove the entire row of that duplicate. I do not see how to do it easy just like Microsoft Excel (which I no longer have access to). *I'm using the built-in "Data Cleaning" tool. I'm able to highlight allRemove Duplicate Rows - Any Easy Way?
Hi there, Does Zoho sheet allow us to remove duplicate rows or entire rows based on duplicates in one column? I'm looking for the function that is available in Excel Data tab. Thanks, ChadNon-US date format in Zoho Sheet
Hi I'm a Zoho user from New Zealand where the standard date format is DD/MM as oppose to MM/DD as is common in the US. I can set the format for existing dates in Zoho Sheet to DD/MM but still have to enter new dates in the US format. I.e. to enter November 4 I have to put 11/4 even if the cell is set to DD/MM/YYYY and immediately re-displays the input as 04/11/2011. That's pretty confusing and user unfriendly. Two suggestions: - could the spreadsheet parse the date entered according to the formatThe formula does not respond as expected
imported a workbook from LIbreOffice. In the first sheet there are formulas which all give the expected result except this one The formula in cell B41 is as follows: =IF(B46="";"";IF(COUNTIF(B6:B36;"PP|PM")=B46;"";COUNTIF(B6:B36;"PP|PM) ")-B46)). SearchesZoho Sheet History
hi Does Zoho Sheet have function that we can see change history exactly? I can see which cell have been changed, but I'd like to know original information.How do I delete a Zoho Sheet Template for my organization
I made a template in Zoho Sheet for my organization and want to delete the template for whole organization now. Can not find any way to delete it now. Please helpInsert row in multiple sheets simultaneously?
Is it possible to insert a row or column at the same spot of more than one sheet simultaneously? Example: My document contains five sheets with the same basic structure. I would like to update this structure for all sheets by adding a new row below row 3 without repeating the same Insert > Row Below operation manually in each sheet.Changing a date stored as text into date format
Hi all, I have imported a csv sheet with the dates fromated as text like "05 October 2023 10:40:23" and I wonder how the reformat these into a date format. Any help would be warmly welcomed. Best, ChristianMacro or function to display each unique value in a column and the count of occurrences
Hi I've been tearing my hair out a bit with this one. I've got a set of data, which I'm applying filters to, but I then need to be able to quickly see how many unique values there are in a given column and the count of each. My initial plan was a VBASwitching Tabs Results in Loss of Cell Position
This might be a bug report or a feature request, depending on one's interpretation. Using the following scenario: Create a new Zoho Sheet spreadsheet; On the first tab, enter enough data in the first column to force the sheet to scroll vertically; Switch to the second tab; Switch back to the first tab Instead of maintaining my cell location on the first tab, Zoho Spread returns me to the top row of that tab. If I am switching back and forth between tabs, having to scroll every time to recover myTip #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-relatedPublished and embedded Zoho Sheet not getting updated
Hi. I have used the Publish option in a Zoho Sheet to embed it into Zoho CRM's dashboard. The part I'm embedding is a dynamic table. After adding data, the dynamic table is updated. However, the published page has remained the same as when it was published,Name Ranges Disappeared
Is there a data limit in what Zoho Sheets can handle? I have build several tabs within a sheet, some of the tabs having several thousand rows with formulas pulling different pieces of information. After spending nearly a whole day working on a templateEdit History: Prevent data loss during collaboration
With teams moving to hybrid workplaces, remote collaboration has become routine. Zoho Sheet simplifies collaboration for distributed teams with user-specific access levels for file sharing, contextual commenting, and real-time editing tools. It also providesFormat 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,Next Page
Announcements
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 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
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 getsSyncing Sql Query Table to Zoho Sheets
I want to sync Query table to Zoho Sheets. I already used data connection zoho sheets but the issue I am facing is while it gets synced the data I entered in new columns next to synced columns is getting mismatched as new row data is coming. So is thereSUMIF with "=" condition giving #NAME! error
I have =SUMIF(H21:H27;=&B55;I21:I27) which is throwing an error. Have tried =SUMIF(H21:H27;=B55;I21:I27), =SUMIF(H21:H27;"="&"B55";I21:I27) and =SUMIF(H21:H27;"=B55";I21:I27)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 spreadsheetData 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 Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly 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.
Zoho Creator Resources
Zoho CRM Resources
Sticky Posts
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 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
Murugalakshmi S
Narendra Eswar G
david
Mehnaaz T
kvansensie