How to stop scrolling of zoho sheet embedded in a website
I am using zoho sheet as a calculator. I embedded the following html snippet in this website. <iframe width="500" height="400" frameborder="0" scrolling="no" src="https://sheet.zoho.com/publish/rfcircuits.info/pi-match-lp2"> </iframe> The width and height of iframe are adjusted to exactly match the dimensions of the sheet. But even with scrolling="no" option, the sheet is scrolling after embeding in the webpage. Is there a way to avoid scrolling of the sheet inside the web page or atleast hiding
If(AND...) Function - How to Format
Hello, I use the following function in Google Sheets =if(AND($AA18<>"CLOSED",$AA18<>""),GOOGLEFINANCE($B18,"price"),"") Why will it not work in Zoho Sheets? I get this error. =IFERROR(__XLUDF.DUMMYFUNCTION("if(AND($AA18<>\"CLOSED\",$AA18<>\"\"),GOOGLEFINANCE($B18,\"price\"),\"\")");2.65) Thoughts?
If(AND...) Function - How to Format
Hello, I use the following function in Google Sheets =if(AND($AA18<>"CLOSED",$AA18<>""),GOOGLEFINANCE($B18,"price"),"") Why will it not work in Zoho Sheets? I get this error. =IFERROR(__XLUDF.DUMMYFUNCTION("if(AND($AA18<>\"CLOSED\",$AA18<>\"\"),GOOGLEFINANCE($B18,\"price\"),\"\")");2.65) Thoughts?
Linking Workbooks Together
I have a sheet with 4 workbooks in it. Sheet 1, sheet 2 sheet 3 and sheet 4. What I am needing is to set a patter in workbook 4 that is goes down the rows (sheet 4) as Row 1: =Sheet1.A2 Row 2= Sheet 2.A2 Row3= Sheet 3.A2 Row 4= Sheet1.A3 Row5=Sheet2.A3 Row6= Sheet3:A3 and the pattern on and on. When I keep dragging I will get a few in a row then skip then a few in a row correctly. Is there a way to get this pattern to allow me to just keep dragging down as needed?
cursor moves bij re-open file
When I open(phone) a sheet, the cursor stands always at the begin of the file. For example: I close a file while the cursor stands on G278. When I re-open the file, the cursor appears at the beginning of the file instead at G278 where he was closed. Can you help me. Can I change that?
When copying a Zoho sheet file within Zoho, the copied file loses its data validation and conditional formatting
Hello, When I copy a Zoho Sheet file (which contains some cell data validations, conditional formatting and simple formula's) within the same Zoho project folder, the copied has lost it's data validation on some fields and in some cases the formula's cell references have been incremented, meaning I have to do redo a lot of the work again. Is this an existing issue or is there another process I should be using within Zoho when copying files? Many thanks!
How can I print the notes inserted in the cells in Zoho Sheet?
Is there a way to print the notes inserted in a Zoho Sheet documents?
Read/Write access user unable to see data
I have a spreadsheet that has two Read/Write access users. They add data entries to a sheet, which has formulas flowing into summary sheet. Until yesterday, the two users were able to see the data on the data entry sheets, but all the sudden from today, both users wasn't able to see any data above certain row on that sheet. Any suggestion on how to resolve this is welcomed and appreciated. Thank you in advance.
Shared user can't see certain records
Hi I have a shared spreadsheet with two other read/write access users. In the spreadsheet, there is a sheet that is data entry sheet that one of the user inputs data (we will call her User A). Few days ago, User A all the sudden could not see any data above a certain row (but can see row 1 which is the header row) that she inputted. The rows were not hidden or filtered. However, when the data is copied over to a later row in the sheet, user A can see it. User B (the other user with Read Write
Read/Write access users can't see data
Hi, I have a spreadsheet that has two read/write users added. They add data entry for me and I review them online. We haven't had any issues on it until today, and all the sudden, the both read/write users can no longer see the data that's in the spreadsheet above certain rows. They were able to see it fine until yesterday. I as an owner can still see all data on the spreadsheet, and the rows are not hidden or filtered or anything. Please let me know if you know how to resolve this issue.
Expand / Collapse Rows in Spreadsheet
I'd like to be able to collapse rows of categorized data so that I can more easily see all of the categories, with the ability to expand them to see individual rows. When I search, I find this demo, but with no explanation of how to make it https://docs.zoho.com/sheet/published.do?rid=mr778aae12b194b91414e9c4990cfc03e0bd5 For example, this list Item Style Qty Price Total Apple Green 4 0.49 1.96 Apple Red 9 0.35 3.15 Apple Yellow 7 0.49 3.43 Grape Red 100 0.05 5.00 Grape Green 150 0.04 6.00 Total
replace existing
When I would upload a file to Excel online it always ask me if I want to replace the existing file. I don't see this feature in Zoho and was wondering if there is a setting for this. Bruce
Link two Zoho Sheets
Hi I apologise in advance if this has already been asked, however i couldn't find it anywhere. I have data in one Zoho sheet and i was wondering how i get that data into another zoho sheet without losing the data in the original sheet. In excel i would have linked by '='Sheet Name and cell'. If someone could let me know how i do similar in Zoho it would be much appreciated. Thanks in advance. R
Print Preview and Page Breaks in Sheet
Have Page Breaks and Print Preview been developed for Sheet?
Error In Cell Function
Hi Guys, I need to store Filename inside cell, I used "=CELL(FILENAME; A1)" formula, but I'm getting error "#NAME!" . I got that formula in the Zoho Sheet Documentation. https://sheet.zoho.com/sheet/functions Please help to resolve this issue. Thanks in advance. Regards, Termcon
Print with Gridlines
Is there a way to print the spreadsheet with grid lines automatically instead of having to manually add a border for each cell that is printed?
Send workbook draft attachment through email
Hi I love your platform, i saw a code to send the worksheet as an attachment through email like this ThisWorkbook.HasRoutingSlip = True With ThisWorkbook.RoutingSlip .Recipients = Array("xxx@yyy.com","zzz@yyy.com") 'Can send mail to multiple recepients .Subject = "Task completed" .Message = "Mail content" & Target.Row 'Sending cell value in mail '.AttachWorkbook = False ' By default the file will be attached in the mail. If it is not needed then send ' .AttachWorkbook
Sending email with ThisWorkbook.Route problem
Hi i love your platform, i have this code: Public Sub email() ThisWorkbook.save ThisWorkbook.HasRoutingSlip = True With ThisWorkbook.RoutingSlip .Recipients = Array("gfdsgdsf@dsf.com") .Subject = "l" .Message = "" .AttachWorkbook = True End With ThisWorkbook.Route End Sub The problem is, when i am loggen in it works, but when i am logged out it gives an "unknown error" on the ThisWorkbook.Route line and the email isnt sent can this be fixed? Thank you very much.
Indian Mutual fund tracking
Hi Friends, Is there a way we can track Mutual Fund investments in ZOHO sheets automatically?
"unknown error" on vba script
Any idea why I get "unknown error" on line 32? Option Explicit Sub updateCSV() Dim wb As Workbook Dim ws As Worksheet Dim newWS As Worksheet Dim i As Long Dim z As Long Dim lr As Long Dim desc As Variant, created As Variant, amt As Variant, fee As Variant 'Set Objects Set wb = ActiveWorkbook Set ws = wb.ActiveSheet Set newWS = Sheets.Add 'Vars -> Assumes headers are in row 1 desc = Application.Match("Customer Description", ws.Rows(1), 0) created = Application.Match("Created (UTC)", ws.Rows(1), 0)
Insert Current Date and Time
Here is a quick tip on inserting the current date and/or current time inside a cell. Select a cell where you want to insert the current date/time. Press Ctrl+; to insert the current date. Press Ctrl+Shift+; to insert the current time. To insert both current date and time inside a cell, press Ctrl+; followed by a space and then press Ctrl+Shift+; Note that this is a static date/time and the value will not change as time passes by. However, if you want to have the current date or time to be automatically
Importrang
Any small business that runs its business with spreadsheets will always use importrange to consolidate data. Why Zoho is not included this at all?
CONECT 2 SPREADSHEETS IN ZOHO SHEETS
Hi I have a document called "Insurance", and another called "database". What I want is that the information in some of the colums of the document "database" transfer the information to the document called "insurance" in a way that when I write something in "database" automatically the document "insurance" get updated. How can I do this?
Tip #4: Five important statistical functions, and when to use them.
=AVERAGE (number1; number2; ... number30) The sample mean is probably the easiest piece of information one can extract from a data set. To calculate sample mean in Zoho Sheet, all you have to do is key-in =AVERAGE and select the range of cells you'd like to find the statistical mean for. Zoho Sheet supports a few handy variations of the average function as well. =TRIMMEAN (number_list, fraction) Say, for instance, you want the sample mean. However, you want to exclude the maximum and minimum values
Importrange Essential But not in Zoho
Any small business that runs its business with spreadsheets will always use importrange to consolidate data. Why has Zoho in the 4 years since this request was posted not included this at all? Some of us only need simple spreadsheets to run our businesses. If you are really for businesses, then this is a functionality you would put on your TOP PRIORITY LIST! Being a competitor to Google simply means that you have to work on this. This is one of the reasons why businesses use Google Platform - to
Import One Spreadsheet Into Another
Is it possible to import one or more cells from one spreadsheet into another in zoho sheets (like "=IMPORTRANGE" in google sheet)?
Import Range
Hello Please I need help. I don't know how to import a range in the zoho sheet. Can somebody help me with the formula. In google it is this {=importrange("tMRE8ynZbZJ-1jrl5fQ6rLA&hl", "price!Q9:Q450")}
spreadsheet
On my previous MS spreadsheet I was able to split the screen into 2 parts by dragging a small line located on the top right of the spreadsheet down and creating a fixed data section on top to be used for my reference. My working lines were added below the fixed lines . I am unable to find this useful tool on Zoho Helmut D
Sheets API - Download workbook
I am calling the Zoho Sheets API from a CRM function. I want to download the workbook as a CSV and attach it to the record. If I use format xlsx, the response is the file. It downloads and attaches perfectly. If I use format csv. the response is a text stream of the CSV itself. As a result, it doesn't download or attach. How can I download the CSV file itself? Kind regards Matt
Randbetween
Is there a way to assign a random number with the Randbetween formaula but have it lock so it does not change if it is resorted?
How to import web data
heyyy on zoho sheets i would like to know how to import data from web a exaple the price from Gold to dollars etc..
Link external data does not work, while import from downloaded csv does work.
Trying to link to: https://analytics.usa.gov/data/live/os.csv Gives lots of strange chars. But downloading the os.csv and then importing works fine. Can this be fixed? Thanks. J.
Zoho Sheet mobile apps forum—closer community, better experience
Hello everyone! While you may already know we post tips, make product updates, and encourage user interaction in our Zoho Sheet community, we now have an exclusive forum for our Sheet mobile app users too. If you use Zoho Sheet on your smartphone or tablet, follow our Mobile Apps forum to see all the app-related announcements, get quick answers for all your questions, post ideas, and learn a few tricks to create powerful spreadsheets
zoho sheet and offline
Hello Do I understand correctly, that zoho sheet does not provide the offline function, write provides oub
Macro: 'Application defined error' while using Match.
Using Match, Index/Match gives the following error: Encountered error at line mn : Application defined error I am not sure what is wrong. I have tried many times on different sheets. Also, enclosed a test spreadsheet with code and a screenshot of the error message. Any help to solve this is highly appreciated. Thanks.
How do I tell the number of people accessing my published sheet?
Hi: Is there a way to tell the number of people accessing the sheet I have published? Thanks,
Published HTML version of sheet is not interactive
Hello, I published one sheet into my website which includes some drop down menus, formulas etc which I want the visitor to make their own calculation. But after adding html code into the website I saw that excel is getting imported in a static view so you can't choose anything from drop down menu. Am I making a mistake?
Macro to copy data from 3 sheets into a fourth sheet
Hello, I am trying to copy data from 3 separate sheets (Ranges A to E) into a fourth sheet (Final).May I ask the VBA code for it please. So far to copy values from 1 sheet (Electrical) into a separate sheet (Final). Sor far I have: Sub copy_paste() Dim SourceRange,DestinationRange as Range Set SourceRange1=Range("Electrical!A:E") Set DestinationRange=Range("Final!A:E") SourceRange.copy DestinationRange.select ActiveSheet.paste End Sub
How to insert Greek symbols like mu, sigma in Zoho sheets?
I need to insert Greek mathematical symbols like mu, sigma in the Zoho sheets. Is there any way to do this. If so how to do that? Maybe like this in excel.
Header/Footer
Hello, Is there a way to create a header in an individual sheet so when I print that one sheet it appears at the top? Jaclynn
Next Page