Shared File - How to input the collaborator user name when inputting data
Hi, I have created a file which is shared by a few collaborators. The file comprises a few macros which upon clicking on a button will input rows of data from a source sheet to a target sheet. Assuming each row is comprised of 10 fields, upon clicking this button, these fields will be populated in 10 target columns of the target sheet. I would like for this macro to populate an 11th column with the system username of the collaborator using the spreadsheet but can't find a solution. Many thanks
Currency Conversion
Hello, I'm imported a spreadsheet from Google Docs which included currency conversion but now on Zoho Docs, that currency conversion is broken which has subsequently broken the spreadsheet. Is there a formula or another function I can use to replace this functionality? Thanks.
is there a currency converter fuction like google spreadsheet =GoogleFinance("CURRENCY:EURUSD")?
is there a currency converter fuction like google spreadsheet =GoogleFinance("CURRENCY:EURUSD")?
Hide Column and Row Headings in Zoho Spreadsheet
Hello, I am just trialling Zoho but I need to hide the column and row headings before I purchase Zoho. Is there a way to achieve this? Thanks
FV
Hi folks, I am looking for some help. I am making a loan calculator and if I use a number with two decimal places for the year I do not get an accurate FV. If I use 1 decimal place there is no issues. ie I can use 3.5 without a problem but if I use 3.49 the results do not match what excel produces for FV. I am a bit OCD with things having to be perfect so this is not really acceptable for me. Any suggestions?
Moving values between pages
Is there any way to move/copy values between pages ?
New Release - Gray Theme, Improved Collaboration and more
We are pleased to announce the new release of Zoho Sheet with the following new features, new UI and enhancements. New Gray Theme Where is the Save button? New Sharing Options Improved Realtime Collaboration Spreadsheet Settings (Locale and Time Zone) Paste Special Typeahead / Auto Completion New Gray Theme Zoho Sheet now sports a gray theme in tune with Zoho Writer and Zoho Docs giving you a more standardized user experience. Do you like the new gray theme? Let us know whether you like it or not
Upload a 410kb VBA Macro
I got a 410kb excel macro when upload in zoho can't use it, just downloading. Why does not it happen before with 2 macros loaded months ago?
Zoho Sheet not exporting or printing images in spreadsheet
I have a spreadsheet that automatically generates a proposal form for my business and at the top we use our company logo. I put the logo into the spreadsheet using "Insert -> Image" but when I either export to PDF or try to print, the image is not there. How can I rectify this situation?
Conditional Formatting & Data Validation
Hello. I'm a relative newcomer to Zoho Sheet and I was wondering if there are any plans to add Conditional Formatting and Data Validation functionality in the near future? I understand that these can be achieved by creating macros, but this seems rather an unwieldy way to go about it, and not really an option for an inexperienced user. We're investigating the plausibility in migrating to Zoho from Google apps. A large part of the type of spreadsheets we use rely heavily on the implementation of conditional
Urgent requirement - Data Validation & Sheet Protection
In addition to "drop down menu lists", the other important features required in Zoho sheet is "Data Validation" and "Sheet Protection" to make it really useful. It will surely lead to increase of public usage of Zoho sheets.
Data Validation
Hi, I have been trying to insert data validation in my excel document but i cant find the option,.... can anybody help me with that... as when i upload the file with data validation enabled it appears as a plain file with no functions... Its a little urgent can anybody help me with that...
Data Validation
Problem description: I have a shared sheet with my colleagues and they keep on entering different date format, even in text format. Suggestion: Can we have a data validation function per cell so we can have users entering only specific data types (ie. date) into a cell? This will be great, thank you in advance.
How do I validate data
Anyone worked out how to validate data in ZOHO?
Function not updated after deleting rows
Hi, I was working with a spreadsheet when I noticed a small issue. I have some numbers in row 1, 2 and 3 and a function in row 4 (=SUM(A1:A3)) Now when I delete row 3 I expect the function to update to =SUM(A1:A2), instead it is unchanged (just moved up to row 3) and gives a #CIRCULARREF! error. Regards, Rob
Data Validation / Drop-down lists
Hi Zoho, I have read requests in previous threads going back around 2 years for this feature. Do you have any update on this, or perhaps could you suggest a work-around that I could use to re-create the feature that I'm using in an Excel sheet? Many thanks, Dean
Docs unavalible.
The docs and all spreadsheets are unavailable . When I push the link for docs, nothing appears.
Zoho Sheets
I have s sheet embedded in my blog. It does some calculation and user can input numbers. My question is can numerous people on the Internet use it at the same time without causing issues with the results?
New in Zoho Sheet: Text to Columns, Filter by Color, Range Selector and more
Last week, we released an update to Zoho Sheet with the following new features and enhancements: Text to Columns Filter by Color (and other enhancements to Auto Filter) Range Selector Filter by Cell Range in Manage Rules of Conditional Formatting And here are a couple of features released in end of January: Notify Collaborators Save to Folder Lets look at each of them in detail: 1. Text to Columns: The 'Text to Columns' functionality (available under the Data tab) lets you to split data in cells
Document Not Saving
Whenever I try to edit a few of my spreadsheets, it says "Your edit is not applied to the document. Please try again later." It has been saying that all day. The documents in question are 'clangoal' and 'clangoalafrobros'. Wasn't sure if this was a global issue or not, so thought to post it here to find out.
Help
I cant open my spreadsheets ? Sorry, We could not process your request ! Possible reasons: › The URL may be incorrect. › The spreadsheet might have been removed. › You do not have access to this spreadsheet. Why? Gil
I cannot open any of my sheets
All of my sheets are unavailable. I get a message stating "We are unable to open.." It offer to let me try to restore to a previous revision but of course that does nothing. I would really appreciate having my docs back. These are shared publicly and the tool is completely broken.
Concatenate
Can someone help me create the correct formula? I want to concatenate the following URL with the text in a cell. Example: I want to combine the following URL with cell A2. Anyone help? https://ahrefs.com/site-explorer/overview/subdomains/
How To - Creating a new list based on conditions
Hello, I am trying to "Creating a new list based on conditions" where I want to use DATA from Sheet A and a Criteria I define to build a new list on Sheet B. This is demonstrated for MS Excel at: http://www.excelforum.com/excel-formulas-and-functions/646118-creating-a-new-list-based-on-conditions.html#post1926757 How is this possible in ZOCO Sheet please?
ZohoSheets
Hello I have embedded a zoho sheet in my website but at the top of the sheet it says "save to excel" and also "Powered by Zoho". I want to remove both of these items. Please can you tell me how to do this. Thanks
Spreadsheet problems on Airset
I am an Airset subscriber and I use one Zoho spreadsheet to manage some data. Two problems are occurring: 1. When I edit a spreadsheet then save it I get a message saying, "Unable to safe spreadsheet." However, if I close the spread sheet and reopen it either in View or Edit mode the changes are there. 2. Today I was trying to insert a row and NONE of the methods to insert a row will work. The most that happens is that the line focus shifts down or up one line depending on which insert I clicked.
can't print spreadsheet from Zoho Sheet
Hello, I can't either print or download spreadsheet which I upload on my own. When I'm trying to download it, I get attached error message. And options "Print..." and "Export as" are greyed out in menu. Does it depend on my organization settings? Where administrator can change it? I actually don't have access to my documents, only view. Regards Eve
ZOHO
WANT FULL SCREEN DOESN'T OPEN SPREADSHEET THE SAME AS EXCEL, TOO SMALL. wjhowell
Long text fields being truncated in Zoho Sheet
We were waffling on whether to use Zoho Docs or Google Docs and had tentatively decided to go with Google Docs. Yet, when I discovered the problem with Goggle Spreadsheet where long text fields are truncated upon view even when the adjacent cells are empty, I started thinking that maybe Zoho Docs was a better solution. Yet, this same problem seems to exist with Zoho Sheet. Is there any resolution to this problem with Zoho? Below are some links related to the problem in Google Spreadsheet: https://productforums.google.com/forum/#!topic/docs/20xY1KEjFxo
My file won't load
When I try to open my spreadsheet the screen says "loading" but the file never actually loads. I have information in the file that I would like to access but I cannot. Please help. (I've attached a screen shot).
Can I hide the VBA code of sheet that is being shared with the public?
Can I hide the VBA code of sheet that is being shared with the public? How is that done? Thanks you very much ^_^
xlsx Error
I am unable to open a spreadsheet and got the attached error message.
Public Spreadsheet.
Hi I want to create a spreadsheet where random people can input random names (not case sensitive) into a field, then that name will be input into the spreadsheet, if exists then it increments a count for that name and if not inputs the new name to a new line in a specific column. Is this possible in excel or do i need a database of some kind? Could anyone send me some examples of formula if it is possible? thanks
#FN_NOT_SUPPORTED - VLOOKUP & ISNA
Hi, I have the following VLOOKUP reference working ok in Excel 2013 however an issue using Zoho Docs. I have change the "0" to FALSE however now instead of #FN_NOT_SUPPORTED i'm getting #NAME! Here is the cell MS Excel =IF(ISNA(VLOOKUP($Q10,Interest!$D:$E,2,FALSE)),"",VLOOKUP($Q10,Interest!$D:$E,2,FALSE)) Zoho Conversion =IF(ISNA(VLOOKUP($Q10;interest!$d:$e;2;0));"";VLOOKUP($Q10;interest!$d:$e;2;0)) Zoho Amendment =IF(ISNA(VLOOKUP($Q10;interest!$d:$e;2;FALSE));"";VLOOKUP($Q10;interest!$d:$e;2;FALSE))
Zoho Docs stick words in some parragraphs in Excel File
Hello Guys, I have a problem, some times, when we upload an Excel file, we begin working on the file, and when we finish the job, we check the file, and we find some few words are sticked, the words are together without space, and we didn't it. It is something related to the formating, i guess. But this issue is doing to waste a lot of time, fixing our translations, once it has been finished. May you help us? Director www.TECNOSeguro.com
Hotkeys or SendKeys options in Zoho?
I don't know much about writing macros or VBA encoding but I would like to know a method to popup the comment box of a an active cell with a macro. I know that I can do it pressing Shift + F2. But my colleges in the company asked me to create a button in the spreadsheet to do the thing. I made it successfully in excel using the "SendKeys" method of VBA. If there is any way to create a button that pop ups the comment box and put it ready to edit it (the same as Shift + F2 combination) I will appreciate
How can I make a "SaveAs" or a "Export as" macro?
When I look at the methods supported by Zoho VBA, it appears "SaveAs" and "Save" method, but when I try to create a macro writing the code, it doesn't work. It says that is not supported. I'm trying to make a sheet for my company which data changes all the time and need to save a copy in pdf format several times a day. I know I can do it manually, but due the nature of the work is necessary to do that task just clicking a button in the spreadsheet. I have others issues to solve, but I'll do it in
upload/save multiple sheets -- Storage API
Hi, I am just wondering is there any way to upload(new) a workbook with multiple sheets through API? or to save a workbook with multiple sheets through API? Thanks, Sasi
External Data Does Not Update
I have 3 external data links within my spreadsheet. Of late they do not seem to be updating my public display link, but when I access the file(spreadsheet doc) itself the figures have updated. The update is set up on daily with a 1 minute interval space for each external data link (22:52 & 22:53 & 22:54) Does anyone else have problems with external data not updating their public viewing sheet? How do I go about getting it to update daily, instead of me actually opening the file (spreadsheet doc)
Publish to PDF 2 sheets out of 10
Is there a quick way to publish to PDF only 2 out of 10 sheets rather than the all the sheets?
Next Page