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);Can we revert templates to previous versions in the version history?
In the help help on version history it says "click Revert in the toolbar." That 'Revert' button is there for spreadsheets, but does not appear for me in templates. Is it missing? Is there a way to revert templates to previous versions?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 suggestTip #13: 3 important chart customizations to make them more readable
Charts are great tools for representing data. Visualizing can give you a new perspective, and help you unlock new insights from your data. Here are three customization options that can enhance your charts for maximum impact. Labels: Cover all the basicsGive 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 emailHow 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=e2d941cede2e0a2d2189e4fc443965a9Printing 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 appreciatedHow do I consolidate different worksheets into one?
Hello I have a Zoho Sheet which is made up of a number of different tabs of data, each with the same column titles, but each referencing a different source of data. (See screenshot for example). Is there an automated process which would consolidate theseZoho Sheet - Desktop App or Offline
Since Zoho Docs is now available as a desktop app and offline, when is a realistic ETA for Sheet to have the same functionality?I am surprised this was not laucned at the same time as Docs.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 publishPublish 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 publishwhen 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?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 open where I left it?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 theTip #12: What is Version History and how is it useful? | Revise, revisit, and restore.
Online spreadsheets spare you the hassle of creating a new spreadsheet file each time you edit your data set. Collaboration, revision, discussion, and iterations all happen in the same space—so there's no real need to save data as a separate file. Here'sExtremely 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 LOLAnyway to disable autofill?
When in putting In strings of text in multiple cells. The auto complete can cause a lot of problems in make it almost impossible to enter what you want. It almost makes it unusable.Is the beginning of a long string of text is the same it will try toHow to do repeat item in pivot table
Hye, I want to do repeat item in pivot table instead of missing value. How i can do repeat item like google sheet and excel. (pivot table)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.Add updated records of Forms in Sheet
Hi, I have integrated Zoho Form to Zoho Sheet. All the data filled in Zoho Form is automatically captured in Zoho Sheet as I click submit button. But when I update the data from all entries in Zoho form, the data is not updated in Zoho Sheet. I have toIs 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 versusAdding new data to the sheet with most recent data being added to top row.
I am using a form that I built from within sheets. When the form is submitted, is it possible to have the data entered in (for example) row 2 (since row 1 is the heading) instead of being added into the next available row which should be hundreds ofusing 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 pleasConversion of functions from Google Spreadsheets
Hello! I use this formula "=QUERY(ResumoOrdemVencimento!A3:O38;"SELECT A,B,C,D,E,F,G,H,I,J,K,L,M,N,O WHERE C != '' ORDER BY C,G")" in Google Sheets but when importing my spreadsheet into Zoho Sheets the formula was not converted. The QUERY function brings data from another spreadsheet, and then I sort and apply conditional formatting. The order of data will change automatically as I update the source spreadsheet. What Zoho Sheets function is equivalent to QUERY? I have some other spreadsheets toHow 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 permissionsTip #11: Building spreadsheet dashboards 101
If skimming is the new reading, then dashboards are the new data set. People want to zero in on small slices of information, rather than pouring over a vast set of data. Provide key insights using a carefully crafted dashboard for your spreadsheet. HereIMPORTRANGE not working
I am getting a #NAME! error when trying to use the IMPORTRANGE function.How to Save a Sheets File on Mobile Device
Just as the Title says, I can't find anywhere on the mobile app for Sheets to save a document. It doesn't seem to Autosave. Pls Advise George LeaGrouping 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 doesAdd 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. Thanksconditional 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 cellsharing 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 wasWhere is the specific sheet sharing?
Hi First, my congratulations to Zoho Team for your amazing job. I know it is not possible to hide rows and columns in a sheet (not implemented yet), but at least I would like to know how to hide a page sheet in a shared sheet (by the way, to hide the vba code is also important to me). I searched same thing as "using specific sheet sharing" but I don't find this option in sharing menu. Please, show me as how can I limit the visibility of information in a shared sheet. Sorry my English and thanksMigrate 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.Next Page
Announcements
Tip #13: 3 important chart customizations to make them more readable
Charts are great tools for representing data. Visualizing can give you a new perspective, and help you unlock new insights from your data. Here are three customization options that can enhance your charts for maximum impact. Labels: Cover all the basicsPublish 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 publishTip #12: What is Version History and how is it useful? | Revise, revisit, and restore.
Online spreadsheets spare you the hassle of creating a new spreadsheet file each time you edit your data set. Collaboration, revision, discussion, and iterations all happen in the same space—so there's no real need to save data as a separate file. Here'sTip #11: Building spreadsheet dashboards 101
If skimming is the new reading, then dashboards are the new data set. People want to zero in on small slices of information, rather than pouring over a vast set of data. Provide key insights using a carefully crafted dashboard for your spreadsheet. HereGrouping 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
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
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);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 emailERROR: 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=e2d941cede2e0a2d2189e4fc443965a9when 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?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
Sticky Posts
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 publishTip #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 and
Top Contributors
rp.mahato
Ken Florian
Samuel Ponraj P
Davis Elton
bojakobsgaard