Important feature such as cross-workbook reference or ImportRange?
Hello Is there a feature in zoho sheet that allows cross-workbook reference or ImportRange? If not, is there any plan to release this kind of feature in the near future? If there is not such feature, why people will come to Zoho from Google Apps? Zorge
consolidating data out of several zoho sheets like Google Docs importrange
Hello, One of our Zoho customers, we are Zoho alliance partner, wants to move its office docs to zoho-sheets but they ran into a problem. Situation, see screenshot Imagine we have 3 sheets with different filenames and different data. How can we collect data from each sheet and merge it all together in 1 like shown on the screenshot. At google docs now they use Google Docs and their code is: @Googledocs "=importrange(.....,.....)" where dots refer to or are URL-based links to cells in different sheets
Idea : Ability to mark certain rows as title rows (heading1, heading2 et al) just like in MS Word
Namaskaram. Sheet remains close to our heart as one of the most popular go-to apps for anything under the sun! ☀️Having said that, it's useful to have the ability to mark certain rows as say 'Heading 1' rows, 'Heading 2' rows and so on, just like we do in Word/Zoho Writer or any document editing tool for that matter. This would help organise Sheet content much better. Also there could be allied features like, say, when I scroll, the heading rows could freeze on the top when the corresponding content
XLOOKUP, XMATCH, and six more robust new functions!
XLOOKUP, XMATCH, and six more robust new functions! Hello everybody! Zoho Sheet has introduced eight new functions to help you create more sophisticated, efficient spreadsheets. Let's take a look at these functions and their usage. Let us know in the comments how you plan to use them in your spreadsheets! XLOOKUP (lookup_value; search_table; result_table; [if_not_found]; [match_mode]; [search_mode]) VLOOKUP, one of Zoho Sheet's most used functions, has helped people create reports or instantly look
How to access a different workbook in a different folder using VBA
Hi I have an sheet application written in VBA. One of the tasks is to import data from another workbook . The workbook containing the data is in a different folder ( both on the cloud ) ( relative path is ../Dir/Workbook ) . How can this be done using VBA in sheets.
Spreadsheet
Is their a way to set up alternate colors (by row) to give the spreadsheet the look of a check register ? Thanks, Bruce
An edit in Sheets is not being updated in CRM
An edit in Sheets is not being updated in CRM. Does the Sheet need to be manually re-imported?
Introducing Race Charts: a smart way to visualize historic data
Visualizing data recorded over a long period of time just got more interesting! We're excited to introduce Race Charts to Zoho Sheet's already extensive chart family. With our built-in data visualization feature, you can quickly create a bar chart race that animates continuously where the bars race against each other based on the data—no extra coding or add-ons required! These animated bar charts jazz up your spreadsheets while you sit back and watch your data come to life. But why stop there?
Moving all users to the new Zoho Sheet
Hello everyone! We introduced the latest version of Zoho Sheet—Sheet 5—in early 2019. This new version consists of a new user interface, improved performance, and an array of useful features. The old version of Zoho Sheet will be deprecated permanently on February 29, 2020, a year after Sheet 5 was introduced. After February 29, 2020, all users of the old version will be moved to the new version, and you will no longer be able to switch back to the old version. Update: All users will be moved to
Sheets Templates
Our company has multiple excel templates that many people have access to use. When a user uses the template they must save it as something else to keep the template clean. I have created a template in sheets but I have not seen a way to keep it clean using sheets. How can we keep the template to remain clean after each use. i did not find a way to do that, when the sheet was closed out and reopened it had the previous use information in it and that is not what we want to happen. Is there a way
Indent?
How can we indent in a cell? Simply prepending spaces does not work, as they're stripped, and that isn't the right answer anyway. No change since 2008? http://forums.zohonotebook.com/forumHome.do?forumGroupId=2266000000002001&forumTopicId=2266000000120088 This is pretty much a staple of all financial spreadsheets...and makes Zoho Sheet really impossible to use without it. Hopefully I'm just missing something!
Zoho Docs reporting "Something went wrong and we're unable to generate a preview."
Since 2012. I've been using Zoho Docs to edit this spreadsheet and had no problem until couple of days ago. I can't open the document because I constantly get an error "Something went wrong and we're unable to generate a preview.". I've tried to press the download button but I've only got the message "Preparing to download..." which disappears after few seconds without initiating the download. Then I've tried to press "Open with Zoho sheet" and after pressing "Continue" button, again nothing happen.
Zoho sheet cell lock option
Frds in my zoho sheet, there is no lock cell option appearing at all.
[New Version of Spreadsheets] How to make text overflow into adjacent cells?
I recently changed to new version of spreadsheets, the team has done a excellent job! Now its much more responsive and faster while making changes . But I am having a big issue, all the cells are by default formatted to have no text overflow to adjacent empty cells . This has made my old spreadsheets look very different and not as it was intended at the time of creation. Is there any way to permit text overflow?
Slow sheets...WHY!?
PLEASE resolve my slow sheet issues? When I enter data it's like I have slow internet or something BUT I don't. I have a wired desktop with Gigabit data speeds. However, every entry is so slow! What's up?! I heard that sheets with too many cuts and pastes might be the issue. How to I refresh this or something? I can't last much longer operating like this! I'm about to find a microsoft or apple solution if you don't do something quick.
Why is the csv.-display from my file in Zoho different in compare to Excel?
Hello my dear community, I hope, you can help me with my question.:) Like you see in my two attached pictures, the display is different, although, it is the same file. With Zoho, everything is allright. But in Excel, the display seems chaotic and I don´t know why. Maybe, anybody knows the reason for this difference? Thank you very much in advance for your help. Best wishes to all of you. Andreas
Zoho Sheets - Spreadsheet loses cell borders by itself
Hi, I have an issue happening with one spreadsheet that is losing cell border formatting by itself. This spreadsheet is shared between some users, but they're not removing the formatting on the sheet, according to file history. For example, this morning the file had unfomatted cell borders (image attached to the post), and then like 5 hours after fixing the cell borders, they unformatted again. Sometimes I try closing the file and the opening again when formatting issues appear on the sheet, but
One page of sheet won't load
Hello, I have a Zoho Sheets file with two spreadsheet pages. The first page works fine, but starting about 2 weeks ago, the second sheet won't load. I can click on it but it just says "loading" and doesn't open. It is only about 200 lines, not a large file at all. Can you help? Regards, Ellen Robare
CRM info -> Zoho Sheets
Does anyone know how to connect information in Zoho CRM to autofill within a Zoho sheet, like it would in Zoho forms? We are filling in fields the same fields for multiple locations and the ability to copy/paste from row to row makes these much easier for customers. We basically want to place a button in the CRM to email the sheet automatically with specific information from the CRM already completed in the sheet and then allow the client to fill in the information for multiple locations - some
printing sheets
Cannot print whole page all of the sudden.
zoho sheet too slow
this takes for ever to load on edge, is there any issue?
counting cells with a dash
I seem to be stuck on using a wildcard character. Across a range I want to count how many instances of the dash "-" character. I tried this and it does not work: =COUNTIF(B4:R6;"*-*") Can someone help me with this one? Thanks, Jeff
Drop down
Hey there! Is there any way one can create a drop down list with spreadsheets? Thanks!
Sorry! We are unable to send the notification due to an unknown error. Please try again or later.
Hello, I have this problem, and I don´t know why. (Attached file)
Filtering without other users seeing / view only mode?
I would like to find a setting that allows me to filter the spreadsheet without other collaborators seeing what I have filtered. I do not need to be able to change anything while in that view, just be able to see various filters without messing up their filters. Is there a way to do this?
Conditional Formatting
Hello - I need some help with conditional formatting: I have a sheet that I need to run (2) rules - 1 for an entire row, and then a second rule that runs for each cell. Basically, we want to be sure the person using the sheet knows what they need to fill in - if there is no information in the cell, it needs to be highlighted. However, I do not want the entire sheet to be highlighted before they start filling out the sheet. I need the rules set up as follows: 1. If the first cell in the row has information
My filter is not showing all searchable results
it seems to be pulling only a few results and not all plus some non existent ones. There is options for 1 2 3 4 see attached doc for details https://sheet.zoho.com/sheet/published.do?rid=hdjgm0b510400ff1d463fbe89a56cb8f7062a Its the same for all three filters i want
Conditional Formating for times within 1 hour and times within 15 min
So on my spreadsheet I am documenting when upcoming changeovers are happening. so in the spread sheet I have a cell that just tells current time using the =now() formula. Then I enter in what time a change over is going to occur. What I want to happen is when the change over is an hour away from current time I want that cell to turn yellow then when the changeover is 15 min away from current time I want it to change red. I tried numerous formulas that i thought would work but did not.
Zoom in and out of spreadsheet
Is there a way to zoom in and out to see less or more of your spreadsheet. Sometimes the spread sheets very large and I need to see more or less of it.
Play/pause control on Mac
Hi! How to prevent Zoho Sheets from keeping control on play/pause keys on Mac? Music applet lost control. Zoho sheets shown in notification panel as "Playing now".
What should be the content type and http body format for zoho sheet upload rest api call? Has anyone implemented it?
What should be the content type and http body format for zoho sheet upload rest api call? Has anyone implemented it?
Account is Disabled Error
Hello Evertime I try and login with my account I get and "Account is Disabled" error. How do I fix this. I love Zoho and am activly using Reports and CRM and want to start using Sheet. Thanks! Jeremiah
Scan hard copies of receipts and convert them into spreadsheets
While getting tables from books or numbers from reports into spreadsheets means you get to visualize and analyze the data better. However, digitizing data from hard copy sources can be overly time-consuming. Manually entering the data from receipts, bill books, or invoices into spreadsheets is tedious work. Human data entry errors and mismatching are almost impossible to avoid when manually copying information. Zoho Sheet's iOS and Android mobile applications are now available to help you easily
Multiply integer x decimal number result #VALUE!
Hi, I use sheet to make many simple operations like multiply. I use the same sheet since some months ago but on last week sudenly if I mulitply any value with decimals like 71.1, the result is #VALUE! Example: If the operation is ok Cell A = 5 Cell B = 5 Cell C =Cell_A*Cell_B=25 Example: If the operation is not good Cell A = 5 Cell B = 5.1 Cell C =Cell_A*Cell_B= #VALUE! Cell_A = Number Cell_B = Number Another weird behaivor is: If I insert the next number to one cell "5.1" then the cell type change
Missing Currency formula
Hi. I can't find mentioned formula in Sheet: Could you check that, please?
Ask the Experts #1: A live Q&A with the Zoho Sheet team
Hello all, We're excited to launch our "Ask the Experts" community learning series for Zoho Sheet on Wednesday, September 4th, 2019. This series will allow users to interact with the team behind Zoho Sheet in real-time and ask questions about various aspects of Zoho Sheet and use cases. Ask the Experts #1 Topic: Everything about Zoho Sheet Date: Wednesday, September 4th, 2019 Time: 6:30 a.m. to 11:30 a.m. PDT This first live Q&A session will feature six product experts from the Zoho Sheet team answering
How to find the highest value based on a name
I am trying to build an integration wit a Zoho Survey where users can do a survey multiple times. They are recorded in a Zoho Sheet to calculate their score. For example Score Name 16 John Doe 12 John Doe 13 Pete Johnson 14 John Doe 10 Maria Kipling 14 Maria Kipling For all users I would like to get the highest score, so I can use it in another formula. How would I get the highest score based on the Name? So these would be the results: Highest Nem 16 John Doe 13 Pete Johnson 14 Maria Kipling Thanks
mobile app find & replace
If I am using a laptop, and want to do a search for a word or phrase, I can press "ctrl" + "F" and the "find & replace" box pops up. Is there something similar if I am using the mobile app on my phone?
Tip #6: What are aggregated charts? How do they improve visualizations?
Charts, as we know, are vital data visualization tools. Pivot tables, on the other hand, are useful for giving you a summary of your entire data set. Aggregate charts, in turn, allow you to create visualizations of your pivot tables, giving you the best of both worlds! What's the difference between an aggregated chart and a normal one? Consider sales data from across three Regions, by three agents, selling three Items. Here's a regular chart on units sold by item. Here's the same chart, after an
REST API Sheet Access
Hi, I'm trying to access Zoho Sheets via the API. I am trying to FETCH or FIND records from within CRM. i am having problems correctly creating the CRITERIA for this. Does anyone have examples of this?
Next Page