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.
Using Flow to import data from Gsheet
Hello with out going into detail as to why I do this I just need help solving this. I have created a script in gsheet to send sheet data to a webhook in Zoho Flow. From there I want send this data to Zoho Sheet. I currently have the following code below
Zoho Sheet and Zoho Flow integration
Hello, I have integrated a spreadsheet with two worksheets with Zoho Flow. The trigger 'Row created or updated' works well if I manually update the worksheet. However, I have enabled a macro through a button in one of the worksheet to modify the worksheet
Zoho Sheets Filter Issues
I appear to be having ongoing issues with my filtering in zoho sheets. Occassionally random cells will not filter in accordance with the rest of the sheet. Usually I filter by time, and then date - this allows the full sheet to order by correct date &
Format change when Filtering
I have a large list of medical claims in a Zoho Sheet. Column A contains a picklist to update the status of each claim. Normally this works wonderfully, but lately, when I filter for a particular patient (or service, insurance company, etc), then work
Disconnect other users from file
We have a shared file that multiple people update occasionally. There are some users who select cells and then do nothing for days at a time. The "active" users seem to be slowing down my access to the sheet. Is there a way to disconnect anyone that is
Sum through multiple sheets
Don't believe this command works in Sheets sum(sheet1:sheet6!A4) Would be nice to add. Every time I click on sheet3 it moves to that sheet instead of treating it as a formula input
Issue with TEXT Function and Displaying Day of the Week (Zoho Sheets)
Hello, I'm using the formula =TEXT(DAY(A1);"DDDD") in Zoho Sheets to display the full day of the week for a date in cell A1. However, when I enter a date like 2/7/2024 (MM/DD/YYYY), the formula doesn't return the correct day (Wednesday in this case).
Make cells bigger
Hi I am new to ZOHO. How do I make the cells bigger in ZOHO sheet or make the cell grow when I type text into it?
Excel sheet embed in website
Sir, How to embed an interactive excel sheet into my website without displaying the other sheets like sheet 2, sheet 3 etc. I am ok with the zoho logo on the top right.
Download Failed from sheets
If I create a spreadsheet, then select the area, I go to download as PDF and it says Download Failed. This has worked for years, but suddenly today it hasn't. I have tried on different browsers, linux and Windows with same results.
Bitcoin
How can I get the current price of Bitcoin using a function similiar to the "stock" function?
Data Validation Rules dissapear for no reason
I set up all my data validation rules in zoho spreadsheet, and now this is the 3rd time that they have dissappeared!! Every Single data rule i set up! Why does this happen? Is this a bug? Im getting really tired of having to redo it every time
VBA to automatically update the current date.
Hello, I'm looking to have a VBA to keep the date of the day automatically updated without having to refresh or openmy Zoho sheet. I've tried this but it doen't work, can you please help? Here is what I tried: Sub date_update() Range("H1") = Date Application.Calculate
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
drop down dv not working with table
I've decided to swap out my working DV sourcing a cell range, to a table. I table create the data and redo the DV. I select the source data and it automatically loads "Table 11" into the DV box, but when completed there is not drop down arrow at all in
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?
Is there a way to send a Zoho Sheet signed with Zoho Sign?
I am using Zoho Sheets to create our employee files. We like using Sheets as we can use formulas and add as many lines as needed as the years' updates on salaries and job titles are updated. Is there a way to have the document sent for signature to the
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 Format
Anyone Can help me converting Excel VBA to Zoho Macro?
The Macro in general is pretty simple, It just opens a Workbook and copys some of data from that Workbook to the one that was initially open. But when I try to use it on Zoho I get this error "Unknown function: GetOpenFilename". If there is any other
Zoho 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.
With what formula can I find the last month of the year?
Hello. You did what Google did not do. Firstly, thank you. I turned the Google sheet into a Zoho sheet. With which formula can I find the last month of the year and the last month of the previous year? Now an incorrect result is coming. For example, for
Beveled Edges on Zoho sheet charts
Hello, I have a question about charts in Zoho sheet. Could we make beveled edges on the charts? Would really appreciate any response. Best regards, Harrold
missing side bars
Hi there, a member of my team has an issue with the scroll bars going missing on her sheet. is there any reason for this and any solution to the problem? attached is a screen shot of the problem.
How to reference cells from another workbook
Hi, I just like to ask for help on how to reference a cell from another workbook. Thank you. Harrold
Announcing Zoho Sheet's monthly webinar series
Hello there, At Zoho Sheet, we always strive to help you maximize your product experience. Hosting webinars has been one of the key ways for us to communicate product updates, share best practices, and engage the user community. To help you conveniently
Convert text to number
From Zoho CRM, there is a button "Zoho Sheet View" that converts the current view into a spreadsheet. One of my columns in CRM is Amount (a dollar value) but it converts those values to text in the spreadsheet. Is there a simple way to convert text to a number rather than going to each cell and deleting the preceding single quote? the same question applies to the date column. All the dates are now preceded with a single quote - is there a simple way to convert these from text to dates?
Anyway 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 to
Update 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 you
How do I share a single sheet from ZOHO spreadsheet?
I am sure I saw this option 15 days ago. I just stumbled on it and can't find it any more. I would like to share one sheet of a single document to each collaborator. Was it not possible? Thanks in advance!
Red dashed line around cell
I have a red dashed line appearing around a cell. It does not go away when I clear formatting and I'm not sure how to get rid of it. The formula in the cell is quite simple and the cell is displaying the correct result. The outline also persists if I
Connect a form with a Spreadsheet
I have a spreadsheet that performs once-off calculations on inputted data. I made the input fields editable and locked the other fields, and that works on a desktop browser (Firefox). However those fields are not editable on a mobile browser (Firefox
importXML function and related use case
Hi, I would like to know is the spreadsheet roadmap plans to implement the importXML function? My use case is as following: - I need to get date from a web page and then to compil them - I would like to publish the result in a blog in a form of the dynamic table. The table value must be updated as per the web value. - Because many people ask the way to do that with an online spredsheet, I prefer zoho then Google spredsheet, because when you share a range, the user can style edit it whithout modifying
Next Page