Tags
1. Is there a way to have tags window open all the time? 2. How does one search tags? Thanks
Zoho Sheets Bugs
I am experiencing Zoho Sheet as a very unstable and fragile app and it has not improved since I firstly tested it several months ago. When I used it recently I experienced the following difficulties: Server Error messages when attempting to hide a column.
Zoho Sheets Arrayconstrain
Hi, I'm using functions that output arrays. In Google Sheets I usually wrap them in array_constrain(array,limit) which makes them not take up all available space. Is there a similar function in zoho sheets? Example from Google sheets =array_constrain(ArrayFormula(sumif(B2:B,H2:H,C2:C)),L1,1)
Restore deleted spreadsheet
Hi all, I can not find my spreadsheet. It seems that my spreadsheet is deleted. Please, restore the spreadsheet. Thanks in advance
Invalid API key problem
Dear Zoho team, I recently used zohos API in my web site. I used the same API key for ZOho sheet , show and editor. The zoho editor opens up smoothly without any problems. However the sheet and show give me these errors. I am using the remote API method. The errors are listed below: Sheet: RESULT=FALSE ERROR_CODE=2890 WARNING=The api key is invalid. Show: RESULT=FALSE ERROR_CODE=3890 WARNING=API Key is not valid -------------------------------------------------------------------------------------------
Hide Unhide Sheet
The ability to Hide and Unhide a sheet is the single feature in EditGrid that keeps me mainly working there instead of Zoho. To allow a sheet to be hidden or unhidden based on a cell content using VBA would greatly enhance your product's utility. Thank you.
Scrolling with mouse wheel makes data dissappear
When trying to scroll via mouse wheel, spreadsheet gets blank. Refreshing the tab gets data back.
Tip #1: Handy shortcuts to move around your spreadsheet
No matter the application, keyboard shortcuts are always a great way to save time and make you more productive. Here are a few quick key actions you can use in Zoho Sheet to navigate within your spreadsheet. Moving to the next cell (Tab, Enter, Shift+Tab)
External Data connections change cell addresses to row zero on their own.
I set up an external data source at a specific cell on a sheet only for external data. If the link is set up on A2, it later moves to cell A0 on its own, ruining other cells that are referencing A2. Also you cannot even remove the bad link. I don't know
Is there a forumula to create calendar in spreadsheet?
I'm looking to create my own 2011 calendar to print but I am looking for a way for Sheet to create the calendar for me so I can then just format, design and print. Is this possible here?
import from url
In google sheets i can import an html table from a URL, if I do the same with Zoho sheets I get 'URL not reacheable'. I can't find any information on this so I'm not quite sure why. Any comments or advice welcome.
How can I turn off e-mail notifications in ZOHO Sheet?
I have previously uploaded several Excel sheets into ZOHO sheet and had checked the box to let me know when changes were made. I now would like to turn this feature off because it is not helpful to me any more. Can I do this? If so, where do I go to turn it off? Thank you!
Use VBA to open an external file
Since I can't use a hyperlink to open a local file from within a spreadsheet, what would be the VBA code to open c:\test.pdf
Zoho Sheet API problem with parameter json_data
Hi everyone, When I run the following Post request through Zoho Sheet API, I kept getting error. Could someone please help? https://sheet.zoho.com/api/v2/p5gob655bd7aexxxxa446c9a7bfe03109aade3?method=worksheet.jsondata.set&worksheet_name=Sheet2&json_data=[{"Name":"Joe","Region":"South","Units":284,
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 David
Value 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 screen
How 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, Tiemen
Is 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 clarify
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-suite
How 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 the
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,
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.
Zoho 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 to
How 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 of
Is 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 you
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 message
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.
Question 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 the
Won'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 made
link 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? Thanks
Recommended 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 cut
Rotating text
It would be very useful to be able to use text vertically and not just horizontally.
Remove Total from Pivot Table
Can I remove the Total and Grand Total of my Pivot table?
Next Page