counting completed check boxes
Hi! I am trying to use a spreadsheet to keep track of a sequence of tasks which must be completed for each customer. I have created columns with the tasks and placed checkboxes in each column under the headings Can I: a. count the fill check boxes and have a tally of completed tasks in a column? b. count the check boxes in groups and change the colour of the box containnig the customers name, according to how faralong the sequence the check boxes have been ticked If not, is there another way to achieve
Merge and sort data from multiple tabs to a single "Master" tab
Our company was using Google Sheets for the last several months and we had a system working great, but are now looking for an alternative. Below you will find the working example Google Sheets we were using. Basically, every call we receive is logged in a spreadsheet in a tab unique to each representative. We have a CURRENT WEEK tab which is supposed to hold a static version of all the calls received by every rep, sorted by date. In Google this was done with a =query() formula, seen in A2 of the
Two Questions
First, is there any way to make the program pause 1 second before continuing to calculate? I can do it in excel but can't figure out how to do it here. I'm reasonably familiar with VBA. Also, all of my worksheets have the maximum of 65,536 rows. No matter how many I delete, it remains at 65,536. This happens in a brand new worksheet with no code as well. I only need a few hundred rows or less on these sheets.
"Document not ready. Please try again" Error message
I have been working on a spreadsheet forever and just encountered this error message. I re-open, close, tried to copy and re-open - no dice. What's the scoop? Edit: Resolved...not sure how.
Freeze 20 Rows At Top of Zoho Sheet
Hi there, I would like to freeze the top 20 rows. However, it only lets me freeze the top 5 rows. I feel like this is a very basic limitation. Is there anyway you can raise it to 25 or 30 rows? If not, can you provide a work around for me and my team. Thanks, Chad A.
freeze in androide
why freeze doesnt show on ondroid ??? thanks
change the backgroung color (gray) of the locked cells in spread sheets
Hi, Is it possible to change or remove the backgroung color (gray) of the locked cells in zoho spreadsheets ? thanks
Losing Content and Slow System
Our company only uses the zoho docs, specifically the spreadsheets, and we have been experiencing a large delay between typing content and seeing it appear on the sheet. We have also been experiencing the loss of content after leaving the sheet. It would be a big help if we could receive some guidance with these issues. Something to note, we have a large quantity of sheets in each spreadsheet booklet that we use.
spreadsheet can not be opened usin zoho sheet as it exceeds the maximum limit of 56
Dear Team Spreadsheet created with 4 or 5 columns and rows, but after uploading into Zoho Docs, it is showing error while opening the same. Please let us know the resolution on the same.
Zoho Spreadsheet as an input tool
Hi, I'd like to set up a zoho spreadsheet for the purpose of using it as a data source. I want to collaborate with other users to input data into the spreadsheet. Is it possible to establish a connection in Excel and link an Excel spreadsheet to an online Zoho sheet? This way, I could maintain the data in the spreadsheet on Zoho to leverage collaboration with others. For advanced data manipulation and reporting I want to use Excel, so I need to have an easy way to transfer data from Zoho to an Excel
Limits of Sheets
Hello, we are new on Zoho Docs / Sheets. Is there some information about "limits" - max. formula, etc.? Thank you :)
Import data from a web using sheet
Hello. I want import data from a web http://www.aemet.es/es/eltiempo/observacion/ultimosdatos?k=clm&l=3260B&w=0&datos=det I can import the data in two formats: Excel or CSV. When I do the import, some data appear with different format. I don't know why does this. I want also append data from every day in the same sheet, but this I don't konw how can do it. Help?
Can't log into my account
I can't log into my account using my email address and password so I tried to reset the password but the system just returns with a message saying that there is no such user. I'm sure that I'm using the right email address because I still have the email from Zoho through this email address when I reset the password from last time. While I can't open any Spreadsheet I created, I'm still be able to see and edit Spreadsheet that other users shared with me and at the right corner of the screen it still
Month/Year (date format) not available in spreadsheet
Month/Year (date format) not available in spreadsheet Example: March 2015 automatically becomes 1st March 2016.
Alignment problem in spreadsheet
Hi, I have just got my cell texts aligned right to left in all my sheets in Zoho Docs. It's impossible to align my texts manually, it's always fixed in right to left, is it a known issue ?
Conditional formatting does not appear in shared sheet.
Hi all! I 've shared a part of a spreadsheet i created to a forum but the various conditional formats do not appear. All data and formatting is visible as normal but not conditional formatting, for example the highest value of a list that's highlighted. Is this normal? Thanks, Mike
Forum responses in Sheet, Update new row of data entry with existing calculation formula
Hi guys, ZOHO is pretty amazing! I'm working on a small project for my class where i put out a survey form and gather data into the sheet. within the response sheet there are several calculations i put in the cells, Everything works great except whenever there is a new data entry from the form it adds a new row and won't automatically apply the formulas to the new data. Is there a way to automatically update the sheet when i get a new responses from the survey form? Cheers Weiqi
CSV files Windows sync vs. Upload
When I upload CSV file I can open it. When I sync same file with ZohoSync for Windows I can't. Is there solutions ?
Lost spreadsheet
Good evening After a few months without entering en Zoho a cannot find my spreadsheet. It is still in Zoho because a person a had shared it with passed me the link I had given her, but when I enter in my account I cannot find it. I guess it's only because I don't know where to look. Thanks for your help
Problem with editing cells
Hi Zoho ladies and gents, I'm having issues with editing spreadsheet cells. If I try to modify existing text or numbers in the top bar as usual, I can't--it just types my new text as if the cell is starting off empty. In other words, let's say my cell read dollrs and I want to add an 'a'. I click where I want to put it and type 'a'. Instead of 'dollars', I just have a Sometimes I can undo and at least save the existing text so I can modify it elsewhere, but much of the time, I end up having to retype
Multiple conditions in SUMIF
Hi, I need to sum a set of data based on three different conditions. All three conditions should be satisfied in order for the data to be summed up. I tried with SUMIF, but it seems to support only one condition. How can I do this? Kalpa Pathum Welivitigoda http://about.me/callkalpa
WANTED: someone to convert multipage Excel 2007 spreadsheet with multiple macros and buttons
Hi, I want to upload an excel spreadsheet that has multiple pages. It also has multiple macros and page buttons. The macros are primarily for formatting the pages for display and printing. I want to hire someone to convert the spreadsheet with all of its macros to ZOHO Docs spreadsheet and recreate the buttons and make the macros work. Anyone interested? Pierre 904-338-7295
Problem with cell editing
I have a problem with cell editing - lets say I typed a word into a cell but then need to make an addition - the cell will only show me the first word i typed in the cell (and the addition will appear in the "insert function" line above my spreadsheet)??? Also I don't seem to then be able to delete the original word i typed in. This is annoying as I need to see complete content of cell as typed in and not ONLY when I click the cell! Also, where is the "wrap text" cell function? Thank you. B
Invalid arguments: Object required
Hi, I am getting the following error in my macro code Invalid arguments: Object required Set objEmail = CreateObject("CDO.Message") Can you please help me how to create it use inside zoho docs Thanks Sarik
Where do my documents appear once I've saved them? And how can I access my templates?
I created a spreadsheet in Zoho Docs and saved it. Then I decided that I wanted to create a template from that to be used for other customers. I saved it as a template, but now I cannot find it (yes, I've tried "All Files" in the Documents tab). Then I tried using Save As to create a blank copy, figuring we could just open the blank one and use Save As again for future versions and customers, but again, it's nowhere to be found! (Side note: they do appear here to be attached as an example, but I
Cannot edit spreadsheet
I am trying to edit a spreadsheet on my web browser (Chromium 43.0.2357.6) but when I click on it it just comes up with preview not available and the only option is to download it. I am able to edit other spreadsheet and documents without any issues. Thanks
Spreadsheet Row Height keeps changing.
Every few days, the row height of our spreadsheets will go from 25 to 17 without us doing anything. Sometimes it will happen on one spreadsheet and sometimes, it will happen on all spreadsheets. Any reason for this? It always changes it to 17. Let me know. Thanks!! Laura
Problem with currency format dropping trailing 0s
Hi Zoho, In my spreadsheets, when I choose a 2-decimal-place currency format, quite frequently recently, trailing zeros are simply dropped in new entries (if they're in existing entries, they seem to stay). They show up again if I go back to Format and rechoose 2 decimal places, but I shouldn't have to. As an example, a new column of numbers I add appears as: $5.5 $6.27 $19 Instead of $5.50 $6.27 $19.00 This started happening a few months ago, just haven't asked about it until now.
G-Sheet to Excel?
~ 9 months ago I created the Google Sheet which I continue to fill with daily data. Then I performed these actions: File -> Download As -> Microsoft Excel (.xlsx), uploaded the file to Excel Online and saw my G-Sheet converted almost perfect. My main chart was clear. Since then MSFT or GOOG made some changes that now I don't get the conversion working anymore. Is it on purpose? Competition? I decided to try to use Zoho as mediator to accomplish the conversion. But it does not go anywhere, because
The Effect of Investment Expenses on a Portfolio - Spreadsheet graph problem
I am compiling a spreadsheet on 'The Effect of Investment Expenses on a Portfolio' Having difficulty with the graph as when I go to print I get numerous 14 digit numbers obscuring the graph I have tried changing the settings but nothing works Also cannot delete the 'Enter your values here' title as it keeps reappearing Help please
Referencing and other sheet with SUMIFS
Hi there, I'm unable to get the following code to work properly on zoho sheet. It works perfect on excel. But something about the pasting the formula to sheets is not working. =SUMIFS(Sheet1!I:I,Sheet1!J:J,">"&TODAY()-1)-SUMIFS(Sheet1!I:I,Sheet1!J:J,">"&TODAY()) I tried using the "dot" instead of exclamation. But, it seems like this not reading. =SUMIFS(Sheet1.I:I,Sheet1.J:J,">"&TODAY()-1)-SUMIFS(Sheet1.I:I,Sheet1.J:J,">"&TODAY()) Also, I tried specifying the cells on the same sheet. Didn't work:
can i share view of my xlsx doc online without a download
can I share view of my xlsx doc online publicly without a download if so how nothing seems to work
Advanced "Chart" engine with Auto-detection, Auto-expansion and Trendlines
Zoho Sheet has upgraded to a more powerful Chart engine with vibrant features to improve your charting experience. Auto-detect Chart ranges Charts in Zoho Sheet are as intelligent as its users. Just click on a cell anywhere in the range and go ahead and insert a chart, Zoho Sheet automatically detects the range. The feature is extremely useful when the data range is large and saves you from selection hassles. In case of non-contiguous data, it is also possible to manually enter the range in the 'Add
Link to data in another file
How do I create a formula to link to a cell in a different file? In the MS application I would simply enter the formula =SUM(and click on the cell in a different file and press enter)
Spreadsheet date functions
Hello All, Are there any of the following functions available: - Day of week - Month name Thank you. Edo.
Remote Server refused to save Sheet and Pres Documents
Hi, I use Zoho Editor with remote API code under PYDIO server 6.20 I can create any document as well as writer, sheet and pres I can save only writer document, but not able with sheet and show. Why ?? In the file named : ../pydio/plugings/editor.zoho/class.ZohoEditor.php I can see this part of code ! (…) $service = “exportwriter”; if (in_array($extension, $sheetExt)) { $service = “sheet”; } else if (in_array($extension, $presExt)) { $service = “show”; } else if (in_array($extension, $docExt)) { $service
Speed
Hi, I'm using one spreadsheet with may different sheets in it. It has a lot of colums in it and nearly every cell has a conditional formatting formula. The sheet is very slow in loading and in editing. One may type a letter in a cell, but you can only see it after a few seconds! This is very annoying and time consuming. I wanted to know wheater the speed issue has something to do with the conditional formatting, I have made a copy of the original and removed all of the cond format. And it's much
Question regarding input controls checkboxes
I have imported an Excel spreadsheet to Zoho Sheet. Upon import, everything looks great except the checkboxes did not import. I can see in Zoho Sheet where I can add input controls that appear as check boxes, but I need to add functionality. For example, the checkbox ideally links to a cell elsewhere in the spreadsheet. If the checkbox is checked (TRUE state), then this influences the grand total. In Excel, you do this by right-clicking and selecting Format Control where you can establish a cell
Locking specific cells in Zoho spreadsheet
Hi, I'd like to embed a spreadsheet on my website with a formula in it. Users can then key in variables and find out what kinds of values the formula throws up. Is there any way I can lock specific cells (and not every cell) in the spreadsheet? This is because I'll need these constants to calculate the formula. Thanks, L
Can't access my docs??
I can't access my docs this morning. I know Zoho is having email troubles and is in the middle of the Chennai floods, so I'm assuming this is due to those problems, but just wanted to make sure. Is anyone else unable to get to their Zoho docs?
Next Page