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 DSheets 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 MattRandbetween
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 spreadsheetszoho sheet and offline
Hello Do I understand correctly, that zoho sheet does not provide the offline function, write provides oubMacro: '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 SubHow 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? JaclynnDuration (end time-start time)
In col A I have start time. Col B is end time. In col D I need duration which in Google sheets it is as easy as =B1-A1, but that doesn't work here. How do I go about it? All the best, ThAdd Row Creation Date
Hi guys, I'm looking to automatically add a 'date created' field to rows on a sheet which are being populated from a Flow. Whats the easiest way to accomplish this? Thanks in advance :)Conditional Formatting not Working on Sheets
Hello, I had some Conditional formatting rules set that have been working for the past 2 weeks. The rule is very simple that if a field contains a Date that is Today, the field fill color of the cell changes to Red and the text becomes Bold and underlined. Now this has suddenly stopped working since the start of this week. Can you please check the issue? Best Regards,Ahmed FoudaColumn Filters are not Filtering data accurately
This afternoon ( 28th March 2020 ) column filtering has been unreliable. When I select a filter it will include rows which do not match the filter criteria. This raises two issues. The first is that the extra rows get in the way of my work. The second is that the filters may be excluding rows which do match the criteria and I will be missing them.Published Sheets forces HTML view on mobile
Hello, I have a problem with a published Zoho Sheet file. I have the first collumn of my Sheet Freezed (so it follows me when i scroll). Problem 1 I've noticed that when i publish and use the HTML View the freezed collumn doesn't work anymore, why is that happening? Problem 2 I need to have that collumn freezed on mobile, and i tought i could use the normal view on mobile, but actually when i open the published (Normal view) on mobile it forces to open it on HTML... So, once again, i lose the freezedSince TODAY, impossible to FILTER a table containing PROTECTED/LOCKED cells
Hello, Since today, it is no more possible to filter a table containing protected cells. This shows an error indicating that I can't modify or delete protected cells BUT i am only applying a FILTER on the table. Please can you help us to solve the problem ? Thank you, Best regards, Gauthier COUNETQuick and controlled data entry with new picklists in Zoho Sheet
Picklists are custom drop down lists with predefined values and formats that can be applied on the desired cell range. These customized drop-downs help you control the data entered into your spreadsheet and speeds up the process too! Effortless data entry Entering data manually is tedious and may lead to typos or misplaced values in your spreadsheet. Luckily, Zoho Sheet offers a solution to this problem with picklists. Once you create a picklist on a range, only the values in that specific listDropdown menu blocking Sheets
HELP! I cannot work on my sheets because this drop-down menu that is there on load for all of my sheets is blocking me. Thank you!!Problem loading zoho sheet on Chrome
this is the error message - {"dt":"BANNER","a":199,"DU":true,"mt":"ERROR","mk":"Error.Internal.Server"}Adding phase change lines
Hello, I am need to add phase change lines to my charts that are built into the sheet instead of drawing a vertical line that moves when the chart is resized. Thanks for your knowledge on this topic. BobImportant feature such as cross-workbook reference or ImportRange?
Hello Is there a feature in zoho sheet that allows cross-workbook reference or ImportRange? If not, is there any plan to release this kind of feature in the near future? If there is not such feature, why people will come to Zoho from Google Apps? Zorgeconsolidating data out of several zoho sheets like Google Docs importrange
Hello, One of our Zoho customers, we are Zoho alliance partner, wants to move its office docs to zoho-sheets but they ran into a problem. Situation, see screenshot Imagine we have 3 sheets with different filenames and different data. How can we collect data from each sheet and merge it all together in 1 like shown on the screenshot. At google docs now they use Google Docs and their code is: @Googledocs "=importrange(.....,.....)" where dots refer to or are URL-based links to cells in different sheetsIdea : Ability to mark certain rows as title rows (heading1, heading2 et al) just like in MS Word
Namaskaram. Sheet remains close to our heart as one of the most popular go-to apps for anything under the sun! ☀️Having said that, it's useful to have the ability to mark certain rows as say 'Heading 1' rows, 'Heading 2' rows and so on, just like we do in Word/Zoho Writer or any document editing tool for that matter. This would help organise Sheet content much better. Also there could be allied features like, say, when I scroll, the heading rows could freeze on the top when the corresponding contentXLOOKUP, XMATCH, and six more robust new functions!
XLOOKUP, XMATCH, and six more robust new functions! Hello everybody! Zoho Sheet has introduced eight new functions to help you create more sophisticated, efficient spreadsheets. Let's take a look at these functions and their usage. Let us know in the comments how you plan to use them in your spreadsheets! XLOOKUP (lookup_value; search_table; result_table; [if_not_found]; [match_mode]; [search_mode]) VLOOKUP, one of Zoho Sheet's most used functions, has helped people create reports or instantly lookHow to access a different workbook in a different folder using VBA
Hi I have an sheet application written in VBA. One of the tasks is to import data from another workbook . The workbook containing the data is in a different folder ( both on the cloud ) ( relative path is ../Dir/Workbook ) . How can this be done using VBA in sheets.Spreadsheet
Is their a way to set up alternate colors (by row) to give the spreadsheet the look of a check register ? Thanks, BruceAn edit in Sheets is not being updated in CRM
An edit in Sheets is not being updated in CRM. Does the Sheet need to be manually re-imported?Introducing Race Charts: a smart way to visualize historic data
Visualizing data recorded over a long period of time just got more interesting! We're excited to introduce Race Charts to Zoho Sheet's already extensive chart family. With our built-in data visualization feature, you can quickly create a bar chart race that animates continuously where the bars race against each other based on the data—no extra coding or add-ons required! These animated bar charts jazz up your spreadsheets while you sit back and watch your data come to life. But why stop there?Moving all users to the new Zoho Sheet
Hello everyone! We introduced the latest version of Zoho Sheet—Sheet 5—in early 2019. This new version consists of a new user interface, improved performance, and an array of useful features. The old version of Zoho Sheet will be deprecated permanently on February 29, 2020, a year after Sheet 5 was introduced. After February 29, 2020, all users of the old version will be moved to the new version, and you will no longer be able to switch back to the old version. Update: All users will be moved toSheets Templates
Our company has multiple excel templates that many people have access to use. When a user uses the template they must save it as something else to keep the template clean. I have created a template in sheets but I have not seen a way to keep it clean using sheets. How can we keep the template to remain clean after each use. i did not find a way to do that, when the sheet was closed out and reopened it had the previous use information in it and that is not what we want to happen. Is there a wayIndent?
How can we indent in a cell? Simply prepending spaces does not work, as they're stripped, and that isn't the right answer anyway. No change since 2008? http://forums.zohonotebook.com/forumHome.do?forumGroupId=2266000000002001&forumTopicId=2266000000120088 This is pretty much a staple of all financial spreadsheets...and makes Zoho Sheet really impossible to use without it. Hopefully I'm just missing something!Zoho Docs reporting "Something went wrong and we're unable to generate a preview."
Since 2012. I've been using Zoho Docs to edit this spreadsheet and had no problem until couple of days ago. I can't open the document because I constantly get an error "Something went wrong and we're unable to generate a preview.". I've tried to press the download button but I've only got the message "Preparing to download..." which disappears after few seconds without initiating the download. Then I've tried to press "Open with Zoho sheet" and after pressing "Continue" button, again nothing happen.Zoho sheet cell lock option
Frds in my zoho sheet, there is no lock cell option appearing at all.[New Version of Spreadsheets] How to make text overflow into adjacent cells?
I recently changed to new version of spreadsheets, the team has done a excellent job! Now its much more responsive and faster while making changes . But I am having a big issue, all the cells are by default formatted to have no text overflow to adjacent empty cells . This has made my old spreadsheets look very different and not as it was intended at the time of creation. Is there any way to permit text overflow?Slow sheets...WHY!?
PLEASE resolve my slow sheet issues? When I enter data it's like I have slow internet or something BUT I don't. I have a wired desktop with Gigabit data speeds. However, every entry is so slow! What's up?! I heard that sheets with too many cuts and pastes might be the issue. How to I refresh this or something? I can't last much longer operating like this! I'm about to find a microsoft or apple solution if you don't do something quick.Why is the csv.-display from my file in Zoho different in compare to Excel?
Hello my dear community, I hope, you can help me with my question.:) Like you see in my two attached pictures, the display is different, although, it is the same file. With Zoho, everything is allright. But in Excel, the display seems chaotic and I don´t know why. Maybe, anybody knows the reason for this difference? Thank you very much in advance for your help. Best wishes to all of you. AndreasNext Page
Access your files securely from anywhere
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements thatThemes in Zoho Sheet: Keep your spreadsheet's formatting consistent
Formatting a spreadsheet is now even easier with Themes. With Themes, Zoho Sheet empowers you to select, customize, and apply a uniform formatting style throughout the entire spreadsheet. When working on a data set with collaborators, you might noticeSlicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,Our pivot tables just had a pivotal update!
A pivot table can help you summarize rows and rows of data in a single table. This means you are readily provided with the insights that you need from your data. Zoho Sheet has now made this process a little more easy with the new pivot table enhancements like auto-refresh, auto-expand and has made it possible to experiment a little as you create your pivot tables. Keep working on the data; we'll keep up with you! Here's a classic issue with the traditional pivot tables. You'll have to keep refreshingCheck out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format
Most Discussed Topics
Syncing Sql Query Table to Zoho Sheets
I want to sync Query table to Zoho Sheets. I already used data connection zoho sheets but the issue I am facing is while it gets synced the data I entered in new columns next to synced columns is getting mismatched as new row data is coming. So is thereSUMIF with "=" condition giving #NAME! error
I have =SUMIF(H21:H27;=&B55;I21:I27) which is throwing an error. Have tried =SUMIF(H21:H27;=B55;I21:I27), =SUMIF(H21:H27;"="&"B55";I21:I27) and =SUMIF(H21:H27;"=B55";I21:I27)Data overlapping error - data connection schedule
Hello, I created a spreadsheet and connected it via data connection to zoho analytics, asking to fetch data monthly from a table in analytics. I want the data in the spreadsheet to be replaced each month with the newest data in the analytics' table. Eachzohosheet keep loading and don't know how to fix it
one of my zoho sheet is getting slow. How to fix it.
Zoho Developer Community
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
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
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
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements thatSlicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the FormatTip #16: Ask Zia your data-related questions and get powerful insights
Zoho Sheet provides a variety of tools and functionalities to help you analyze your data from end to end. But what if you could analyze all your data sets with a single AI-powered tool? Meet Zia, our smart virtual assistant who will answer all your data-relatedFormat and analyze spreadsheet data with Zoho Sheet's Table
While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,
Top Contributors
Murugalakshmi S
Narendra Eswar G
Vinoth Kumar K
Mehnaaz T
kvansensie