Feature Data Validation doesn't work on Handy App
I'm using data validation with area on my spreadsheet. Works great when I'm in the browser, but if I'm in the app, there's no dropdown box showing the valid entries. Even more, it doesn't accept correct entries.
COUNTIF function returning #NULL!
all of the COUNTIF functions that I have in my sheets are returning #NULL! when they worked just fine yesterday. =COUNTIF(P3.H$1:H$5036;"In") is there something wrong with that function now?
What about the error #NULL in excel?
How can i fix about #NULL error?
countif function with compare
In a spreadsheet I would like to count the numbers of occurences that values in an area are greater or equal than a compare value. Both the area and the compare value are referenced. Example: The area is B3:K3 The compare value is in cell A2 In Cell A1 I would like to display the number of occurences, so I'd expect to use a formula like this in cell A1: =countif(B3:K3;??>=A2) Doesn't work as countif compares only values or expressions. Is there any workaround?
Publish only one sheet, not the others
A calculation table can have multiple sheets, I'm using this extensively with cross references to each other. Great! Now the problem: I'd like to publish only one of a few sheets of a calculation. Up to now I can either publish ALL sheets or none. It there any way to make this possible, may be by referencing from another table?
How can I determine the person who is currently working in the spreadsheet
I'd like to generate a "Last Change when/who" entry in a spreadsheet. I was successful with time/date but I have no clues how to find out who is the person who was doing the change. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = false On Error Goto ENEV range("LastChangeDateTime").Value=Now ' <- this works perfect range("LastChangePerson").Value=???? ' <- what should I enter here? ENEV: Application.EnableEvents = true End Sub
lock cell/sheets for shared access
Hi Is there a way to lock a cell or cell range or sheet so it can not be edited by others. Currently the lock also locks me (the owner of the sheet) out as well.
Why can't I addin Visual Basic? I'm sure its simple...
My code: c_size = application.counta(Worksheets("Sheet1").range("a1:a999")) c_size = c_size+1 My error: Encountered "1" at line 49, column 21.Was expecting one of: <NL>, ":", "&", <DOT>, "^", "(", "-", "+", "=", ">", "<", ">=", "<=", "<>", "\\", "/", "*", "IS", "LIKE", "MOD", "AND", "OR", "XOR", "EQV", "IMP", What am I missing?
Request: Option to Export to Google docs
Hello, I see there is an option to import a sheet from Google docs. I see the Export option has quite a few formats where a sheet in Zoho can be exported to however, it does not have the option to export to Google docs. Would it be possible to put this request into your roadmap? -- Thank you, TXTNLRN Dan text or call: 512-850-4898 Web site: http://www.TXTNLRN.com Teaching and learning through text messages. TXTNLRN Introduction Demo presentation - http://goo.gl/z1MJO or Get to know TXTNLRN http://screenr.com/7yS8
Opening Multiple URLs or Hyperlinks In Zoho Sheet
Hi there, I have a long list of urls in a spreadsheet: http://facebook.com http://perfectclicks.com http://twitter.com Problem: When I click on each one, it opens in a new tab and automatically takes me to that tab. This makes it very slow to open a long list of urls. Potential Fix #1: Can I stay on the current tab when clicking a hyperlink? There should be an option to uncheck "When I open a link in a new tab, switch to it immediately" just like Firefox has. Or, a short cut for this would be great.
display sheets by crm user
Is it possible to authenticate a crm user so that they can see either certain columns and rows or tabs? Thanks
Customizable Charts in Zoho Sheet
Now, create charts the way you want. Show your analysis effectively by picking colors of your choice for various elements of the chart. Visually appealing charts Set colorful backgrounds for your charts. Choose from a wide range of colors for plots, series, titles and subtitles. Choose 'Edit' mode to edit charts with just a click. With the new chart enhancements you can change the color, size, format and font of texts in charts by clicking them. Note: Avoid unintended changes to charts, using the
Impossible to use basic http auth in external data link.
If for example I set https://user:password@example.com/api/data.csv in external data link, a warning says that URL is invalid. Why ?
Can't pablish spreadsheet in Zoho Connect
I have access as administration. In case a document is all ok. In case spreadsheet can't. But for owner all ok, for administaror isn't.
Updating an embedded Zoho spreadsheet
Hi, I have successfully embedded a Zoho spreadsheet on a (password protected) webpage on my site. I would like people visiting the page to be able to update the spreadsheet, but can not find a way to do this. The spreadsheet says ‘NOTE: Any changes that you make will not be saved to the original document.’ Is it possible to change the settings for the embedded sheet so that changes CAN be saved? Thanks for any thoughts. Peter
match or vlookup substring in a cell
Hi Support few cells has a values like MOC-Apple-iPhone-SE-1 MOC-Apple-iPhone-SE-2 MOC-Apple-iPhone-SE-3 MOC-Apple-iPhone-SE-4 I want to count the no cells which contains MOC-Apple-iPhone-SE- how do i do that at the end result should be 4
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
Next Page