soucis
Je n'arrive plus a créé une nouvelle feuilleManual edit of Conditional Formatting Range does not save
See screen recording. https://workdrive.zohoexternal.com/external/0e3e940caff0e33e2d0b7f559a4dad92a0cb0a78e23aed149baeec4eb3671289ZOHO 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 ZohoCustomize 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 macroAnyone else having a problem with the macros?
After I have made a macro and saved it, I went to the manage section, but it does not show the macro (or any macro) I've made. Suggestions or solutions would be much appreciated.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 redProblem 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, butPlease 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 permanentlymoving 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, SeshadriHow 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 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 texthow 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 theSheet 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 helpBug 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 anI 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, aZoho 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 cellSum 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 SumCharts 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-viewHow 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 theseStock 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 againError 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 settingHow 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/callkalpaNew 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,Is it possible to display formulas in cells instead of calculated results?
I want to export my Zoho sheet as tab separated text without losing the formulas. In excel, I would use the settings Options - Advanced - show formulas in cells instead of their calculated results then save as tab separated values. How do I do this inI 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. ThanksTrigger 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 itembed 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/callkalpaNext Page
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
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 FormatAnnouncing 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 convenientlyIntroducing Dynamic Array Formulas to Zoho Sheet
We're happy to announce that Zoho Sheet has opened up the new dynamic array formulas to all our users! The addition of dynamic array functionality will make your spreadsheets and the formulas you use in them a lot simpler, while at the same time makingTip #16: Ask Zia your data-related questions and get powerful insights
Zoho Sheet provides a variety of tools and functionalities to help you analyze your data from end to end. But what if you could analyze all your data sets with a single AI-powered tool? Meet Zia, our smart virtual assistant who will answer all your data-relatedEdit History: Prevent data loss during collaboration
With teams moving to hybrid workplaces, remote collaboration has become routine. Zoho Sheet simplifies collaboration for distributed teams with user-specific access levels for file sharing, contextual commenting, and real-time editing tools. It also provides
Most Discussed Topics
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 frustrateddrop 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 inIs 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 theVBA 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.CalculateBeveled 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
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Zoho WorkDrive Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Sticky Posts
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 FormatTip #16: Ask Zia your data-related questions and get powerful insights
Zoho Sheet provides a variety of tools and functionalities to help you analyze your data from end to end. But what if you could analyze all your data sets with a single AI-powered tool? Meet Zia, our smart virtual assistant who will answer all your data-relatedFormat and analyze spreadsheet data with Zoho Sheet's Table
While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,Introducing Data Bars: Graphically represent changes in data within the cells
Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient methodZia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes
Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,
Top Contributors
rob
Vinoth Kumar K
Anouncia P
Narendra Eswar G
Joel Biju