Bitcoin
How can I get the current price of Bitcoin using a function similiar to the "stock" function?Can vlookup work between workbooks?
Can vlookup work between workbooks?=IMAGE("URL") Function isn't working today
Dear Zoho Team, I've been using =IMAGE("URL") function on the regular basis, but today it just stopped working. Please check and fix the issue.vlookup in another page?
Dear officer, Can I use vlookup function to search value in another page? e.g.=VLOOKUP(F2;(sheet 2)A3:C9999";3;FALSE) Regards, JansenCopy formula
Can I copy a formula to other cells and will the formula adapt to the newcell? Wimmore than 24 hours
With Microsoft Excel, it is possible times to count more than 24 hours example : 13:00 + 14:00 = 27:00 cellularity with microsoft excel = [hh]: mm Is this also possible with zoho sheet ? zoho sheet returns 3:00 instead of 27:00 :-( sorry, I know bad englishA lot of spam from @notifications.zohosheet.eu address
In last week Inbox.lv email service has problem with spam from ZOHO side. More that 100K letters daily. I wrote about problem to your system emails, but unfurtunaly w/o answer. As quick fix, we tried to block your IP addresses, but we hope to the helpingHow to call existing function within a custom function
Hello, I'm using the script below to create a custom function but it gives the error "not able to find PV function." How do I call the PV function? float PVD(float rate,float n,float d,float pmt,float fv,int type) { PVD = PV(rate,n+d,pmt,fv,type)-PV(rate,d,pmt,fv,type);Tip #8: Using RAND and RANDBETWEEN functions to generate random data sets
Have you ever spent hours working on a sample data record for a demonstration? We're here to show you how to do it in less time. If you want to generate a sample data set for a demonstration, or just to learn how a pivot table works, using the RAND anduse of create list and manage list
How to use create list and manage listZoho Sheet Edit Cell Format
It seems as though if you want to BOLD something in a cell, it applies to the ALL the text within the cell. How can you just apply to SOME of the text within the cell?How can I set Zoho Sheets to Auto-Complete when entering cell data that was used for other cells in the same column?
How can I set Zoho Sheets to Auto-Complete when entering cell data that was used for other cells in the same column?Number formatting
How do I format numbers in Indian Style like Lakhs and croresNumber Format
How's to format numbers in Indian Style, like Lakhs and crores? Can anyone help. ThanksI cant edit my own file
Hi There, I can access my file but i cant modify. Appears the follow message "Unable to connect to messaging server"Spreadsheet language setting is broken, causing data loss
Dear Zoho, Some time within the last week, your code relating to the language settings for spreadsheets changed. Since that time, the date formats for all date and time cells in my spreadsheets have been incorrect. This is interfering with macros thatZoho Sheet won't open in iOS
Every time I try to open a Zoho sheet from either the Workdrive or Zoho Sheets app, it says that "There's a problem in opening the spreadsheet. Please reopen the file." Any ideas?Our pivot tables just had a pivotal update!
A pivot table can help you summarize rows and rows of data in a single table. This means you are readily provided with the insights that you need from your data. Zoho Sheet has now made this process a little more easy with the new pivot table enhancements like auto-refresh, auto-expand and has made it possible to experiment a little as you create your pivot tables. Keep working on the data; we'll keep up with you! Here's a classic issue with the traditional pivot tables. You'll have to keep refreshingReferencing cells from another sheet not working anyhmore. Strange behavior.
I have just noticed that referencing a Cell from another sheet in Zoho docs no longer works. It shows "#NAME!" error. It was very easy to test: 1. open a new Zoho sheet 2. create a second sheet: "Sheet2" 3. In sheet2 in on cell type the value: ='Sheet1'.A1Tip #3: Save your time by replicating formats
Formatting helps to create more visually appealing spreadsheets while keeping data organized. Selectively applying formatting options to your work, such as applying fonts, currency formats, or colors, can be time-consuming and repetitive. Replicating formatting guidelines for your work can help remove the burden of applying these menial tasks, which improve overall productivity in your workflow. Let's say you are collaborating on a spreadsheet with your team and you have to create a combined report.images don't appear in embed zoho sheet in my web page
Hello, I have a zoho sheet page that I published in my website through embed code but the images inside the sheet do not appear. The rest is loaded correctly. How can I solve it ? thanks !Set print area
Is there a way to set the print area like I can with ExcelNot show data in sheet
Hi everyone, I am new user on this site and I haven't properly knowledge about this site. So, i have an issue, when i am open file in sheet there are no date shown, even i have been checked whole setting but can't access. All, files are very importantHow can we add formulas in excel sheet
hi everyone, I want to calculate some high amount date about my website, which can't be easy to calculate on caculater. So, i want to add a formula for easily calculation. please let me know about the formulas, how to it properly. ThanksExternal Publishing
I am trying to publish a sheet externally and have selected the "Allow Download" but when viewing there is no way to download. Also the sheets are in a different order. Instead of Sheet1, Sheet2 the published shows Sheet2, Sheet1 order.Maximum limit of rows and columns exceeded
I have entered a date in column and wish to extend it day by day to all columns till the end of sheet. But sheet shows that I have exceeded the number of columns. Zoho Sheet has many bugs and looks half baked product.How to Search Items in a Picklist on Sheets
When using the search feature in sheets, if I'm looking for an item that is in a picklist it cannot find it unless it's the present item in the cell. Is there a way to search items, regardless of their position in a picklist?Edit Legend of Chart
I would like to edit the legend of the chart. Every time I enable the legend, I get a very unhelpful (1), and when I try to type to change to what I would desire, nothing happens, which is very frustrating. I've gone through your online tutorials and nowhere can I find a legend settings button. This seems a simple fix, where can edit the legend? Thanks.integrate nomic or coinmarketcap API on Zoho sheet
how could i integrate an external API from coinmarketcap or Nomics in my Zoho sheetExport to PDF
Hey, I am pretty much brand new to Zoho spreadsheets. I would like to export my spreadsheet as a pdf. When I go to File->Export->PDF, nothing happens. I am using Google Chrome as the browser. Has anybody else had this problem or am I just missing something here?I'm new here and used to used excel back in 200 please help
Im trying to set up were I can input certain data on one sheet or multiple sheets and then on last sheet have it auto pull that information from previous sheets to get a full calculations I.E Sheets1-4 trip number miles loaded and empty and cost Sheethelp text not poping up when i select the cell
Hello, I have been trying to get the help text for the cell for which i have don data validation. When I click on the cell I do not get the help text. Is this a settings issue? can you please help. this function will really help me create a better sheet.How to create a drop down menu in Zoho Sheets
I am trying to find out, how do I create a drop down option in Zoho sheet. I tried Data--> Data Validation --> Criteria --> Text --> Contains. But that is not working, is there any other way to do it. Thanks in Advance.Export
I can't get Sheet to export. It says Explorer is protecting me, then gives me the opton of exporting, I click on it and the sheet I'm working on is replaced with a blank sheet. No downloading.How many Sheets can we have?
How many Sheets can we have, is there any limitation?Zoho Sheet Wildcard Match
I am trying to create a sumif function with a wildcard, but I can't figure out what Zoho's version of wildcard is. I want all cells to sum if they have the word food. For example: Sumif(B:B;"Food";C:C) I know Excel uses * , but what do Zoho sheets use?Run a Macro from a Menu or a Button on a Sheet
First I think ZOHO Sheets are GREAT ! Your programmers and designers have done a super job ! I think you could greatly expand your potential users if you had a way for your Macros to be Menu driven from the Sheet itself or if you could insert an object with an OnClick event ... which in turn would run a Macro ... With the addition of that feature complete applications could be built using ZOHO Sheet ... Currently I provide Excel Applications to companies and that is about all I see that would needHow do I get my cell height to auto adjust?
I'm evaluating Zoho Sheet as a replacement for Google Spreadsheet. Using latest version of Safari, and experiencing the same issues in Chrome. A few bugs/things I can't figure out: Auto adjusting cell height when importing from Google Docs or creating a new document Turning off the auto date formatting for X.Y.Z where they are all integers.. (This is extremely important, as our requirements are written as outlines.. "X.Y.Z" corresponds to a requirement ID.. which is then turning into a date) TheTags
1. Is there a way to have tags window open all the time? 2. How does one search tags? ThanksZoho Sheets Bugs
I am experiencing Zoho Sheet as a very unstable and fragile app and it has not improved since I firstly tested it several months ago. When I used it recently I experienced the following difficulties: Server Error messages when attempting to hide a column.Next Page
Announcements
Grouping rows and columns: Structure, summarize and simplify your spreadsheets
Sometimes, the bottom line is all that matters. With the Zoho Sheet's new grouping feature, you can create crisp summaries of voluminous data sets with cascading, multi-layered data chunks that are much easier to comprehend than a plain table. How doesTip #10: 3 helpful ways to use data validation in your spreadsheet
Data validation in spreadsheets makes data entry processes more efficient, while helping reduce inconsistencies and errors in your data sets. In this article, we'll look at three ways you can use data validations to create useful dropdown lists in yourTip #9: 5 common spreadsheet errors and how to solve them
Functions can help you automate your calculations and pull important insights from your data set. However, if something goes wrong with these functions, errors occur and make your spreadsheet less reliable. These errors usually have a cascading effect,Deprecation of Zoho Sheet's view.do API
Hello all, The Zoho Sheet view.do API (https://sheet.zoho.com/sheet/view.do) accepting URL and file stream parameters (provided in https://sheet.zoho.com/sheet/excelviewer) has been deprecated, and will no longer be available to use from July 31, 2019. Any code written using this API will stop working after this date. The Office Suite APIs are available as an alternative via Office Integrator. Learn more here. If you have any questions about Office Integrator, add them as comments below or dropConditional Formatting Enhancements
We have been supporting conditional formatting in Zoho Sheet for more than 11 months now. We support setting rules on Numbers, Text, Data, Cells containing blanks, and errors. We also support setting specific formats based on the result of a Formula. This could be very powerful and could be used to color whole rows based on the value on a particular column. For example, you can define a formula criterion to color alternative rows of a table or to highlight rows if the date in one of the columns falls
Zoho Pagesense Resources
Zoho DataPrep Resources
Zoho CRM Resources
Zoho Subscriptions Resources
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Zoho Desk Resources
Zoho WorkDrive Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Most Discussed Topics
conditional formatting not working when applied to range of cells
I am having a problem applying a conditional formatting to a range of cells. I have 3 conditional formats. They are all Classic - Formula. The formula is one of: b3<today() b3=today() b3>today() When I apply these conditional formats to a single cellMigrate particular row to another workbook
I need help with migrating a particular row, when the particular task is assigned to certain person within department, the task is auto added to the department HOD Ex. Task A is assigned to X, and I want the whole row to be reflected in X workbook.Conditional Formatting for cells containing duplicate values not working
Hi, I noticed today that the conditional formatting that is supposed to highlight cells containing duplicate values does not work anymore. It now highlights all cells even if there are no duplicates. This behavior changed today as far as I can tell. SeeZoho Sheet - Printing - Page Breaks and Printing Customization
I think the title is descriptive enough in that I cannot find help documentation on a simple task of adding in page brakes for separating pages on print. Thankssharing with a group
I have created a group and added members to it, but I do not see where/how I can share a sheet with that group. I only get the option to share using email addresses and that has limited me to 20 users. I need to share with more than 20 users, so I was
Sticky Posts
Tip #10: 3 helpful ways to use data validation in your spreadsheet
Data validation in spreadsheets makes data entry processes more efficient, while helping reduce inconsistencies and errors in your data sets. In this article, we'll look at three ways you can use data validations to create useful dropdown lists in yourConditional Formatting Enhancements
We have been supporting conditional formatting in Zoho Sheet for more than 11 months now. We support setting rules on Numbers, Text, Data, Cells containing blanks, and errors. We also support setting specific formats based on the result of a Formula. This could be very powerful and could be used to color whole rows based on the value on a particular column. For example, you can define a formula criterion to color alternative rows of a table or to highlight rows if the date in one of the columns fallsOne cell, multiple formats, unlimited possibilities.
Spreadsheet formats are more than an aesthetic choice. Proper formatting helps audiences understand your spreadsheet better. Zoho Sheet now allows you to format different parts of your content in cells however you want. What can you do with the new formattingTip #8: Using RAND and RANDBETWEEN functions to generate random data sets
Have you ever spent hours working on a sample data record for a demonstration? We're here to show you how to do it in less time. If you want to generate a sample data set for a demonstration, or just to learn how a pivot table works, using the RAND andTip #3: Save your time by replicating formats
Formatting helps to create more visually appealing spreadsheets while keeping data organized. Selectively applying formatting options to your work, such as applying fonts, currency formats, or colors, can be time-consuming and repetitive. Replicating formatting guidelines for your work can help remove the burden of applying these menial tasks, which improve overall productivity in your workflow. Let's say you are collaborating on a spreadsheet with your team and you have to create a combined report.
Top Contributors
Preetha V
madhur.mehta
Narendra Eswar G
Monisha P R
john v. kumpf