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
Instantly locate any feature inside Sheet with Feature Finder
We count on spreadsheets to store voluminous sets of data, so we can analyze and revise them later. Zoho Sheet provides multiple features to simplify your data-related tasks. But at times, selecting the required feature to perform a desired action can
Please let it remember the position and zoom ratio of the last screen（not starting from the selected cell）.
Please let it remember the position and zoom ratio of the last screen（not starting from the selected cell）.
when I open my sheet ,it always start at "A1" despite I left it at "N234"
when I open my sheet ,it always start at "A1" despite I left it at "N234" Is it possible to make the sheet start where I left it, by default?
How to restore deleted data on a spread sheet?
I tried using CTRL Z but it's not working. Please mind that the sheet is not deleted. There was just data in that sheet that was deleted and can not be restored using the CTRL Z command.
error "Something went wrong
I can't open the document because I constantly get an error "Something went wrong and we're unable to generate a preview.".
How to calculate the running average over the last x days?
Hello, I have a spreadsheet with a header row and two columns - date (A:A) and measurement (B:B), see example below. The rows are sorted by date but not always sequential - on some dates there is no measure and hence no corresponding row. I use the formula
Sheet Superscrpt/Subscript
Why is there no superscript and subscript available for Sheet. It is available for Writer; however, this option is quite necessary when work with mathematics--particularly statistics.
Is there a Sheets API to Publish a Named Sheet as an external view-only link?
I want to publish an external link to a specific worksheet within a workbook. I've reviewed the Sheets API and do not find this capability? If there is an Early Release / Beta api that offers this, I would like to use it.
Share Sheet / Invite non-Zoho Member to join
Hi Zoho - great product(s)! I'm new to Zoho myself and I'm trying to organise some testers to collaborate on a project. I've set up my spreadsheet and now I want to share it with them, but Zoho is telling me I can't because their email addresses are not Zoho accounts. How I'd hoped it woud work would that Zoho would detect that an take that opportunity to grow it's userbase Facebook style by sending them an email: Mr X has created a spreadsheet in Zoho and invites you to collaborate. Please click
Problems Accessing Shared Sheet
I have a workbook containing around 30 sheets which are each shared with a different user. On a number of occasions, these users are having a problem connecting to their sheet. The only way we seem to be able to resolve this is to drop the sharing and reinstate. HAs anyone else experienced this issue?
This link is no longer valid
I need my spreadsheet yesterday link no longer works HELP
How do I automatically generate a new sheet from a template?
I have a template in Zoho Sheet that I'm trying to use to automatically generate a spreadsheet. I was looking through the Zoho Sheet API and I found a way to create a spreadsheet through the API but it only creates a blank spreadsheet and not one that
How to cell.content.set when the content is a mailto: hyperlink?
Here's my code to set a cell value with plain text. resource_id = response.get("data").get("id"); // Put some data in the sheet params = Map(); params.put("method","cell.content.set"); params.put("worksheet_name","Order_by_Athlete"); params.put("row",1);
Creating Countdown timer
Hello, I'm trying to create a count down timer using a specific time I have already figured. For instance i have a time of "01:30:00". I'm wanting to incorporate a button into my sheet that starts counting down 1 second at a time. Ive tried using a formula
notifications?
How can I setup the notification if someone that I shared sheet with!! For example he/her edit something will I be able to get notification from that specific person?? So I can check out his/her work Regards
Email Zoho Sheet API
Hi, Please suggest how do i email a zoho sheet residing on your server... i have docid with me.. ticketid and apikey. please let me know is there any api through which i can directly email a zoho sheet ? or how do i save zoho sheet from your server onto our server and then attach it in an email please suggest
How to programmatically create a Published Range link with Allow Interaction enabled?
I have a very complicated data entry use case for which, (unfortunately) a spreadsheet is the best solution. I have a Named Range in a "master" workbook that needs to be Published to the external world with "Allow Interaction" enabled. I copy the workbook,
ERROR: Did the API keys change all of a sudden? E108 - API Key / Portal Name mismatch
Getting following error when requesting for remote authorization https://support.tracktechllc.com/support/RemoteAuth?operation=signup&email=admin%40agency3.com&fullname=Testuser&loginname=Test_user&utype=portal&ts=1659501065013&apikey=e2d941cede2e0a2d2189e4fc443965a9
Printing using Zoho Sheet, current sheet.
Hi all, i have just downloaded Zoho Sheet. It's good i can edit and all, but how do i use it to print out the current work i'm doing??? Thanks!
page setup
hallo everyone: is there a way to have a print preview on spread sheet and change/set page margins etc.? ...and how does one ge rid of page info on the print?
Spreadsheet Offline
I read about writer offline but I couldn't find anything about spreadsheet. Right now I'm using google account to have such function. Is there any possible to see something soon ?
Send mail from Spreedsheet using vba
Hello, Is it possible to send mails using vba. The examples I found sends the workbook together with the mail but am looking for a solution that sends only the message without the excel sheet. I tried using the CDO object but kept getting error messages Any and/or all assistance would be greatly appreciated
Public Publish of Zoho Sheets (Spreadsheet)
I want to publish my zoho sheet so others can view the spreadsheet without having to sign in like zoho docs. When I go to share the only options I have are to add collaborators email by email ( no thank you) or to allow check in/check out. I see no publish
How do I reference/interact with data in a linked sheet
Hello, I've linked another Zoho worksheet to my project by using the Data > Link Spreadsheet function. The sheet appears to have been successfully linked, but I have no idea how to reference or interact with the data. I've tried unsuccessfully using the
Extremely laggy add new row on mobile.
Anyone else experiencing this?
Zoho Sheets no longer available
How come I cannot open my zoho sheets from the workdrive anymore and I have it bookmarked and it keeps saying This link is no longer valid. Please contact the owner for a new URL. I am the owner LOL
mise en forme conditionnelle en VBA
Bonjour a tous et toutes, Pour commencer un grand merci car l'application est vraiment au top. Cependant je rencontre un problèmes avec la mise en forme conditionnelle classique mes règle saute très (trop) souvent. j'avais pense a les mettre en VBA,
Sheets row/column size unit
I had attempted to manually change the row/column sizes. But I had clicked the [Row-Row_Hight-Custom] and the unit size was 19, I want the size of the grid to be about 11/32 inches or 8.9mm when printed. What size should i put it to do so, roughly.
Is it possible to link to the form (with filled data) from the sheet that it populates with data?
I am using a form built from the sheet interface and using that form to save data in the sheet. I would like to be able to edit (update) a row of data and be able to clck a link to be taken to the form that was used to populate the initial data versus
using sum not working on one sheet to add numbers from different page.
Hi. I was looking after any help what I'm doing wrong, One way what I found =070622.C35+080622.C35+090622.C35+100622.C35 Not working =SUM(C35;070622.C35;080622.C35;100622.C35) Unfortunately this also didn't add the numbers together. Any idea pleas
How to share Workbook with External user, but prohibit "Unhide" sheet
I need to programmatically create an External share link, which allows a user to enter data in cell(s) but not unhide hidden sheets. I was hoping that role_id 33 (View and Share) would do this but it's not working that way. Are the structural permissions
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 does
Add logo to Charts
I created this race chart https://sheet.zoho.com/sheet/publicgraphs/12037a4f0914468fafabee603ebfe3ee1651764903102143 and wanted to know if it is possible to add a logo or link on the chart so if I share it with other sites we get attribution. Thanks
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 cell
sharing 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
Kindly need a macro to lock cell after a data entry
Hi, I am not very used to Zoho VBA and actually I am not good enough to write a macro from scratch. I'm wondering if anyone would be so VERY kind as to show me the code needed for this problem : I'm trying to lock the cells automatically when data is entered. The code for Excel VBA should be like this : ActiveSheet.Unprotect ' Password:="secret" For Each cel In Target If cel.Value <> "" Then cel.Locked = True End If Next cel ActiveSheet.Protect ' Password:="secret"
Next Page