Want the conversion of MS Excel function to Zoho format
My current formula excel formula is : =COUNTIF(D8:AH8;"*"&AI$7&"*") Can you please help me convert this in format of Zoho Docs.
How to count events that match multiple criteria?
hi, i'm have a table with information about specific meals: sept 1 Chris Burger Sept 2 Jane Pizza Sept 2 Chris Pizza Sept 3 Jane Chicken Sept 4 Jane Burger Sept 5 Chris Burger etc. . . What I want to be able to do is count the number of instances that meet two criteria (person and meal), for example how many times did Chris eat a Burger, and I want to do this for every combination of people and meal. What I would do in Excel is make a table with names
How to generate a random number
Hi I'm interested in some way of generating a randon (pseudo random I guess) number. I think some spreadsheet programs have such a function but couldn't find anything in Zoho Sheet's function list. I guess if not there must be some formula to replicate the function... -- Cheers Mark
Macros disappeared from workbook
With the recent update to Zoho Docs it seems all macros have disappeared, at least from my workbooks. I've tried downloading older versions and opening them locally in MS Excel to retrieve the macros but have not had luck so far. Does anyone know of a solution to this problem?
Spreadsheet issue
An interesting problem. I keep a spreadsheet of books I assign for review, with columns for title, author, reviewer, etc. When I have to update a row, I search for title or author, etc. The find action will locate the information I'm searching for and highlight the cell, but the other cells in the row don't align correctly -- the Title row, for example, is highlighted, but the Author row, etc., are for a completely different title. It's very frustrating. Is there a fix for this? Thanks.
Edit sheets in App phone
Hi guys, I am trying to edit sheets from my app in Android but It doesn't allow me, but when I want to edit some writting document everything is fine. Is there somehow to edit sheet by phone? Thank you, Alberto.
I cant edit my own file
I can access my file but i can't modify. Appears the follows message "Unable to connect to messaging server."
I am not able to edit my own file
Hi There For some reason, today am not able to edit my own file How to fix it? Thanks Akilen
Spredsheet won't let me edit
I can't edit the spredsheet that we have in our document.
Pressing Enter while editing cell now inserts a newline in the cell
This is dumb. People rarely need to insert a newline within a cell, but always need to finish editing a cell. Now there is no way to finish editing except to use the mouse to click somewhere else. Ctrl+Enter is the standard way to insert a newline in other spreadsheet software.
how to customize user privileges within a specific grid ?
Dear all Within a specific grid within a form, how to customize user privileges(such view,edit)? Sorry to my poor English,any help would be appreciated!
Publish to External not working in spreadsheet connected form
hr@devfactori.com: I'm trying to create an online form (linked to a spreadsheet in Zoho Docs), that should be visible to general public. When I press "Form" to publish this form, it gives me two options: -Within Organization -Publish to External Within Organization works fine, it gave me a URL that I shared with the employees within the company and it's accessible to all inside the company. But with "Publish to External", as when I wanted to share the form with general public. I pressed this option
Server down again
The server has been down all day here. Can not update or print my spreadsheets. Can someone advise when this is likely to be fixed.
losing a sheet
i just made a very important sheet using zoho. but while saving, it got lost and isnt opening. showing there is some error. i must get the sheet, it is very important. the link follows https://sheet.zoho.com/sheet/editor.do?doc=bffb24df9c4dc13a81966d0c074729cd98fe7a8ae71716bacd8cbc8bcaf1ef01aedfd1a4e81bcbece58d110d3e51d68d477905e4eb3516c69946b9e79d565583
Spreadsheets, print to one page
Is it possible to print a spreadsheet to fit all on one page ?
Edit Client Info with Zoho Sheets?
Hi, I want to edit the "Client Type" column for all my clients, one-bye-one. I guess the best way to do it would be the "Zoho Sheet view" and I was able to edit the info for about 50 of my clients. But after that the list ends and if I set the filter to "Client type" and then "must be empty" an then go to the "Zoho Sheet view" it will bring up the same clients again. Is there any way to look at all my (500 or more) clients with the sheet view or at least filter them in a way that only clients are
is it possible to copy a colum from excel to a zoho sheet?
We are in our trial period. I opened an excel spreadsheet in Zoho. However there were some added lines this morning that I just found. I would like to copy them from the original excel spreadsheet to my new Zoho sheet. How to do that? Copy and then paste does not seem to work. dc
#EVAL! error
Hi , I am trying to Match a partial of a string of a text "g" in range that has at least one cell which has a word that start/contain "g" : range : {q, ddfd, gsdfsd, rt} as follows =MATCH("*g*";$AA$13:$AA$18;0) I was supposed to get : 3 but I am getting this Error : #EVAL! Kindly help.
hyperlink changes format
Why when I create a hyperlink in a spreadsheet is Zoho changing the formating of the link I am pasting? Example: I want to link to this page http://thetvdb.com/?tab=season&seriesid=175001&seasonid=659461&lid=7 I paste that into the hyperlink, and Zoho changes the formatting of the ampersands to http://thetvdb.com/?tab=season&seriesid=175001&seasonid=659461&lid=7 which results in a error message because the database being called does not recognize the request in that format. I have been
Fast track to perfect charting.
Charts need the right set of data to look perfect. Wait, what?! If that's your mantra for ideal charts, you're doing your charting wrong. Perfect charts are those that interpret your data, however it might be, in the best possible way. Plenty of time goes into creating them. Well, not anymore, as Zoho Sheet has solutions to bring down the time you spend on charting. Cherry-pick charts, nimbly. Cherry-picking charts at the cost of your time? It's fun to try out different chart types, but not when
[Pydio] Impossible to save csv
Hi, Since Wenesday (probably) I can't save my .xls and .csv on my pydio server. Even if I upgrade my installation to the lastest version of pydio I can't save my spreedsheet. The .doc file can be save without problem. Have you made some change in the api for .xls and .csv recently ? Regards.
Cannot update any Docs or send emails
I am getting the Unable to connect to messaging server and all it has in Loading which stops me from typing anything in Documents i have all my spreadsheets in there and cannot update them. Kind regards Robert
Button disapperas when fixing window
I placed a button somewhere on the top left corner of a spreadsheet and connected a macro to it. Works. Good. But as soon I fix the window to cell F6, the button disappears. When I cancel fixation, the button is back again. But I need to use window fixation. Can you help me?
How do i make formula for date?
I need to make a sheet, For particular column if i add date 17/11/2016 and other column add formula like D6+30 So the result should be 17/12/2016 => current date plus 30 days addition. what should i do whenever i add formula the result is cames #VALUE 17/10/201 =D6+30(Enter) Need result 16/11/2016
Preview Not Available when printing xlsx files from PDF
Hi, I have an xlsx file that I can open just fine, but when I try to print from PDF when some specific options, it shows a Preview Not Available popup. The options I'm choosing manually are... Paper size: Letter Orientation: Landscape Options: Fit to width Every other option is default. When I remove these options it shows a print preview just fine. The file is 69 KB.
Fast Way To Search Spreadsheet - CNTRL + F Is Too Slow - Search Box In Middle of Data
Hey Zoho Docs Team, The Cntrl+F for search really slows us down when working on spreadsheets. Also, it always shows up right in the middle of all your data. Is there any way, to search our spreadsheets quickly? Using A Macro Search Box I have tried creating a macro, but that didn't work: https://help.zoho.com/portal/en/community/topic/search-box-macro-script-to-search-using-filters-in-sheet Here are the other options I was thinking about: Add Search box in Zoho Sheet toolbar In excel, there is a
How to link to external data in a .CSV file also stored on Zoho Docs
I go through all the steps using the "Link to External data" link and when I hit Finish it says "There was a problem with your last edit. Please check and try again".
Reference to another spreadsheet
Hi, Can you please help on below queries: is there any way to refer to a cell or link cells between two ZOHO spreadsheets. using VBA , can we push entries to another ZOHO spreadsheet. Thanks
Double Click To Edit Copy/Paste Cell, Open Links - But Only From One Account?
Hi there, I have a spreadsheet. On my account, it opens links fine and copy/past fine. However, on my team member's account, she has to double click to open links or even paste. I think, in excel, this is called double click to edit. How can I turn on single click? Thanks, Chad
total mess-up of spreadsheet
Hello, I have been evaluating Zoho Spreadsheet now for some time but have to say, that it lacks reliability. Just today, our spreadsheets were totally messed up with cell contents missing on a large scale, wrong cell formatting, formulas gone and macros corrupted. Even the older versions (accessed via Version History) now exhibit the same kind of corruption. What went wrong and how can I restore the spreadsheets to a workable state? Thomas
Suddenly embedded sheet missing data
Suddenly all my sheets embedded in iframes are missing data. It seems like anything in a merged cell (with the odd exception) is not showing at all Is making my pricing tables look rubbish as the column headings have disappeared. Is this something new or temporary? Has been fine until today
Using tags in spreadsheets cells
I would like to add this line in a cell: a2cestmieux.com <info@a2cestmieux.com>, But it automatically change to a2cestmieux.com <info @a2cestmieux.com="">, How can I disable this kind of autocorrect?
Zoho Docs corrupting XLXS file
We have an Excel .xlxs file that we share on Zoho Docs for capturing data.. We have 1 computer that syncs the file to a local drive so it can be used in conjunction with a larger Excel spreadsheet. Have had this setup working well for over a year. Two days ago we started having a problem with the xlxs file sync'd down through the Desktop app being corrupt. When trying to open the file with Excel we get 'Excel cannot open the file because the file format or extension is not valid'. I've confirmed
Maximum Number of Simultaneous Collaborators?
Hello! I am currently researching a viable replacement for Google Sheets for my department at work. We typically have about 20-40 people editing one spreadsheet at the same time. What is the maximum number of simultaneous collaborators in one spreadsheet at one time with ZOHO? I need this answer as soon as possible so that I may begin preparations to migrate from Google Sheets. Thank you! Adam S.
Worksheet Open Event
I'd like to execute a macro when a user opens a worksheet. I tried to do this with this code in sheet "ThisWorkbook", but it doesn't do anything. Private Sub Workbook_Open() Sheets("FirstSheetToDisplay").Select End Sub Any idea?
How can I generate a wide message or report with a macro?
I've a spreadsheet with a lot of data on multiple sheets. I would like to generate, based on that content, a kind of report which I would like to copy & paste into an e-mail program or on a formular in another website. The only way to do this was using the "msgbox" statement. But this is very inflexible, the number of lines are limited, it is not possible to insert CRLF, so it works only for short messages. Isn't there any possibility to extract data from the spreadsheet and generate a report? Perhaps
Does Zoho Sheet support bullets (dots or numbers)?
Dear Zoho sheet? Can I use bullets (dots or numbers) in Zoho Sheets? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Conditional Formatting Bug
I'd like to highlight cells in an area based on a formula. The area is J6:AU44. The formula is =ISEMPTY(J6)*($G6>0)*(J$1<>"") It works. But after a while, I don't know what exactly is the trigger, the formula changes on a magical way to =ISEMPTY(A1)*($G1>0)*(A$1<>"")
Buttons are not displayed on Handy Browser
I recently added some buttons with underlaying macros on an entry page of my workbook. Looks great, work great. But after a while I discovered that my iPhone 6 is not able to display that page correctly, all buttons disappeared, only some pictures and texts are visible. I tried Safari, Opera Coast and Mercury, all same result.
Bug in Sheets: If statement with "<" operator
Hello, last weekend I was fighting against a very ugly bug. It happens in a procedure like this private sub ChangeColor() dim x as variant dim iLimit as integer iLimit = range("Player").value for each x in range("User") x.Select (1) if iLimit > x.value and not isempty(x) then (2) if x.value < iLimit and not isempty(x) then Selection.Interior.Color = 49407 else Selection.Interior.Color = RGB(255,255,255) end if next x end sub When I use (1) it works correctly,
Next Page