conditional formatting bug in zoho sheets
To whom it may concern, I have experienced on numerous occasions lately a problem in Zoho Sheets where the conditional formatting within a spreadsheet automatically disappears on a periodic basis. Needless to say, it is frustrating to have to redo all previous work and be unable to rely upon Zoho Sheets as a viable alternative for generating reports and presenting data. Is your staff aware of this problem and, if so, does it plan to fix it anytime soon? Thank you kindly, JCH
Save Function for embedded excel Sheets
I have managed to embed an excel file that was uploaded to Zoho. It's just a simple spreadsheet with milestones that need to be met versus employees. Once complete they have to option to click the dropdown and select an option but for some reason, I can not figure out how to get it to save after they update it. Basically we change one selection, refresh page and it just shows the original document and publishing it just seems to show the image. Thanks
Integration with PHP web application
Hi, I am creating a web application using PHP where users can upload, view and edit documents. Documents will be kept on Linux server where the web application will be kept. I have started developing it and got the AuthToken however got stuck after this. I am following instructions given at https://www.zoho.com/docs/zoho-docs-api.html Is there any sample PHP code for reference ? Thanks, Dan
CRM Documents
Hello Is there a way to change the left side navigation bar in ZOHO CR Documents? on our page https://crm.zoho.com/crm/ShowDetails.do?module=Documents I have our documents separated in their respective folders But when a users login the document view is confusing for them because they sell all documents by default The top 2 selections do not show the folders. How can I make the defaulft documents view to be the "Document Library" Please see screen shot
Comments disappear
Every time i save a sheet and then reopen the sheet in zoho, the comments disappear. Is there anything we can do to keep this from happening? Thanks, Len
Viewing Shared Sheets in Zoho Mobile
Hi! I share several workbooks in Zoho Sheet currently with groups I have set up. I recently found out that these individuals can't view the sheets in Zoho Mobile. Is there a function to allow them to also be able to view these sheets in the mobile verison? It would be very helpful! Thanks!
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?
disable auto-save
While testing a new sheet I often want to quit without saving if a new idea does not work out, but with autosave, I keep getting stuck with mods I don't want. Can I disable autosave?
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
Next Page