A 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 helping
How 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 and
use of create list and manage list
How to use create list and manage list
Zoho 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 crores
I 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 that
Zoho 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?
Referencing 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'.A1
Tip #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.
Not 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 important
How 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. Thanks
External 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 sheet
Export 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 Sheet
help 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.
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 need
Tags
1. Is there a way to have tags window open all the time? 2. How does one search tags? Thanks
Zoho 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.
Zoho Sheets Arrayconstrain
Hi, I'm using functions that output arrays. In Google Sheets I usually wrap them in array_constrain(array,limit) which makes them not take up all available space. Is there a similar function in zoho sheets? Example from Google sheets =array_constrain(ArrayFormula(sumif(B2:B,H2:H,C2:C)),L1,1)
Restore deleted spreadsheet
Hi all, I can not find my spreadsheet. It seems that my spreadsheet is deleted. Please, restore the spreadsheet. Thanks in advance
Invalid API key problem
Dear Zoho team, I recently used zohos API in my web site. I used the same API key for ZOho sheet , show and editor. The zoho editor opens up smoothly without any problems. However the sheet and show give me these errors. I am using the remote API method. The errors are listed below: Sheet: RESULT=FALSE ERROR_CODE=2890 WARNING=The api key is invalid. Show: RESULT=FALSE ERROR_CODE=3890 WARNING=API Key is not valid -------------------------------------------------------------------------------------------
Hide Unhide Sheet
The ability to Hide and Unhide a sheet is the single feature in EditGrid that keeps me mainly working there instead of Zoho. To allow a sheet to be hidden or unhidden based on a cell content using VBA would greatly enhance your product's utility. Thank you.
Scrolling with mouse wheel makes data dissappear
When trying to scroll via mouse wheel, spreadsheet gets blank. Refreshing the tab gets data back.
Tip #1: Handy shortcuts to move around your spreadsheet
No matter the application, keyboard shortcuts are always a great way to save time and make you more productive. Here are a few quick key actions you can use in Zoho Sheet to navigate within your spreadsheet. Moving to the next cell (Tab, Enter, Shift+Tab)
External Data connections change cell addresses to row zero on their own.
I set up an external data source at a specific cell on a sheet only for external data. If the link is set up on A2, it later moves to cell A0 on its own, ruining other cells that are referencing A2. Also you cannot even remove the bad link. I don't know
Is there a forumula to create calendar in spreadsheet?
I'm looking to create my own 2011 calendar to print but I am looking for a way for Sheet to create the calendar for me so I can then just format, design and print. Is this possible here?
import from url
In google sheets i can import an html table from a URL, if I do the same with Zoho sheets I get 'URL not reacheable'. I can't find any information on this so I'm not quite sure why. Any comments or advice welcome.
How can I turn off e-mail notifications in ZOHO Sheet?
I have previously uploaded several Excel sheets into ZOHO sheet and had checked the box to let me know when changes were made. I now would like to turn this feature off because it is not helpful to me any more. Can I do this? If so, where do I go to turn it off? Thank you!
Use VBA to open an external file
Since I can't use a hyperlink to open a local file from within a spreadsheet, what would be the VBA code to open c:\test.pdf
Zoho Sheet API problem with parameter json_data
Hi everyone, When I run the following Post request through Zoho Sheet API, I kept getting error. Could someone please help? https://sheet.zoho.com/api/v2/p5gob655bd7aexxxxa446c9a7bfe03109aade3?method=worksheet.jsondata.set&worksheet_name=Sheet2&json_data=[{"Name":"Joe","Region":"South","Units":284,
Next Page