Zoho 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.Zoho Sheets not compatible with Excel/Google Sheets
In order to share a copy of a Zoho sheet with someone that does not use Zoho, it must be downloaded as MS Excel format and then added to an email. This is a labor intensive, and frankly confusing process. I have forgotten to do this before, only toZoho Sheets working offline
Hi, I am looking for the ability to work offline in Zoho Sheets, but currently I cannot find the process to complete this. Does someone have any ideas or steps I might have missed? Also does Zoho Sheets have the "Format as Tables" function as is currently in MS Excel 2016?? Many 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 wasUpdate date & time when a cell is edited
Hi All, I am desiring to have a cell update with the current date and time when another cell is edited. Any ideas? Thank youHow to create a drop down menu in Zoho Sheets
I am trying to find out, how do I create a drop down option in Zoho sheet. I tried Data--> Data Validation --> Criteria --> Text --> Contains. But that is not working, is there any other way to do it. Thanks in Advance.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 stringADR 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? ThanksBorders
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 emailInstantly 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 canPlease 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 change sheet alphabet color ?
HelpHow 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.".Tip #14: 5 Zoho Sheet features that make collaboration easy
The world has indeed become small, with teams and organizations now spread across the globe. So why should data be kept in offline silos? Here are five Zoho Sheet features that help you share your data across your organization, and work seamlessly withHow 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 formulaSheet 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 clickProblems 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?use of comma as a decimal separator
Hello, I wish to find a way to customize the number format for my proper use. I have to use french data, where the "," is used as the decimal separator : for example the french way to write "3.99�" is "3,99�" Is it possible to do it in Zoho Sheet ? If this is not actually the case, I'd love this feature to be implemented !SHEET - Send email when a cell changes
I would like to create a custom function for Zoho Sheet that triggers when a paticular cell changes to a specific value. This would result in sending an email to a recipient (this would be an address that remains the same and included in the script). Example: = IF(N4= "Drafted", <>EmailFunction) 1) Cell N4 changes to "Drafted" 2) Email is sent to recipient or alternatively 3) Post to chat channel I have found the Custom function editor in Sheet. I am not bad at scripting, butCan 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?This link is no longer valid
I need my spreadsheet yesterday link no longer works HELPSorry! There was a problem saving this spreadsheet. Please Try Again (Error Message)
Hi, I'm using PHP laravel framework for this Zoho Sheet intergration. My problem is I can't save my sheet after edit it. I've already ensured the saveurl is accessible. The saveurl also using HTTPS. Error message when save in Zoho Sheet My Code ThankHow 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 thatHow 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 formulanotifications?
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 RegardsEmail 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 basicsHow 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?Next Page
Announcements
Tip #15: Stop guessing and start estimating with Zoho Sheet's Goal Seek
Goal Seek is an ideal spreadsheet tool for devising estimates, as it helps you retrieve your desired output value when the input values are not known. In other words, Goal Seek does back-solving to find input values once you've provided an output value.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 youCollaborative 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 yourData 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
Zoho Pagesense Resources
Zoho DataPrep Resources
Zoho CRM Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
ご検討中の方
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
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 dialogWe'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.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 tellScatter graph when x-axis is time becomes a line graph/chart
The difference between a scatter graph and a line graph is that the x-axis should be mathematical. Ie if the X data points are 1,2,4 , the '4' should be 2 intervals away from the '2'. On a line graph, they would be next to each other and equidistant to
Sticky Posts
Tip #15: Stop guessing and start estimating with Zoho Sheet's Goal Seek
Goal Seek is an ideal spreadsheet tool for devising estimates, as it helps you retrieve your desired output value when the input values are not known. In other words, Goal Seek does back-solving to find input values once you've provided an output value.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 youCollaborative 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 yourData 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
Top Contributors
Preetha V
john v. kumpf
Mouriya Sakthivel
Dous Ramez
Gautham Balaji G