Customize toolbar
I'm hoping to move to Sheet from Excel. There are a handful of buttons I use constantly and would like on the toolbar rather than hunting for them. Is there a way to customize the toolbar to add commonly used buttons? Also, is there a way to put macro
Sheet - Sum by cell color ?
Hi Looked everywhere for this and can not work it out. Can do in Excel, but not in sheets. In a separate cell, I want to add a sum of values based on a cell colour from a column. Like if it is green it is this value, then in a separate cell if it is red
Problem with wrapping text in sheet
when I wrap text in the spreadsheet, the line height does not adjust to view the entire entry. I have to manually adjust each line for each entry. Should it not automatically adjust as in google docs or MS excel?
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, but
Please improve the toolbar!
Do you have plans to continue improving the toolbar? I waste A LOT of clicks increasing/decreasing decimal, setting number formats, formatting, adding borders etc. At the very least, can you make the toolbar bigger and have those pull down groups permanently
moving a chart
Hi, I have a bar graph in one of my sheets. It is working fine and changing when I make any edits to the underlying data. I have a problem moving the chart to a different place on the sheet. I need to enter information in the cells which are directly beneath the graph. I tried to select the chart and it just does not happen. I am using the latest 'stable' version of Chrome and I did not have this problem of selecting an existing chart. Please help. Thanks, Seshadri
How to remove hyperlink when there is additional text inside the cell?
Greetings, I hope find you all well and safe. I have a cell with an email address plus a text between parenthesis, like email@email.com (info) When I type just the email, I am able to remove the hyperlink normally, but when I type the additional text
how to lock the cell in the zoho sheet? Please help!
how to lock the cell in the zoho sheet? Please help!
Fetch CRM Deal Name in Zoho Sheet
Hi, I would like a user to fill out the form and have the form data sent to a Zoho Sheet. I've accomplished this task easily. What I would like to do next is based around get.Records or search.Records in the CRM based on 3 columns in the sheet. so the
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
Next Page