Formula fails to address a range in another sheet
I was experimenting with the following COUNTIF formula which works fine when used on the same sheet; =COUNTIF(B$12:B$10004;A4) However, if I address the same range in another sheet, it fails to return a result, i.e.; =COUNTIF(LOG.B$12:B$10004;A4) What am I doing wrong ?
No touch function for Zoho docs!
Hi, I got a touch screen notebook running Windows 8.1 and found out Zoho docs ( spreadsheet and word ) do not work with touch functions such as scrolling up or down...it's only possible by scroll bar! These days touch screen Windows based devices are getting more and more popular and it's a must for Zoho to improve this point.
Summarizing data in a cell rannge in spreadsheets
Hi, I have a number of spreadsheets under different groups as follows, GroupA Category1 Category2 Category3 GroupB Category1 Category2 Category3 GroupC Category1 Category2 Category3 All these spreadsheets have the same format. My requirement is to get a particular cell range (say A1:B5) from each spreadsheet and display them in a tabular format (column header is the file name, and the rows would be the data in the cell range). I tried Zoho reports, and to create a table I can use only one spreadsheet.
Automatic update in Excel from Zoho Sheet
I need to read a Zoho document on Excel and to have data updated currently. I've tried to use the HTML published version of the document https://docs.zoho.com/sheet/published.do?rid=ctdnu07c9dce2917b400e9ce0e918759ee098&mode=html Same way I've used to do with Google docs, but it had not worked. Is there a way to have the file published on a CSV format? Best
Problem editing cell in Sheets
This may be a basic question: When I double click on a cell to edit its contents, the cursor moves to the end of the text toward the right side. I have encountered a cell that does not behave that way - when I double click on it, the text disappears and the cursor is on the left in what looks like a slightly larger cell covering the text .I am unable to edit the contents of the cell. What is causing this? Thanks.
File menu tab won't stay open
Hi I just signed up and problem getting started. All other menu tabs work but file subject list won't stay open so I can select. I'm on Android tablet. Thanks
Zoho Spreadsheet, information disappearing from saved files
Hello, I am using Zoho Sheets to edit files stored in Google Drive. Sometimes I am doing something, putting new info to cells, or adding sheets, anything, and then I reopen file ooops my work all gone nowhere. Can that be a problem of Google Drive? Or what to do? I understand when no connection then Zoho tells me - no connection reload, etc But everything looks ok and then boom - do your work again... Sergio.
Import from Zoho Sheet => cannot import formula based Text value properly :)
Hi, I use a sheet on zoho sheet. I have different type of data including formula using IF() or SEARCH() function. These column are never imported correctly when they contain text or reference to another cell. When I export file and then import this file (not using cloud access but from my computer) it works well. What is that not working properly ? I tried a lot of test based on cells format on Zoho sheet and Zoho Report but it does never get correctly these data. Thanks for your help !
Adding a formula to column
Hi all, I need some help understanding the logic of formulas in Zoho and although similar to Excel they are different and I am struggling to create one. so here i am asking for some help I have column one that is called "Reference 1" I have column two that is called "Reference 2" the response is Answered or Not Answered I need the formula to create a response of the following: Reference 1 and Reference 2 = Answered, the response should be "complete" Reference 1 = Answered and Reference 2 = Not Answered,
Cannot export my sheet
I am trying to export my sheet. When I hit "export as" it says that "This spreadsheet has Pivot Table/Chart. Export not supported for Pivot Table/Chart. \nDo you want to continue?." It then comes out blank if I hit yet. How can I turn off the pivot table/chart so I can export? Thank you
Sheets: Instant Sum, Count, Average missing from Status Bar
Since yesterday, the instant sum, count, average feature has vanished. Any ideas on how to get this back?
Audit Trail and New Version History in Zoho Sheet
Two new features related to collaboration have recently been added to Zoho Sheet. New Version History Audit Trail New Version History: We have revamped our Version History to provide you better insights as to what changes have gone into each version and who has made those changes. This gains importance when you share your spreadsheets with your co-workers and work in a collaborative environment. The new Version History, which is accessible from File menu as well as the Review tab, opens up a pane
Zoho Sheet Slow
Hello, Today I noticed that when in Zoho Sheet, after every single change, the sheet is saving which is making the entire experiencing slow and time consuming as the entire sheet locks up until the save is complete which takes 5-20 seconds. I know with Google Docs SpreadSheet, it only saves every so often and on exit, maybe you should do something like this as well? Thanks, Mike
Attach button to frozen row
I would like to have a button that runs a macro always available to me on a long spreadsheet. Is there a way to attach this button to a cell on the top row that is already frozen? Thanks
Why does my macro button disappear?
I've created a macro button, and have it sitting over row 3. But it disappears when I freeze rows 1-5. The only solution I've found is to put my button below the frozen rows, but I don't like the way that looks. This will be a shared file and I'd like this button to be above the input area. And I want to have frozen rows so column titles are always visible, no matter how large the file gets. Is there a way to keep the button visible when it's in the frozen row area?
Locking Cells in an Embedded Spreadsheet
Hello, I have locked certain cells in my Zoho spreadsheet that I do not want visitors to my website to be able to edit. However, when I use the embed link to post the spreadsheet on my site all of the cells appear unlocked and editable even though they are locked when I view the sheet in my Zoho account. How do I keep these cells locked on the embedded version of the sheet? Thanks
Tabbing is jumping at weird places in the screen
zSheets Team, I am creating a Zoho Sheet as here: https://docs.zoho.com/sheet/published.do?rid=inwcs7be3be2db29240cc8da7bcbf97e3bf71 When I type in one cell and press enter, I am expecting the cursor to focus on the next cell immediately below. But the cursor is going somewhere else on the screen. Can you help please? ---- Deepak Vasudevan http://www.linkedin.com/in/lavanyadeepak
Requesting a some help to calculate the difference in two times (Trickier than you might think)
I'm trying to create a cell where I can track the elapsed time since an entry was created. This will explain more: <Start time> <Elapsed time> <whatever> The <Elapsed time> cell will be the difference between the current time and the <start time>. It should update with each second essentially, as current time does as well. Does anyone know if this is possible with zoho docs?
Sheet does not unzoom/zoom
Imported sheet is very difficult to see as I could not unzoom it! Am I missing a buttton somewhere?
Sharp features to fine-tune your spreadsheet experience
Your needs keep evolving and as does our spreadsheet. We concentrate on providing the best spreadsheet experience to you and in our mission, we bring you more features and enhancements to use and enjoy. These niche features will help you enhance your work experience and ensure your productivity improves. Highlight Invalid Data: Data Validation is a crucial feature that helps you enter data correctly. Highlight Invalid Data is an enhancement to the existing Data Validation feature. This feature
My question refers to Docs
Good morning! My question refers to Docs. Im in a spreadsheet, is there any possibility to immobilize more than one column at the same time, without having to block them? Thanks for your time. Greetings, Zaira.
Problem saving/copying spreadsheets
Hi When I want to copy a spreadsheet within zohodocs (right-click->Copy), I can select a destination folder but the target file never appears in my selected folder. Probably related, when I create a new spreadsheet, give it a name (File->Rename..) it also does not show up in my folder. Copying another file type (.jpg) works as expected. Browsers: - Chromium Version 41.0.2272.76 Ubuntu 14.04 (64-bit) - Opera-next Version 12.16 Build 1860 Platform Linux System x86_64, 3.13.0-48-generic - Firefox 37.0
Experience The New Chart Engine : Now More Refreshing and Vibrant
In our effort to deliver the best spreadsheet experience to you, we bring out to you our next update. Our chart engine has been updated completely to let you chart, interact and analyze from your data. Data visualization is a crucial part of spreadsheets. Visualization helps you acquire intuitions and frame right conclusions. Our latest update will help you do exactly that. So, what do we have in store for you? Interactivity and Vibrancy: First of all, you can now interact better with the charts
Zoho Writer Problems
Hello, I have read posts since 2012 claiming that Zoho has been working on the data input feature via iPad for Zoho Reports and Zoho Docs. Is Zoho actually working on this or just saying they are? Seems to be taking a very long time to get it implemented. In the mean time I am forced to use Zoho Writer to input data with the the iPad. Since it is only compatible with word doc (or similar) formats I have to draw a table to create a spreadsheet. Listed are the problems I am experiencing
Free Webinar on Advanced Functions of Zoho Sheet
A spreadsheet can be used to run your business efficiently and smoothly. They help you organize, analyze and collaborate on complex business tasks with ease. Join us on our webinar and we'll show you how to unleash the complete power of collaboration in Zoho Sheet. Here's the first look of what's cooking in the webinar exclusively for you!!! In this webinar, you will learn how to: Collaborate on spreadsheets in real-time Automate workflows using formulas and macros Permit varying levels of access
Free Webinar on Advanced Functions of Zoho Sheet
Spreadsheets can be used to run your business end-to-end. They help you organize, analyze and collaborate on complex business tasks, smoothly. Join us on our webinar and we will show you how you can unleash the power of collaboration in Zoho Sheet. Here's the first look of what's cooking in the webinar, exclusively for you!! Register today and reserve your seat! Date: 2nd April, 2015 (Thursday) Time: 11.00 AM - 12.00 AM PDT In this webinar, you will learn how to: Collaborate on spreadsheets
Can't Open All My Zoho Sheets
Hi, I've converted 65 excel files to Zoho Sheets in my Google Drive on 10 March 2015 and shared to all my colleagues for collaboration purpose. Why is it now that i can't access to all my zoho files? How can i have the access back and retrieve all the data? Thanks.
Hyperlinks in my Zoho and/or excel file are deleted
I just began using Zoho, very intriguing services! My goal is to embed a spreadsheet, or publish named ranges, in a webpage and I'm uncertain about a few issues. I have hyperlinks in my Excel spreadsheet. When I upload the file to Zoho, they are deleted even though the cell still indicates there is a hyperlink (the text/numbers in the cell are still underlined). I have verified by clicking the cell from Zoho and from the embedded/published web page that the hyperlink is missing. I installed Zoho
why is my thousand separator shown as dot rather than comma
in the zoho spreadsheet, the thousand separator is shown as dot rather than comma and the decimal separator is shown as comma rather than dot. Much like the german number format. however, I reside in Malaysia and the number format is like the commonwealth style where the thousand separator is comma and the decimal separator is dot. I have set my locale and timezones as Malaysia in zoho as well as on my windows 7 computer. I have tried the format cells feature, but the dropdown only lists the german
Mail merge to a Spreadsheet from Zoho CRM and make available as a template in Zoho CRM
Client wants to use a spreadsheet that will mail merge name address and some other fields to it from Zoho CRM. Is this possible? I can't seem to find instructions or information on how to mail merge it. They will also use it repetitively as a template so it will need to be accessible on any client. Thanks for the assistance. Joe
Sorting in published range
Hello, I'd like to ask, if there is some way to allow visitors of my web to sort / filter my embed range of cells? (I don't want to publish whole document, but only some cells)
Freezing
I can not find the "freeze" function, so I can freeze titles in rows, etc...
Vertical merging
Is this possible? ajbfca
Conversion from excel to zoho during upload does not work
when I try to upload an excel 2010 xlsx file, the conversion into zoho sheet format does not work, and consequently I cannot view the uploaded file in the preview. when I repeat the upload now with a much simple excel 2010 file (less functions etc) it works Q: are there any known features in excel that prevent zoho to perform the conversion ? Thanks, Achim
Buttons in frozen row area
If we could put Buttons in the locked/frozen row area we could create a simplified macro menu system
Can't Update Spreadsheet - Says "guest present on the spreadsheet"
When I log into Zoho Docs and go to my spreadsheet in the bottom right it reads "guest present on the spreadsheet" and won't let me edit or update any of the cells on it. I have no idea how to update the spreadsheet now? Any ideas?
How to make a horizontal spreadsheet into a vertical spreadsheet
I'm trying to change a long Zoho Sheet from a side-scrolling (left to right) to an up-and-down scrolling sheet. Does anyone have suggestions for how to do this? Thanks.
Pie Chart
How are labels inserted on the pie chart legend?
where are the comments???
Hello. I just converted a google doc sheet to Zoho Sheet (originally was an Excel file). I can't find a comment that was in the google doc sheet. Where did it disappear??? Thanks a lot, Lior.
How to alter row heights
Hi, I am unable to find a way to alter my row height. Can someone help me? Thanks, Jay
Next Page