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?
China connection speed, Zoho China, Baihui
Looking through the forum I see periodic queries about Zoho connection speed in China. Promised results like "faster connection speed" and "English version of partner Baihui" do not seem to have come to life. Is there any update? We are testing ZOHO for our China team and they are complaining about slow speed.
How to Conditionally Format TODAY() Formula
Hi all! I am experiencing a problem with the conditional formatting. I am building functionality into my sheet which has dates in columns, however the dates have been created via a formula such as TODAY(). The way it is supposed to work is that when certain dates are reached as time goes by, the fields are supposed to change from green to orange to red. This would be fine under conditional formatting if the date was in the field, but the problem is that the formula is in the field, so it is not
[SOLVED] How to create a column of items that matches a given criteria
Hello! I want to create a workbook where in Sheet1 I have details of students & in Sheet2 I want to record their marks. The point is as new students are added to Sheet1, their name should also get copied to corresponding class in Sheet2. Please see the attached workbook, there I have explained the issue in detail. Thank you!
How to View an Excel File residing on my server using Zoho Sheets
Please Help it is urgent any help how to pass a url of a file and view using Zoho Sheets .....
Tip #5: How naming ranges, constants, and formulas can simplify things for you.
Defining names for ranges, constant values, and formulas helps make your spreadsheets clear, eliminates manual errors, and makes short work of quick calculations. It also saves you time by preventing you from having to hunt for values and references. Named range for quick navigation For spreadsheets with numerous sheets of data, defined names make it much easier to navigate across them. Instead of spending your time scrolling through rows and rows of
Is it possible to have conditional formatting with custom icons?
Hi, Currently, there is no possible to create formatting rules with custom icons. Is it possible to create a rule as follows: e.g. a cell has the following value: 'https://zoho.com'. If a cell contains 'https://', then put an icon image within that cell, containing the hyperlink 'https://zoho.com'. Is this possible? Or any other approaches that can handle this scenario? Thank you, Tiemen
Hyperlink text won't work in Pivot Table
Hi, We prepared a text link in a standard table which is used for the pivot table. However, the text link loses the hyperlink and becomes unclickable. How to tackle this issue? Thank you, Tiemen
How to change column headings in pivot table?
Hi, Is there a way to rename the column headers of a pivot table? Now some the columns are named with value labels: 'SUM of .....'. We would like to rename those headers. As of now we couldn't find any direct solution to adjust the headers, besides copying and reformat. We want to avoid these extra steps. Best, Tiemen
Why is pasting to Zoho sheet so buggy?
Hi, I would like to know what is required for simple pasting of data to Zoho Sheets. I am trying to copy from excel fields and HTML table from a website. I am using the latest release of Google Chrome for Windows 10. Most of my attempts are met with 100% fail (nothing is pasted). The others will paste information taken from multiple fields and instead of distributing it correctly across several fields it will past it all in one field. Then occasionally it pastes exactly the way I would expect properly
countcolour and sumby colour
I am getting quite desperate now. Zoho is the perfect platform for a spreadsheet I am trying to move from excel local to a shared sheet but I cant get two formula's to work Function CountCcolor(range_data As Range, criteria As Range) As Long Application.Volatile Dim datax As Range Dim xcolor As Long xcolor = criteria.Interior.ColorIndex For Each datax In range_data If datax.Interior.ColorIndex = xcolor Then CountCcolor = CountCcolor + 1 End If Next datax End Function and Function SumByColor(CellColor
Text at 90 degree angle
I don't think you do this already, but our spreadsheets need the text to turn sideways so that it reads better. (It is a very detailed schedule, and if something is only one day it is only about one or two letters wide, so to keep it slick looking we need to turn the text sideways like you can in excel.) Is this possible already and I missed it, or will you be able to add this in the future.
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!
Next Page