Editable sheet but can not distribute, save or email or etc...
Is this possible? I want the file to save in its existing location. But not for the user to be able to save a copy etc... this is disastrous. Is this possible? I can see that this has been asked in various forms up to 9 years ago and as far as I can tell
Images Stored in Zoho Workdrive not displaying in Sheet after putting the image URL
I have generated a form from which images are uploaded onto zoho workdrive & the image URL is stored in a ZOHO Sheet. Now when i try to Display the image it shows a broken image link. When I try to go insert Image from the insert from URL, in the dialog
How to add a Trendline to a chart inside sheet?
Hello Zohos I am very please with the improvement of Zoho Sheet since I used it last time Im still missing one thing that I easily have access to in MS excel : Add trend trend line I found a way to calculate the regression line by: =FORECAST =SLOPE =RSQ But I'm pretty confused how to get the line on the chart with the data. Are there any solution to this?
Introducing Forms in Zoho Sheet
We hereby bring you the power of forms in Zoho Sheet. Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you
We'll be right back - URGENT
Hi, It has been like this for hours. Some sheets load and some don't. Sometimes the sheet opens, but it's empty. Thank you!
Zoho Sheets Outage - We'll be right back
It has been like this for hours. I tested multiple sheets.
Can I generate a PDF from a worksheet through API?
Hello, I'd like to use the Sheet API to inject data into a worksheet and then export that worksheet as a PDF. Is this possible?
IMPORTRANGE not working
I am getting a #NAME! error when trying to use the IMPORTRANGE function.
Collaborative spreadsheets on your smartphone.
Waiting till you're at your laptop to get your work done is a thing of the past. Stay on track with the mobile world with the Zoho Sheet app for iPhone, iPad, and Android devices—watch the video. Now you can: View and access all your spreadsheets—both owned and shared. Perform calculations in a snap with more than 350 functions. Visualize data with charts and conditional formats. Share and collaborate in real time with your team. Distribute files with shareable links. Insert hyperlinks, checkboxes,
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 your
what's the equivalent of the "format as a table" function from excel in sheet?
I use this all the time in excel is there a quick equivalent function?
zoho mail body sheet is not open
In zoho mail body any sheet not open as the box come ," something went wrong ,please try opening file again ".
VLOOKUP in another file
Dear Zoho Sheet Team, I've been trying to find the way to use VLOOKUP() in another file (as OpenOffice and MS Office can) and haven't find yet. Is it possible? I tried this, for example: =VLOOKUP(A1;'one'$Sheet1.$A$1:$F$500;2;0) Thank you.
Zoho Sheet Save To PDF Cell Border Has Broken Lines
Hi Folks! I have some cells where I put borders around them. However when I save them to PDF, I see broken lines on some of the cell border. Is there anyway we can prevent this from happening? See picture attached.
WHAT DOES #TIMEOUT MEAN IN ZOHO SHEET
Hi. I've been organizing some sheets required for our work and been using formulas for it. the first one was working, however, when I was doing it to another tab in the sheet the #timeout keeps on showing up when I have the right formula
Zoho Sheets Auto Updating Capabilities
I was wondering if Zoho had the capability to do this or not - I would like to put up our local television studio's TV Schedule online on the website I am creating for it. The scheduler program makes a .lst file which can be opened up in Microsoft Excel after doing an import wizard. I was thinking of writing a script for Excel to auto import the schedule once a day and save it as an .xls file. Then I was hoping to import this schedule .xls into Zoho Sheets, so I could embed the spreadsheet into
Spreadsheet Formatting Issue On Ipad / Iphone
Hi Folks! Need some help here. My spreadsheet is formatted nicely, i.e. the width and height of the cells were adjusted so I can see all the information in the cell at one glance on the desktop version. However when I open the spreadsheet on ipad or
Share a Sheet template
Hi I would have create a spreadsheet which I would like my organization to be able to access. I have added it to the Org Templates. However when a user goes to "New from Template". Choose "Org Template" Then clikc "Use" on the template, nothing happens.
can I rename a spreadsheet with VBA in zoho sheet?
I know that I can rename the spreadsheet (ie the whole file) by clicking on the title in the GUi and renaming it. And I know when I am in the list of all spreadsheets, I can rename it using the menu, eg the context menu. But I would like have a VBA macro
Setting row limit to my colleague
I have csv files which i will be uploading to zoho sheets and will share with my co worker/staff and give them access to edit, they can either remove and replace with new data but they are not allowed to add new rows to what limit i set. For example i
Adding new fonts to zoho sheets
Greetings is there a way to add/import custom fonts to zoho sheets like in zoho writer? Thanks
Do buttons and vba msgbox work on mobile, specifially the iPhone zoho sheets app?
In Zoho sheets on the web, I inserted a button and assigned a VBA macro to it. It pops up a msgbox with some text. When I go onto the iPhone mobile zoho sheets app, the button is there. When I click on that button, the spinning asterisk appears for a
how do I put a newline in a vba msgbox string
In Zoho sheets on the web, I inserted a button and assigned a VBA macro to it. This macro has a msgbox(string) in it. In making that string, I'd like to add newlines. I tried: msgbox("one" & vbNewLine & "two") ' and msgbox("one" & vbCrLf & "two") Both
User Defined Functions available in Zoho Sheet?
Is it possible to make user defined functions? In the VBA editor I seem to be able to create Public Functions, but I cannot see them in the function wizard. Also if I try to use the functions directly in cells, they are not recognised. I wondered if UDF are supported, if they are is the some additional step to enable them? Gary
Auto complete in data validation
Hello, Until last week, when I activated data validation on a cell with a list or a cell range, when I typed some letters, the dropdown menu would be limited to the letters I typed (auto-complete/type ahead). This was very useful with long dropdown menus
Data Validation now available in Zoho Sheet
We are glad to release the 'Data Validation' functionality in Zoho Sheet. Using this, you could restrict the data that is entered in cells to a specific condition that you set. If it is a numeric cell, you could add numeric constraints like the number should be less than 20, or between 40 and 60, etc. This could be really useful when you have a calculator like functionality on your spreadsheet and expect the input data to fall within a range. Similarly you can set rules on cells with Text and Date
WorkDrive Browser Extension That Allows Direct Save to Work Drive
Hi, I enjoy WorkDrive a lot. I believe it could be enhanced if there was a browser extension that allowed pdf files to be saved from the browser directly to workdrive. This could be done as a save as option or print to pdf option that works with the
Missing Files after reinstall
Today I have trying to open my Zoho xl sheet with app, but more time I have failed. After I did uninstall and again installed this app again and logged with my own gmail account. But yet now my all files are Missing, thats not visible.
countif function with text compare
In a spreadsheet I would like to count the numbers of occurences of a certain text in an area. Both the area and the text are referenced. Example: The area with text cells is B3:K3 The compare text is in cell A2 In Cell A1 I would like to display the number of occurences, so I'd expect to use a formula like this in cell A1: =countif(B3:K3;=A2) Doesn't work as countif compares only values or expressions. Is there any workaround?
Crunch your spreadsheet data better with 7 new Zoho Sheet functions
Spreadsheet functions help you quickly compute, analyze, and visualize data. Zoho Sheet supports over 400 functions, now including TOROW, TOCOL, HSTACK, VSTACK, TAKE, DROP, and NUMBERVALUE to help you reorganize data as per your convenience. TOROW With
Publish spreadsheets, sheets, or ranges with specific customizations
Publishing a spreadsheet allows you to share your reports or data with a wider audience. To expand the publishing capabilities for your spreadsheet, we've revamped the publish controls in Zoho Sheet. New look, extensive options With the new publish
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 !
Sheets: a cell has formula =now() is its value; In the Sheets iPhone app, when does it update to the current time.
I am using the sheets iPhone app. I have a cell with the value a formula =now() if I leave that sheet open in the app, use other apps on my phone, and come back to the sheets app with this sheet still open, the time in that cell is the old time I was
FORMULA ERROR
Hi. I am trying to filter data from one sheet to another and the formula kept on having this error: NAME! I want to have a separate sheet where all of the accepted data is in just one sheet. This is the formula I've been using but kept on getting an error:
Empty Cell Issue
Hi, I need something to keep cells empty on error. On other sheet-software both of these options work, but no on zoho. Option 1) =IFERROR(A1;B1;) This populates cells with zeros "0" Option 2) =IFERROR(A1;B1;"") This populates cells with an empty string
ADR Stock Prices
Hello, It appears as the stock price function for ADRs is one day behind. For example BAYRY, at the close of 7/12/2021, shows $15.15 for the share price. That was the previous day's close (7/9/2021) because the current day's (7/12/2021) close is $15.08.
Appending Arrays
Hi, how is the syntax for specifying an array manually? E.g. I have Data in A1, A2, B1, B2, that I need as a single array A1, A2, B1, B2 In Google Sheets I write {A1:A2,B1:B2} In Excel I write VSTACK(A1:A2;B1:B2) How do I do it in Zoho? Thanks
Borders
Are border patterns supported?
Selection from the tables are not all on the Homepage
hello, I have the following problem. for example, I select lines A1 - A12, but when I look at this in my homepage, only A1 - A9 is displayed, although the selection is correct. Does anyone have an idea?
Give external sheet user ability to "Submit" or "Notify" me
I use external sheets to collect data from external customers. I want to give them an in-sheet way to tell me that they are finished. Ideally it would be something like a "Submit" button that could trigger a crm-side event/action that sends me an email
Next Page