Nine powerful new Zoho Sheet functions, including currency conversion
Zoho Sheet is always looking for ways to make your data analysis simpler. With that in mind, we've introduced nine new functions. We believe they will help make your spreadsheets a bit more sophisticated. CURRENCY (value; from; to) You'll no longer have to look up exchange rates to maintain records in different currencies. The new CURRENCY function will fetch live exchange rates and convert your numbers automatically. FILTER (range; condition; [condition1]; [condition2]...) While the FILTER
Webinar: Create and use custom functions in Zoho Sheet
Hello! Join our next webinar to learn how to create custom functions using Deluge, and how to bring in data from other Zoho applications such as Zoho CRM, Books, and Projects. In this session, you'll be introduced to Custom Functions in Zoho Sheet, followed by a live demonstration. This webinar will help you learn: - What's new in Zoho Sheet - To create and use custom arithmetic functions in Zoho Sheet - To fetch data from other products like Zoho CRM, Books, etc. using custom functions Register
csv data import from feed https://analytics.usa.gov/data/live/os.csv fails. But in google it succeeds. Import as csv file succeeds.
I need to set up a data link to https://analytics.usa.gov/data/live/os.csv I suspect the link fails because of the standard date-format. yyyy-mm-dd. As it stands: the url will first cause a format warning, then it will import gibberish as if an encoding went wrong or it imports a binary file. I hope you can help. J. First lines from os.csv date,os,visits 2019-03-16,(not set),12436 2019-03-16,Android,7236750 2019-03-16,BlackBerry,4644 2019-03-16,Chrome OS,191493 2019-03-16,Firefox OS,144 2019-03-16,FreeBSD,162
pivot table slicers
Is it possible to create pivot table slicers on Zoho Sheets? If so how do you go about it? I have a sheet that has been imported into ZS but it is not showing the slicers created in Excel. Any ideas? Thanks
How to SUM values in at the charts?
Hi! I'm new in zoho sheets and i want to do a chart with some values and i want it sum when the value are the same. That looks impossible... Thanks
On changing the ownership of the sheet, i lost the access to my sheet. Now no one is able to open the sheet. Please do help. its a very important document
On changing the ownership of the sheet, i lost the access to my sheet. Now no one is able to open the sheet. Please do help. its a very important document
Index Match multiple columns - converting from Google Sheet
My formula from google sheets is below. By pasting it in to Zoho, it does not work. If I try to rebuild it in Zoho I get stuck when I try to select multiple columns for either the Index or Match functions. Is this not an available function? Am I not using the proper modifier key on my (Mac) keyboard to select more than one column? =IFERROR(INDEX({NetworkSwitches!$B$5:$B;NetworkSwitches!$H$5:$H;NetworkSwitches!$N$5:$N;NetworkSwitches!$V$5:$V},MATCH(B2{NetworkSwitches!$A$5:$A;NetworkSwitches!$G$5:$G;NetworkSwitches!$M$5:$M;NetworkSwitches!$S$5:$S},0)))
Zoho Sheet with a colorful new UI, 2 million cells and .xlsm excel file support
We have come up with a number of improvements in Zoho Sheet that enhances your overall experience. A colorful new user interface We are excited to present the new, elegant Zoho Sheet UI. The UI features new tabs, more colorful icons, and a look and feel that enriches the user's experience while retaining functionality. The design is in line with other productivity applications from Zoho. Old UI vs New UI You can write to support@zohosheet.com with your feedback. Two million cells Get ready for
Sheets showing strange data (Bug or Feature?)
Hi. Hope someone out there can help. We're using sheets to manage our register float. One of our employees' sheets have replaced the dollar cells with a cryptic formula. Screenshot attached. Does anyone know what this is and how to rid it? Thanks!
Sheet I made and auto-saved is now blank
Just started with Zoho last night. Built a spreadsheet which auto-saved multiple times. Now, after sharing with myself and my wife via personal emails, when I open the Sheet it is completely blank! What happened?
Images not working anymore in sheets
Hi. Anyone experienced this issue before? In a collaborative sheet with our client, all of a sudden none of the images work anymore... and we can't seem to find the cause of this problem. Now, we'll try to just find the images the re-upload them but I am afraid the same thing will happen again - which disrupts the workflow a lot.
How to have cells reference other cells for sheet names
I have sheets that are used to log daily data from multiple sources for each week. There is then a master sheet we use to pull data from whichever week(s) we want. This sheet needs its cells to be able to pull any particular column of data from a weekly sheet without directly referencing the sheet title - basically, each cell in a column should be pulling a sheet name from its header row. This way weekly data can be easily brought up in the master sheet just by changing the header row. See the attached
Problem with Macros not Showing
The only type of macro that appears under View Macros are Subs with no parameters. Functions with or without parameters and Subs with parameters are not shown.
Sheet - Selecting multiple individual cells using Ctrl key
Hi, Sheet allows the selection of multiple cells in a Range by using the Shift key. However, it does not seem to allow the selection of multiple individual cells using the Control key, like most other spreadsheets I've experienced. Is it possible to do this, or will this feature be introduced? It is a very common requirement. Thank you, Dave
Quotes in Zoho Sheets related to Zoho CRM Quotes module
HI, Since there is no line items improvement in Zoho CRM, I wonder if i can user Zoho Sheets new custom functions to link a Zoho Sheet Quotes template with data coming from Zoho Quotes Modules or better yet from Zoho Books Quotes... Anyone tried this before ?
Zoho Sheet 5 - Evolving beyond traditional spreadsheets
Zoho Sheet recently had a major update, making it more powerful. This update adds Zia, an AI assistant, who can help you with data visualization and analysis. Other additions include an automatic Data Cleaning tool, the option to build Custom Functions that bring in data from other applications, and a lot more. Learn more | Watch video " Zia, how are sales doing this year?" Zia, will be your new personal data analyst. She'll help you visualize your data by summarizing rows and rows of information
exports zoho sheets
Exports options is missing in zoho sheets. Why does this happen and how can I fixed it.
Date parsing does not follow date formatting
To reproduce: - Format a cell as British date format ('15/08/06'). - Input '01/05/08' meaning May 1st 2008. - The cell shows '05/01/08' meaning January 5th 2008. Browser: Firefox 2.0 OS: Mac OS 10.3.9 OS international settings: British jclementson
Monetary amounts, currency signs - typography in Czech and English NUMBERS
Hello, Zoho Sheets is a bad currency format for the Czech Republic. In principle, this is a critical mistake. Thousands are separated either by space or dot. 1 000 Kč. # ##0,00 Kč;-# ##0,00 Kč Separation (farthing) is only separated by commas "," 1 000,00 Kč. I send images from Google sheets in the attachment. (Google translate) https://www.jazyky.com/rozdily-mezi-typografii-v-cestine-a-v-anglictine/ The most erroneous area is digits. While in Czech the comma separates decimal places (eg 12,869 is
Merging name fields into one column
I have an excel file that has the following columns First Name, Middle Name, last name, Suffix col 1 col 2 col 3 col4 first Middle Last suffix Neil Avery Stagner. Jr I want the outcome to be all in one column that reads Col 1 first middle last suffix i.e. (Neil AveryStagner, Jr) can you tell me how to do this...and the formula! Thank you!
Allow freezing multiple rows and/or columns in Zoho Sheets.
I want to request allowing the ability to freeze multiple rows and/or columns in Zoho Sheets. As of right now, if you highlight a row or a column and right click or go to the "View" tab, you have to options to freeze one row, freeze one column, and freeze panes. The first two options are self-explanatory, but the third option allows you to freeze one section that's a total of five columns and five rows in length (i.e. columns A-E, and rows 1-5), according to a Zoho Docs representative I spoke with
How do I 'hide' a column or row in Zoho Sheet?
I have a large spreadsheet in which I would like to make certain columns (and sometimes rows) invisible. For data not frequently needed, this is a good way to increase the usability of a given sheet, buy reducing the amount of data displayed at one time. The feature must be in there somewhere, but I can't seem to find it. Can someone point me in the right direction? Thanks
Data Validation Help - Search.
Hello, I went with Google Spreasheets on Zoho Spreadsheets when I found the problem. Data Validation - here I will set everything up. Unfortunately, if I enter text into a cell, I have to enter the text exactly and I have no help as to which data is available. I have to write exactly the letter after the letter. In Google, it was enough to write a word and all the free options were offered. It's a problem when you have more than 100 options.
COUNTIF (DATE1 >=, DATE2 <= ) ??? CANT MAKE IT WORK
HI, I FOUND THIS COUNTIFSCounts the number of times each cells in all the ranges that meet the specific conditions. COUNTIFS(test_range1; condition1;[test_range2;condition2];...)test_range1 is the range to be tested. condition may be: A number, such as 34.5 An expression, such as 2/3 or SQRT(B5) A text string test_range2,condition2,… Optional. Up to 127 range/criteria pairs are allowed. COUNTIFS counts those cells in test_range's that are equal to the corresponding conditions, unless conditions are
Font Limitations
How can I add fonts that aren't on the dropdown list?
References x other Sheets
Hello , I need to create a reference in 2 diferents files ... for example: The file A contain the targets. The file B contains the sales. I need to create a reference in file A with the sales to compare with the target. or it´s necessary to create a way to import the informations to files. Other question, if the File A and File B if they were the same file but in diferents sheets, Would it be possible to create this references ? tks
Orientation
Hi, is it possible to change the orientation of a cell on Zoho Sheets? Please see screenshot (from MS Excel)
No "Hide" and "Move" column or row available?!
I just wonder if there is any "move" column/row OR "hide" is available in Zoho sheet?
Tip #2: 10 simple functions that will save you time
Functions are an integral part of a spreadsheet. With more than 350 functions available in Zoho Sheet, you might find it difficult to find ones that are useful to you. That's why we're here with a small list of simple functions that everybody can use in their day-to-day work. 1. SUM SUM is used to find the total of the given numerical values. You can save more time with the Autosum shortcut Alt+= after selecting the desired cells. 2. AVERAGE AVERAGE is used to find the mean of the given values. That
Bringing RTL to Zoho Sheet
Taking into account the request from various Arabic and Hebrew users we have now introduced RTL in Zoho Sheet where you can work from right to left on your spreadsheets. Not sure what RTL is all about? Read on to know more. Work Right to Left If you are a user of the Arabic/Hebrew locale settings, this update is sure to make your day. Working with Zoho Sheet is now a lot easier for you as the grid, column and row headers, menu tab, sheet tabs, and even the cursor will function from right to left
ZohO Download.
kinldy sort ,i cant download excel from spreed sheet.
Create a top and double bottom cell border
Is it possible to create a premade top and double bottom cell border like in this screenshot?
Upgrade to TLS 1.2 for a secured Zoho Sheet usage.
Hello everyone! Keeping your data secure has always been our top priority, and with this update Zoho Sheet takes securing your data even further. Complying with updated PCI standards, we're terminating support for TLS versions 1.0 and 1.1 starting on October 31, 2018. After this date, users must update their processing solutions to TLS 1.2 to continue using Zoho Sheet without any interruption. What is TLS? Transport Layer Security (TLS) is a security protocol that ensures a safe transfer of
Cell references change when sorting
Let's say I have a range of data A1:K20, and the formula for cell D5 is "=10+B30". If I sort that data so that row 5 becomes row 3, the formula for D3 should remain "=10+B30". It should remain this way because B30 is outside of the sorted range. This is how Excel and Google Sheets behave. In Zoho sheets, the formula for D3 changes to "=10+B28". It's acting as if I deleted two rows. This breaks the entire spreadsheet unless absolute references (such as "=10+$B$30") are used.
Data Validation for a column goes away after inserting or deleting a row
If I have a data validation applied from C1 to C100, and if I insert/ delete a row at C50. The data validation is only till C1 to C49. Inserting and deleting a row removes the data validation
How do I hide lines and columns?
How do I hide lines and columns? I cannot find instructions. Thanks for your help. Pierre
sheet gone
Hello, nearly 10 years ago I used to have a simple sheet on zoho. Now I'm looking for it and it's gone. What happened? Are there any 'backups'? BR Michael
Disable people from downloading or duplicate even they can ready only on the sheet
Is it possible? This is to prevent people from circulating the sheet around?
Sheets: Conditional formatting not working in Firefox + console log filled with errors
Where: New Zoho Sheets in Firefox 64 When opening the "Conditional Formatting" dialog in Zoho Sheets and clicking on "ok", nothing happens. Instead, two errors appear in the console: error { target: Window, isTrusted: true, message: "Script error.", filename: "https://js.zohostatic.com/sheet/Dec_28_2018_3_1979055/appsheet/Views/OWNER/initmin.js", lineno: 0, colno: 0, srcElement: Window, currentTarget: Window, eventPhase: 2, bubbles: true, … } initmin.js:15:995 TypeError: t is undefined initmin.js:6:2933
How do I speed up Zoho in China?
Speed is such a problem that we will have to leave your great product because of it. The speed isn't bad in the USA! We have huge issues in China. I tried using a product to get around the china censors which only helped a little bit. What else can I try? thanks Ken
Next Page