diff btween two business dates w/ holiday array
the function "workday" works great when I have one business date and want to calculate another business date x days away subject to a holiday array, but is there a function to calculate the number of business days between two known business days which will also parse the holiday array? Thanks. Ross
Zoom facility
I just started trying Zoho Sheet and was looking for a 'zoom view' facility, very useful for large worksheets. Is it hidden somewhere I can't find, or not yet available? Thanks, David Rose
Editing email invite
the spell checker does not work in the invite email editor window of ZOHO Sheets when trying to edit the invite email. please advise.
View
Is there anyway to adjust the view to see more of the spreadsheet in the window?
merge cells down
I see how to merge cells across but cannot see how to merge cells down. Is this possible?
Safari freezes when using zoho sheet
I have been using zoho sheet for 6 months without a problem. It has been great! Thank You! For the last two weeks, I can't use zoho sheet on my mac. It opens so a can see my files, and then freezes. Fortunately, I can still access zoho sheet from my pc. I have read that this was a problem with the forum, which I discovered when I went to look for a solution. Any ideas? What has changed in the last two weeks? Thanks.
Fail to save Data
I have now tested this repeatedly: In Sheet click the sign out button. When asked if you want to save data click ok. After sign back in data is sometimes saved, sometimes not. What is going on.
Sheet Fails to Save
I have verified that Sheet sometimes saves work on request and sometimes fails allowing one to exit with either no opportunity to save or saying it will save and failing
Help function
Can anyone tell me where one finds a HELP function if there is one? Please email reply to www.levison.com Thanks!
A Simple Time Saver Calculator using Zoho Sheet
Just another example of Zoho Sheet at work - http://public.sheet.zoho.com/public/onlinebeancounter/untitled-1
Row limit on embed?
hi! thank you for this wonderful product! I have a sheet that has 33 rows, but only 32 of them are showing up in the embedded version. Is there a way to extend what is published to includ all rows? Thanks! Justin
Papelera (trash can)
En español no se dice 'Papelera vacía', sino 'Vaciar papelera', simplemente 'Vaciar', o 'Eliminar definitivamente'
Download doesn't include latest entries!
Twice in the last week I have tried to download my Zoho workbook to Excel. On both occasions it has refused to include the latest entries I have made in Zoho, yet Zoho on a close and immeduiate restart DOES include the entries; a further attempt to download STILL does not include the latest entries! This has not been the case previously. What has happened? Please help!!!
Date Format Error
While changing date format, "error 500:Internal Server Error. Please reopen the file" returns & cannot change it. Please look into this issue.
Glitch When Dividing a Negative Number
There seems to be a problem dividing negative numbers. I just tried to divide -350 by 7 (function=-350/7). The result was a dash "-". I then tried to divide +350 by 7 (function=350/7). I got the correct answer (50). Has anyone else run into this glitch when dividing negative numbers? Is there a workaround?
Change x-axis labels
Can you change the x-axis labels in a multi series chart? And if so how? Here is the link to the chart but the labels are not right on the bottom <img title='Check In Totals by Hour - http://sheet.zoho.com' alt='Check In Totals by Hour - http://sheet.zoho.com' src='http://sheet.zoho.com/publicgraphs/234983000000071065.png'>
Freeze Pane
How do I freeze pane on a row?
Apostrophe was showing as ' but now shows as '
Help! I use apostrophes quite often in the text I use in Zoho Sheet. Previously, when I pasted a copied text field that contained an apostrophe, I would see EXACTLY what I copied including the apostrophe. Now I see the apostrophe in a copied text field replaced with 'apos;'. Also previously, if I typed an apostrophe in a text field, I saw the apostrophe - now I see 'apos;' instead!!!! Don't know what's happened, but please fix!!!! Thanks and Regards Bill Hunt.
Using VBA to import csv files
Hi, Could you tell me whether it is possible to use vba code to read in csv files automatically? I would like to use zoho sheet to analyze the results of a survey - stored as several csv files. I can do this manually using the import facility but would prefer to use a macro if possible. I've tried recording my actions but this doesn't work! Other than that this is a brilliant piece of software. Andrew Tregoning
mode=html problems
The embeded sheets that utilize mode=html have been intermittently blank. Please advise...
sheet functions not working
Even the simplest functions like "=I11" are not working.
Locking Cells
To Whom It May Concern: How can I lock data into cells? ie...cells that have formulas in them that can't be erased. Cheers, Peter J. Regan pj.regan@live.com
Problem with editing shared spreadsheer
Hi, I have shared a sheet with few people, however they are not able to edit shared worksheet. They can edit any other worksheet which they create on their own.
Help on HELP
I'm probably missing a simple point, but how do I get 'Help' in Zoho Sheet? There seems to be no obvious link. A specific example of where I need help is a situation where I want to create a line chart to compare the progress of two sets of values, but appear to be allowed only a single data source (i.e. one set of values) Thanks for any enlightenment.
Row heights
I cannot get the row height format to accept a number as the row height. It keeps going back to a much larger number for a row that has several lines of wrapped text.
embedding doc version into sheet cell?
Is there a way to embed (via formula, for example) the current doc version number into a sheet cell? This would be useful for tracking when the doc version is taken out of zoho for editing/distribution (eg pdf/excel/printing).
Version Control
Hi I want to share a xls file to multiple people & Aslo I want multiple can work one the same time on this file is it possible in ZOHO
regular expressions ?
Question: How do I tell Zoho Sheet to treat a string of chars as an expression ? Background: According to the docs, it should be possible to match strings using regular expressions. For example in the COUNTIF() function. I tried it using the sample in the docs: =COUNTIF(C5:C8;"all.*") But this treats the expression as a regular string to match.
Zoho sheet corrupts data in sheet and a list of other errors encountered yesterday
Yesterday I encountered extensive data loss and corruption with Zoho sheets, finally resulting in me having to have all the users email me the data and putting it into Excel myself manually. Although I did some initial testing in the last few months, this is the first time we tried to process this data with all the users. First let me describe how I use the sheet and then I’ll list all the issues I have: I have a group of people that place orders once a month. All the data is stored in a single workbook
Share count incorrect and names duplicated on display
When i view the shared users from the sheet, the count is incorrect, it only shows 10 shared users, when I have about 30. In addition it is combining names together in the dialog box. Shared a PDF of the screen with you at support@zoho.com
questions
Team, Can you help me in the below 3 things. 1-The sort option is allowing me only to sort a row or a column. Advice me how should I sort the table ? 2-How to add / sum a full column. [ by just selecting the column name - A or B or C . . ] 3-The content entered in the find box is searched, but not shown to me and It makes me to search for the highlighted . I already discussed with Ramesh about this. Thanks, Ash ash@adventnet.com
Zoho sheet errors
The sheet i have and am sharing with 1 other user is having error messages. Only the user is receiving them every couple of mins. Error 500 and an error 12030. I was hoping to pay for this service in the future, but due to the nature of the business i cant afford to move my project over with these errors and their frequency. Is there anything you can do?
New here so please help
I am new to zoho...and i kinda don`t know how to do somethings...so someone please help me if you are nice enough to....^_^ thank you
You are Awsome
Great work guys.. add me in your team!
Embedding ZOHO Sheet files in ZOHO Creator's HTML View ...
Hi: So far my use of spreadsheet files within the ZOHO Sheet platform has been quite rudimentary ... however, I am currently developing a ZOHO Creator Application for a client that requires the contents of a Spreadsheet to be embedded within an HTML View. I was able to develop the iframe tag with the src= value that enabled me to do just that ... however, I notice that the embedded sheet "gives the appearance of being able to be edited from within the HTML View" ... i.e. the user is able to enter
Error when opening workbook, error attached
When I open the workbook I receive the following attached error. Shared document with you at support@zohosheet.com Document name is Foodbank Order Sheet (2)
Creating Financial Reports and Ratio calculator in Zoho Sheet
I have created a Financial report in Zoho Sheet with a financial ratios calculator here http://public.sheet.zoho.com/templates/kmguru/balance-sheet-template-2 . and just wanted to share with others who may be interested in this. SMBOnline 360 http://smbdashboards.wiki.zoho.com/
Error Occurred
I keep getting an "error occurred" message when I open my sheets at work, although they are fine at home on the same PC. Sometimes they open and I can make a few amendments before the error occurs. Although all other Zoho apps work fine I guess it might be a problem with our network (I'm not in the IT dept and it's a school network). When I go to a1.sheet.zoho.com they seem to work fine and changes are saved - if I work on my spreadsheets there when I'm at work would they still be safe or is this
Write over next empty cell
I wish I could write over to the next empty cell without have to use the merge cell function just like the MS Excel.
Folders in Zoho Sheet
Is there a folders function in Zoho sheet? I am comparing the functionality of Zoho Sheet with Excel. Thanks...Rick
Next Page