Zoho Sheet - No filter() function
Hi! There is no filter() function in Zoho Sheet. I attached a few print screen where you can see there isn't a function named 'filter'. I really need this function because right now i need to transfer all of my data into Google Spreadsheet to use fi
Font size on button
How do I( alter the font size of a label on a button? Adding the button is easy. But if I right click, and select Edit Label, I can only edit the text, nothing else. So I get Arial 10pt, black text, no other options. Like Henry Ford reincarnated: "You
Server Issue for Zoho Sheets
Unable to access zoho sheets (constant loading status)
Zoho Sheet is "temporarily unavailable"
My system is showing that Zoho Sheet is temporarily unavailable. Is there a time frame for when it will be restored?
Is there a way to access the data of a cell from a different spreadsheet?
Let's say we have two spreadsheets that are both accessible from the same zoho documents account: docA and docB Can we write a formula in cell in docA that references a cell from docB? What is the syntax to do so?
AMPLIAR ACCESO A ZOHO SHEET
POR FAVOR AMPLIAR MI ACCESO A ZOHO SHEET
Pueden ayudarme hacer ua lista por favor
Quiero hacer una lista que se encuentra en una columna de otra pagina
Ambiguous Limit Exceeded
I imported an excel file. When I filter a specific column it pops up an error saying : Limit Exceed for maximum characters in cell. List has thousands of rows. How do I know which cell caused the limit violation ??
force close
it is force close when i start editing on mobile phone
Number Format
How's to format numbers in Indian Style, like Lakhs and crores? Can anyone help. Thanks
TODAY() function does not work for me as part of the MINIFS function (Help?)
Hello, need help, please... I want to extract the next date, either today's date or the next day. Tried actually several hours with various combinations, ended up by using the MINIFS function combined with the TODAY() function. Finally had to give up.
Work seamlessly with Sheet's shortcuts without affecting the browser
Navigating your worksheets and performing specific actions should be a quick and easy process. That's where keyboard shortcuts come in. Shortcut keys help you accomplish tasks more efficiently, eliminating the need to move away from the keyboard. What
sheet - copy and paste from excel
can't copy data from excel (Vista, Office 2007)or between zoho sheets joseunit11a
soucis
Je n'arrive plus a créé une nouvelle feuille
Manual edit of Conditional Formatting Range does not save
See screen recording. https://workdrive.zohoexternal.com/external/0e3e940caff0e33e2d0b7f559a4dad92a0cb0a78e23aed149baeec4eb3671289
ZOHO CRM AND ZOHO SHEET INTEGRATED
Hello Everyone, When I prepare an offer, I have an excel table and I use it to find the price but I want to transfer this table to Zoho Sheet. My excel table helps to calculate final price. I want zoho sheet to put final price into offer page on the Zoho
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
Next Page