Multiselect Pick List items not showing in CRM data fields
I'm creating a Zoho sheet and using the Data Connection to connect to the CRM. This is working well except for a couple of fields that do not show up in the data connection field list. The two that are not showing are listed as "Multiselect Pick List".OpenAI issue
Hi, I've tried to enable OpenAi in Zoho Sheet as in this article Simplify your spreadsheet tasks with ChatGPT integration | Zoho Sheet Help Guide but I get this error below in the AskZia console: Credit limit exceeded. Any ideas? ThanksOccurrences in rows
Hi all, need some advice! I have the table below with details on the attendance of people at a class. What I want to do is to add up how many people (ID) have been in attendance anytime in the last 5 months measured from May. Note this is not how manyDate Format - YYYY-MM-DD
Why in the work would Zoho Sheets not support the date format YYYY-MM-DD - pretty universal - no confusion - and especially for data in a spreadsheet - can be sorted properly Blows my mind that this setting does not exist, or I can't find how to turnSlicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,How do you debug formulas in Zoho Sheet?
I have a workbook with a lot of extensive formulas. Debugging them is awful. Are there tricks I'm missing? I don't think you can step through or F9 like Excel, correct? I would love to hear everyone else's thoughts, tricks etc.1 Sheet was delete , How to recover?
Dear Authority , Hope you are well. I have face the problem when was opening the Zoho , Suddenly delete or missing the one sheet unfortunately for share the picture for demo. Need this missing file . It's very important file . How can I recovery thisGridlines disappeared
Gridlines disappeared on sheet. If i add the gridlines again, then close the sheet and reopen it, the gridlines are missing again.Open with Options
Hi Need Help. A file (Spread sheet or word / zoho writer) that is shared with me gives me an option to open with (web / desktop) options. However, it is not the same with all the files. What is the general behavior and how can I change it? - Regards,Sheets: Tags, labels or multiple pick list items in a cell
Is there a way to list multiple items (tags, labels, etc.) from a picklist or similar tool into a cell? I am doing a repetitive step during an audit/reconciliation process of having to manually write in different nomenclatures on multiple lines for multipleformulas don't work
Good afternoon, the formulas in the table do not work, I can provide access and screenshots if necessary=COUNTIF - formula issues - when value shows in one cell, show certain value in another cell
Hello, I have used "=IF(COUNTIF)" formula successfully in one workbook to look to see if cell D15 contains "plasterboard - 2.4m" and if it does to show "2.88" in cell E15. I then managed to add additional keywords to look for which would display differentOur pivot tables just had a pivotal update!
A pivot table can help you summarize rows and rows of data in a single table. This means you are readily provided with the insights that you need from your data. Zoho Sheet has now made this process a little more easy with the new pivot table enhancements like auto-refresh, auto-expand and has made it possible to experiment a little as you create your pivot tables. Keep working on the data; we'll keep up with you! Here's a classic issue with the traditional pivot tables. You'll have to keep refreshingHow to create “Table” in Zoho Sheet (and adjust colours) on iPad?
I am trying to figure out how to create/define table in the Zoho sheet app on iPad. Mainly so I can adjust colours/have alternating row colours. The format menu just doesn’t exist?!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 frustratedHow to make some cells invisible to some users
Hi there, I am collaborating with some colleagues and would like to hide some of the information in our shared spreadsheet (a few cells - not rows or columns). Would love to know if it is possible and how. Thanks, O-RenCreate 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 tryRun 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 youHow to change sheet alphabet color ?
HelpSome 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 youCharacters 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 belowZoho 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 worksheetZoho 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 workDisconnect 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 isSum 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 inputIssue 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 timeVBA 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.CalculateExcel 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 inCan 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?Next Page
Access your files securely from anywhere
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
Create and save user-specific filter views with Zoho Sheet
The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file. Collaborate with user specific filters Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. IfCopy across spreadsheets in Zoho Sheet
Now, you can copy your sheets to other spreadsheets or create a new spreadsheet with them. Not just sheets, copy a cell/range and paste it on any spreadsheet with formats and formulas unchanged. Copy cells/ranges Copy cells/ranges to same/different spreadsheets using Copy & Paste options, or Ctrl+C and Ctrl+V shortcuts. Copy sheet To the same spreadsheet The feature for creating a copy of a sheet in the same spreadsheet is now available as 'Duplicate'. Into a new spreadsheet Want to start a new spreadsheetRevamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.Tip #19 - Create checkbox tracker in your spreadsheet
Hello Sheet users! We are here with yet another tip to help you get the most out of Zoho Sheet. Spreadsheets can be used to handle a variety of tasks, but ever tried using checkboxes to track the progress of your action items dynamically? Here's a sampleTip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements that
Most Discussed Topics
Does Zoho Sheet "Save as PDF" support Thai font?
Hi I want to download Zoho sheet as PDF Document. In the preview it looking good but when I dowload it the font is look different. I use "Cordia New" but the result look like it swtich to "calibri". I try to use "Print" then select printing destination
Zoho Developer Community
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
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
Zoho CRM Resources
Sticky Posts
Create and save user-specific filter views with Zoho Sheet
The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file. Collaborate with user specific filters Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. IfRevamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements thatSlicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,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