Make Zoho sheet clears cells automatically?
I have a sheet I use to calculate prices and other data. I want the sheet to automatically clear the data in A3:A100 either when opening or when closing. Is this possible?
Currency Invalid Symbol
Hello everyone! The formula is correct! =CURRENCY(1;"USD";"BRL") Why does the value appear as invalid symbol?
Run macro automatically/on a schedule
I have a macro that I would like to run automatically in Zoho Sheet. However, I do not see any way of doing that. Has anyone got an idea on how to do that? Kind regards
How to get NSE/BSE Stock Prices in Zoho sheets?
I've been looking for a function that provides me with the NSE/BSE listed stocks price in Zoho Sheets like GOOGLEFINANCE in Google sheets, but I found none. Please help if there is any way to het stock prices?
How to integrate the zoho sheets with your Application
Hello Zoho Developers, Here are some tricks and ideas for Zoho Sheets. Zoho sheets. Zoho Sheet is an online spreadsheet application that's part of the Zoho Suite. It allows users to create, edit, and share spreadsheets in real-time, similar to other spreadsheet
Zoho slow
i am eko in indonesia. i have 20 users under my corporate account. i recently experience slowness when open zoho sheets. is there any problem
Can't scroll the page down unless I refresh the page
Hello, This issue has been going on with me and a lot of other users in my organization, we can't scroll down! the scrolling side bar doesn't appear and scrolling down through mouse or keyboard keys doesn't work, it seems that the page just ends in the
No option to change the ownership of the zoho sheet
In zoho sheet app there must be some option to change the ownership of the sheet , even super admin also does not have any such option available. Community what's your views on this ?
Shapes, arrows and other similar components in Zoho Sheet
Hi Team, Do we have shapes and arrows in Zoho sheet or Is there any plans to release it to the Zoho sheet?
Lets increase the 25MB Limit of spreadsheet file size to at least 50MB.
Lets increase the 25MB Limit of spreadsheet file size to at least 50MB.
When might we get "advanced" range, sheet locking?
I need more thorough locking capabilitiies, most importantly ability to lock a sheet from structural changes. Any plans for more locking functionality?
Is Zoho Sheet available for Linux ?
Is Zoho Sheet available for Linux ?
Themes 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 notice
Users having trouble accessing shared Sheet
Hi, Some of my users are having problems accessing our Sheet. When they use the link sent in the original invitation email, they can get to the shared sheet with no problem. When they log into Zoho without using that link, the sheet doesn't appear in their shared folder. Any suggestions would be appreciated!
How can i set Multiple Owner?
How could i set multiple Owner (all writers) to a sheet? All "writers" want to have a change email if one writer changed the sheet
Multiselect Pick List items not showing in CRM data fields
I'm creating a Zoho sheet and using the Data Connection to connect to the CRM. This is working well except for a couple of fields that do not show up in the data connection field list. The two that are not showing are listed as "Multiselect Pick List".
Conversion 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 to
OpenAI issue
Hi, I've tried to enable OpenAi in Zoho Sheet as in this article Simplify your spreadsheet tasks with ChatGPT integration | Zoho Sheet Help Guide but I get this error below in the AskZia console: Credit limit exceeded. Any ideas? Thanks
Occurrences in rows
Hi all, need some advice! I have the table below with details on the attendance of people at a class. What I want to do is to add up how many people (ID) have been in attendance anytime in the last 5 months measured from May. Note this is not how many
Date Format - YYYY-MM-DD
Why in the work would Zoho Sheets not support the date format YYYY-MM-DD - pretty universal - no confusion - and especially for data in a spreadsheet - can be sorted properly Blows my mind that this setting does not exist, or I can't find how to turn
Slicers 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,
How do you debug formulas in Zoho Sheet?
I have a workbook with a lot of extensive formulas. Debugging them is awful. Are there tricks I'm missing? I don't think you can step through or F9 like Excel, correct? I would love to hear everyone else's thoughts, tricks etc.
1 Sheet was delete , How to recover?
Dear Authority , Hope you are well. I have face the problem when was opening the Zoho , Suddenly delete or missing the one sheet unfortunately for share the picture for demo. Need this missing file . It's very important file . How can I recovery this
Gridlines disappeared
Gridlines disappeared on sheet. If i add the gridlines again, then close the sheet and reopen it, the gridlines are missing again.
Open with Options
Hi Need Help. A file (Spread sheet or word / zoho writer) that is shared with me gives me an option to open with (web / desktop) options. However, it is not the same with all the files. What is the general behavior and how can I change it? - Regards,
Sheets: Tags, labels or multiple pick list items in a cell
Is there a way to list multiple items (tags, labels, etc.) from a picklist or similar tool into a cell? I am doing a repetitive step during an audit/reconciliation process of having to manually write in different nomenclatures on multiple lines for multiple
formulas don't work
Good afternoon, the formulas in the table do not work, I can provide access and screenshots if necessary
=COUNTIF - formula issues - when value shows in one cell, show certain value in another cell
Hello, I have used "=IF(COUNTIF)" formula successfully in one workbook to look to see if cell D15 contains "plasterboard - 2.4m" and if it does to show "2.88" in cell E15. I then managed to add additional keywords to look for which would display different
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 refreshing
How to create “Table” in Zoho Sheet (and adjust colours) on iPad?
I am trying to figure out how to create/define table in the Zoho sheet app on iPad. Mainly so I can adjust colours/have alternating row colours. The format menu just doesn’t exist?!
Excel Answer to Zoho, it seems
I can’t edit zoho spreadsheets in chrome on my mobile, period. They were created on my laptop with no collaborators. I’ve installed ZS app on my mobile, and I can edit but all of the DVs are corrupted - intact but in the wrong places. I am very frustrated
How to make some cells invisible to some users
Hi there, I am collaborating with some colleagues and would like to hide some of the information in our shared spreadsheet (a few cells - not rows or columns). Would love to know if it is possible and how. Thanks, O-Ren
Create a missing values LIST after using the "find missing value" function.
Zoho sheets data cleaning does a great job of finding missing values function when comparing two columns. But then it wants to fill in the columns that are missing. What I want to do is create a LIST of the missing values in a separate column. Make sense?
hide zero values
Excel has a feature where you can show or hide zero values for each worksheet. How do I do that in Sheets?
Can't View Embedded Sheet From Mobile Devices
I've embedded a portion of a sheet as an iframe to html. It works perfectly on my computer. But when I try to pull up the same page on my phone, regardless of browser, a message comes up that says "Sorry! There's a problem with the server. Please try
Run a custom function in VBA Macro
Hello, I have a custom function to update a record in CRM through a worksheet, but I would like to trigger this custom fuction to a button using VBA, it is possible?
Why Are Columns Reset When Deleting Entry
Hello, this is quite annoying. We use forms as a questionnaire for candidates, we filter entries by removing columns, when we delete an entry the columns reset. Every "delete" the columns reset, why!? Thank you
How to change sheet alphabet color ?
Help
Some Company Users Display As External User?
Hello, why do some our staff emails show up as external users even though they have the same URL? Thank you
Characters are jumbled no matter how slowly I type them
I'm not sure if this is a problem for others but I've found the new interface much slower to load and so on. Now, today, when I type in cells, no matter how slowly I type I am getting the words/figures scrambled. So if I was typing cat, I could end up with act or tca or cat. I am almost having to reposition the cursor for each individual letter or number I type. I'm still using the exact same browser, computer connection etc but this is very frustrating and makes Sheet too slow to be useful.
Next Page