Sheet not loading preset validations
My team and I share a zoho sheet and this week all of us are running into delayed issues regarding the preset data validation options. The sheet is not picking up what we are entering and this has been an ongoing issue all day today. I sent in a help
Bug fixing
I gave delete column instead of delete row for a selected row which led to the deletion of everything. When i clicked the left arrow,to return to the previous step the data that was lost was left as it is.i Lost all my data and have lost all my efforts.
Fixing the Bug and getting the datas back
By choosing a specific row,i clicked on "Delete column" instead of "Delete Row" which ultimately led to the deletion of everything. When i clicked on the left arrow button to get to the previous step,the data that was lost never returned and left as an
I need a demo
Please, I am a new user and I need a demo. How do I get one ?
I need a demo
Please, I am a new user and I need a demo. How do I get one ?
Use button to trigger Flow webhook
Hello, I am wondering if it is possible to have a button on a sheet that when clicked would send a webhook to Flow? I know how I'd imagine it would work, but definitely don't know VBA well enough. My thought was that when a user clicked the button, a
Zoho Sheet Hot to set Background Image
Is there a way to set a background image on the spread sheet?
Compare versions
There does not appear to be a way to compare versions of a spreadsheet to see what changes were made. Is this a feature being considered or is it already there and I just missed it?
Send Mail from sheets using a macro attached to a button
Hi, Request your support to help me with the macro. Functionality needed is to allow the button send mail to the selected email address cell. email content is just needed as a message not attachments attached to it. Regards Divya Panchal.
Fill series of data
Hello, I have several tables of data where I know the first and last cell value for each column. Is there a way I can populate the blank cells in each column to show values that gradually decrease, with the lowest value being greater than the bottom cell
Sum If from Picklist
I am seeking assistance on how to capture the sum in one column based on the column of picklist? Also, can date be added as a filter? Example: Column 1 is date Column 2 is sale Column 3 is picklist (item A, Item B) Sum if = Item A Sum if = Item B Sum
Charts in Embedded Docs Not Visible
Hello- Been experimenting with embedding a Zoho Sheet document within a web page. But I'm finding charts are not published when I publish a worksheet. Did a search and found this from 10 years ago: https://help.zoho.com/portal/en/community/topic/charts-are-not-showing-in-html-view
How 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 these
Stock function not working
Hello, For the last couple of days the stock function is not providing the latest stock prices. I've used this Sheets feature for quite some time and up until the last couple of days it was working. Today I converted my Sheets file over to the Workdrive,
If formula
How do I create a formula, such that if a cell with a checkbox is ticked, the previous cell containing the date of activity is erased and checkbox is empty again
Error calling macro module from Workbook_NewSheet
For several years I've used a sheet that calls a macro in a macro module from the ThisWorkbook module under Spreadsheet objects. Earlier this week I adjusted an unrelated part of the macro module, and the call from the ThisWorkbook module stopped working.
Date Time Format setting according to region wise
Hi i am facing issue of date time format setting in zoho sheet. By default there is american date time setting how can i change my regional setting
How to delete multiple empty rows?
I have a list of data that has been imported, however it now has an empty row in every 1 - 2 rows. Is there a way with the new data cleaner to remove these rows? I have over 1,000 rows.
Cannot copy from one spreadsheet file to another with formula
Hi, I am trying to copy a cell range (which has formula) from one spreadsheet file to a another, but only the values get pasted not the formula. How can I copy paste such that the formula gets copied instead of the values? Kalpa Pathum Welivitigoda http://about.me/callkalpa
New in WorkDrive: Share with Anyone on the Internet
If you need to share a document or file online, it's best to do this securely and reliably. While there are multiple methods for transferring files online, it's good to keep in mind the purpose of sending the information and understand who your viewers are. WorkDrive already gives you a customized External Sharing option, where the sender can control the link properties to share data securely. In addition to that, here's a new way of sharing files with external viewers. By using this new feature,
I cannot sort in sheets because of a 'merge' in the column
When I select the entire column and select UNMERGE, it still gives the error when I go to sort that column!
Import External JSON
Hello, How can i import (and keep it updated) a external web json? For exemple i have this test json: http://www.omdbapi.com/?i=tt3896198&apikey=8502817a How can i import it correctly? and also keep it updated. Thanks
Trigger a custom function in a Zoho Sheet on range change
Hello, I have a custom function in Zoho Sheet that updates a Zoho CRM record. That by itself works. I am trying to trigger that function when a new row is added to the sheet. I thought this would be able to happen via the VBA editor, but I can't get it
embed zoho sheet to google sites and allow real time update
Is it possible to embed zoho sheet to google sites and also allow real time updating?
How to check for duplicate values
Hi, I have a list of values in a column. And I keep adding more values to the column. I want to check and highlight the cells with duplicate values. How can I achieve this? I tried with conditional formatting, but there was no such option for duplicates. Kalpa Pathum Welivitigoda http://about.me/callkalpa
Zoho Sheets has frequent DNS issues - Zoho Sheets goes offline
At least once a week Zoho Sheets will go offline. I'll be in the midst of working on a spreadsheet and suddenly it's gone. Instead, I see this error message: This site can’t be reached Check if there is a typo in sheet.zoho.com. If spelling is correct,
New Toolbar in Zoho Sheet
We have revamped our toolbar design in this new version of Zoho Sheet. Below are some screenshots to help you get accustomed to this new interface. Click on the picture below to view the animated image in its original size. Scroll down this post to learn about the changes. Highlight of Changes: The previous format tab is now split into 2 tabs - Home and Format. The Home tab contains the commonly used functions and the Format tab holds formatting related options. Under the Home tab towards the far
How 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)
Paste as value, ctrl+shift+v bug
Scenario: Copy one cell Select range of cells Paste as value(s) from right click populates all cells Paste as value(s) from ctrl+shift+v only populates the first cell I work in tables A LOT and I need the keyboard shortcut to work so I don't overwrite
Tip #17: Easily share spreadsheets with non-Zoho account users
With efficient, collaboration-friendly options, Zoho Sheet is a popular choice among users. Sheet's external share links help you collaborate more effectively by sharing your spreadsheets with anyone outside your organization, including users who do not
sheets not working in certain PCs in the network
We are using Zoho sheets in our company. And suddenly for the past two weeks, we have a lot of issues and sheets don't work in many of the PCs
Why can't I scroll down the list of additional fonts?
Greetings, I was trying to add some fonts to my list from the ones available but I am not able to scroll down the list in any of the categories. I am only able to view the first dozen or so that are at the top of the list starting with the "A"s. I've
#EVAL! for personal function with "Deluge" in Zoho Sheet
I am trying to use a custom function, in a file that is shared with other users. It doesn't matter how simple the function is, I don't have the value assigned in the "return". Only get "#EVAL!" response. This is one of my functions, the simplest (made
How do I get my cell height to auto adjust?
I'm evaluating Zoho Sheet as a replacement for Google Spreadsheet. Using latest version of Safari, and experiencing the same issues in Chrome. A few bugs/things I can't figure out: Auto adjusting cell height when importing from Google Docs or creating a new document Turning off the auto date formatting for X.Y.Z where they are all integers.. (This is extremely important, as our requirements are written as outlines.. "X.Y.Z" corresponds to a requirement ID.. which is then turning into a date) The
Vertical alignment in sheet cells is incorrect
Vertical alignment of text in sheet cells is inconsistent, specifically, "Align Middle" does not actually put the text in the vertical middle of the cell. Consider these cells aligned bottom, taking note of the amount of padding is between the text and
error when adding a new row
hey i get this error when i try to add a new row "There was a problem with your last edit. Please check and try again" and this only happens to one workbook i tried the other once it works fine what can i do to resolve this problem thanks
Where 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 thanks
VALUE() function behavior
The VALUE() function bahaves differently than in Excel Excel =VALUE("2-4,1")=#VALUE! =VALUE("2-4;1")=#VALUE! Zoho Sheets =VALUE("2-4,1")=36926 =VALUE("2-4;1")=#VALUE! Where on earth does 36926 come from? Does the coma present issues in other formula
formula needed
I'm new to Zoho after being a Google Sheets user for years... lots of things I despised about Google Sheets... I now find myself missing ONE feature... their script editor... because of ease of use for my "lack of knowledge" in this area... I know enough,
[COUNTIF/SPILL] Trying to find result that fills 2 conditions at once / SPILL results
Hi! I have the following formula from an imported Google Sheet =countifs($B$2:$B; "<>0" ; $D$2:$D ; FALSE)*220 In the B column, I have a list of dates In D column, I have a list of booleans (TRUE/FALSE checkboxes) Opening this formula, we have: Range
Next Page