Introducing 15 new Zoho Sheet functions

Introducing 15 new Zoho Sheet functions

Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient text and spreadsheet functions. Read more about these functions below.
 

Text functions 

ARRAYTOTEXT()

This function allows you to combine values from a range of cells into a single array of text values separated by ";" for columns and "|" for rows. You can choose to display them as simple text or as an array inside the cell.
 
Try it out with the embedded range below!



TEXTSPLIT()

Using this function, you can split a text string into multiple rows and columns with your desired delimiters. While the SPLIT() function helps you split text into adjacent cells in a row, TEXTSPLIT() can be used for splitting text into adjacent cells in a column as well.
 
Try it out with the embedded range below!


 

TEXTAFTER() and TEXTBEFORE()

Use these functions to retrieve part of any text string with your desired characters as the delimiters. For example, you can use the TEXTBEFORE() function to extract the user names from email addresses with @ as the delimiter.
 
Try it out with the embedded range below!

 
 

Spreadsheet functions 

CHOOSEROWS() and CHOOSECOLS()

Still copy-pasting rows/columns from one table to another? Quickly locate and retrieve any desired rows or columns from your data set using these two functions.
 
Try it out with the embedded range below!





WRAPCOLS() and WRAPROWS()

Here's another way to avoid manually copy-pasting values to restructure a data table. Quickly arrange any set/range of values into an ordered array either by column or by row.
 
Try it out with the embedded range below!



EXPAND()

Resize data tables without losing any values using the EXPAND() function. Not a fan of error values occupying the extra cells in your array? Simply fill in your desired value.
 
Try it out with the embedded range below!


 

LAMBDA functions 

We have added six new LAMBDA functions to help you perform customized calculations within your spreadsheets.
 
  • MAP()
  • REDUCE()
  • SCAN()
  • MAKEARRAY()
  • BYROW()
  • BYCOL()
 
Click here to learn more about the new LAMBDA functions.
 
Let us know which functions you're looking forward to using in your spreadsheets in the comment section.



Join the Zoho Sheet community and stay updated on the latest features, interact with fellow users, and learn from the team behind Zoho Sheet.


      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • 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. If
          • Meet the latest feature of Zoho Sheet: Lock Cells

            We are happy to announce the release of one of the most awaited features in Zoho Sheet. ​You can now lock the cells that you wish to keep ​secure. Once you are done with editing cells, you can lock them so that they won't be modified anymore. We believe that this feature will be a great addition to our existing set of collaboration features and is intended to improve your collaboration experience. You can access this new feature Lock from Data tab. Apart from being able to lock individual cell ranges,
          • Feature enhancement: Highlight rows based on a cell value

            Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw
          • Revamped 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.
          • Slicers 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,

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ










                                ご検討中の方

                                  • Recent Topics

                                  • If Problema Formula

                                    Ceil(Datecomp(${Seguimiento de Venta.Fecha de la proxima visita},Now())/1440) Tengo porblema al plantear el If Quiero que si el valor es dega
                                  • Trying to do commission tracking with zoho crm, can i do a Lookup against multiple fields in a module?

                                    So i'm still designing my zoho one crm as i come over from salesforce. One of the things i'm trying to build is a commission tracking module. At some point i'll probably hire someone to help with custom code, I'm just proof of concepting it. I"m not sure
                                  • How to Move OST to PST without Outlook

                                    MailsDaddy OST to PST Converter is an outstanding solution that help users to complete the conversion task without hassle. It offers users to convert multiple OST files into PST format with complete data security. Here users can open and access the complete
                                  • New in Zoho Sign: Allow recipients to review and change associated recipients

                                    Greetings! We are happy to announce the addition of a new recipient role, Manages recipients, in our signature workflows. This role enables a recipient to review, modify, or add details for any recipients associated with them in the workflow. This ensures
                                  • Zdk-cli

                                    As i have tried to login to zdk cli as it returns this error ✔ Success! Logged in as JAYANTHAN ✖ Error during initialization of zdk api supported only in sandbox environment
                                  • Zoho Creator Populate radio field with values with all the created rows subfor

                                    I have Main Form where i have a lookup field where i get brewery names and the number of tanks as a multiline text field with a list of beer names Based Brewery selected and bbt_tanks number i create rows in the subform and now i want to populate list
                                  • Mapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually

                                    Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be able
                                  • Customer Portal Zoho Desk | Sort ticket list

                                    Hello, If you view the ticket list inside the desk portal (https://xyc.zohodesk.eu/portal/de/myarea?departmentId=xyz) all tickets are displayed depending on the filters: department "my tickets" / "team tickets" status group/type channel My questions:
                                  • Train Zia answer bot on only part of Knowledge Base?

                                    We are trialing Zia answer bot and hope to use it on the knowledge base to help our users find the information they are looking for. I have found how to train Zia on the entirety of our knowledge base. But is there a way to train it on only certain categories
                                  • Customer/item(s) bought view

                                    Hello In Inventory/Customers/Transactions tab, how do I see what it is the customer actually ordered/bought without having to open each SO? Our customers buy a number of items thoughout the year. I've look at each transactions drop down, and no-where
                                  • ERROR: Product type cannot be changed for Items having transactions.

                                    I have mistakenly added a product type as goods for an item that was a digital service. Now when HSN/SAC became mandatory, this brought my attention to this error I did. So I tried changing the product type but it displayed this error message Product
                                  • Inventory Asset vs Finish Goods vs Work in Progress please explain or help me choose

                                    New to this so please if you can help in any way I would really appreciate it. So here we go. I make and sell and item which is made out of bunch of other items. (Composite Item). Now one of the parts that the item is made from is also a composite item.
                                  • WorkFlow to Update Custom Field in Sales Order with Tracking Information from Shipment of that Sales Order

                                    Hello All- I'd like to update the sales orders with the tracking information I enter in the shipping document. What is the proper variable to get the tracking information out of the shipping document? See attached.
                                  • ZOHO Desk-Enable Ticket Notification sound

                                    Hi, I answer the helpdesk tickets for Sevenstar. How can I enable the Ticket Notification sound when I receive a new ticket?
                                  • Differentiating between invoice templates when adding custom fields

                                    We are adding HS codes to the items which we would like published on our international customers invoices plus other export data required. We don't need this data on our domestic customer invoices. We have setup an invoice template for them but it if
                                  • Batch Tracking Enhancements In Zoho Inventory

                                    Hello users, We’re excited to announce that we’ve taken batch tracking to a whole new level in Zoho Inventory! We’ve made it more accessible and easier to use than ever. Here’s a quick look at the improvements: 1) A New Way To Create or Modify Batches
                                  • CRM to Writer Mail Merge Preview not working

                                    When performing a mail merge from CRM to writer the preview function does not work. I get the following error. I am a Zoho one user on a ChromeOS. I have been successfully using mail merge from CRM to Writer about 4 years. This error seemed to coincide
                                  • Workflow not triggered by custom function field update

                                    I have a simple workflow that triggers when a field is updated on a Deal page. It works fine when I "manually" update the field via "edit" on that Deal page. It does NOT however work or trigger when that same field is updated with a custom function. I
                                  • Version history for Zoho CRM Functions

                                    Hi Zoho Support, I am wondering, there is no topics been posted for requesting the Zoho CRM Custom Functions Version history. It would be great to have mandatorily needed feature in Zoho CRM custom functions. Is there any work going on for this feature.
                                  • Zoho CRM's V8 APIs are here!

                                    Hello everyone!!! We hope you are all doing well. Announcing Zoho CRM's V8 APIs! Packed with powerful new features to supercharge your developer experience. Let us take a look at what's new in V8 APIs: Get Related Records Count of a Record API: Ever wondered
                                  • Bookmark order

                                    Hi all, We have a very big document/template that requires manual editing after doing a mail merge. To make this easier, I thought I would add bookmarks to navigate to the areas that will require editing. I thought these would be in order that they appear
                                  • How do I associate an expense to multiple projects?

                                    How do I associate itemized expenses to multiple projects, like assigning each line to the respective project
                                  • Show Zoho Books Retainer Invoice in Zoho CRM

                                    Hi Support, How can I get Retainer Invoices created in Zoho Books to show in Zoho CRM? If a sales person needs to collect an upfront deposit, they should be able to see that the retainer invoice has been created and paid. Thanks, Ashley
                                  • Creator portal user do not accept user password upon creation

                                    I placed a request at Zoho and they are working on it, but I try here too in case somebody has already the answer: Today, sudently, my customers that tried to join the portal were not abble to enter a valid password, even if the password had all the necessery
                                  • Shopify sales orders creating a new account in Zoho

                                    Hi all, I am having a slight issue with the shopify integration. Whenever a customer purchases from the store, shopify automatically creates a sales order in inventory. The issue is that it creates a new account for the customer's name instead of attaching
                                  • Its 2022, can our customers log into CRM on their mobiles? Zoho Response: Maybe Later

                                    I am a long time Zoho CRM user. I have just started using the client portal feature. On the plus side I have found it very fast and very easy (for someone used to the CRM config) to set up a subset of module views that make a potentially extremely useful
                                  • Multiple Zoho Attendees in a Customer meeting

                                    We are having constraints with having to log duplicate meetings when we have 2 Zoho users attending a customer meeting. What are the options to resolve this? You can add participants, but you cannot report on them. What can be done to avoid creating so
                                  • Allow 2 logos for Branding, one for Light Mode and one for Dark Mode?

                                    Our logo has a lot of black text on it. If we leave the background transparent, per recommendation of Zoho, when a user is viewing a file and turns on dark mode, our logo is not really visible and looks really weird. It would be really great if we could
                                  • CRM Campaign -> Create Campaign ->Zoho Campaign. Add to Sender Address dropdown options (2024/08/01)

                                    I'm trying to add different Sender Address and Reply-to Address options to a new campaign created through Zoho CRM. There is one sender and reply-to address available and it is not the account I'm logged in with. The dropdown options do not match what
                                  • Create new ticket when another specific ticket is closed

                                    Hi. How can I create a ticket when another specific ticket is closed? So I have a ticket with subject 'Create agreement' connected to the contact of a customer. As soon as I close this ticket, I want that a new ticket is created (connected to the same
                                  • How can a Zoho Desk Admin access restricted files?

                                    How can a Zoho Desk Admin access restricted files from Zoho Desk that are not displayed to agents on tickets due to file type restrictions?
                                  • Why is my Lookup field not being set through Desk's API?

                                    Hello, I'm having trouble setting a custom field when creating a Ticket in Zoho Desk. The endpoint I'm consulting is "https://desk.zoho.com/api/v1/tickets" and even though my payload has the right format, with a "cf" key dedicated to all custom fields,
                                  • Ticket template - Send email to multiple contacts

                                    Is it possible to set up a ticket template with multiple contacts selected to receive an email, rather than just one contact as the default? We use Zoho Desk to send an email report to a group of contacts every day, and have to manually add each email
                                  • Enrich your CRM data and keep them updated

                                    You spend a lot of your time and efforts in generating quality leads for your business. While generating leads is a challenge in itself, the real deal begins when sales reps try to nurture these leads and convert them as customers. So how equipped is your sales team with information about your leads matters a lot.  For example, you might be using webforms to generate leads and collect customer information from your website. The lesser your webform fields are, the more your sign-ups right? From optimizing
                                  • Feature Request – Support for Stripe Direct Debit for Canadian Customers in Zoho Books

                                    I’d like to request support for Stripe Direct Debit as a payment option for Canadian customers within Zoho Books. Currently, while Stripe credit card payments are supported for Canadian businesses, there is no option to enable Direct Debit (ACH/EFT) through
                                  • Client Script also planned for Zoho Desk?

                                    Hello there, I modified something in Zoho CRM the other day and was amazed at the possibilities offered by the "Client Script" feature in conjunction with the ZDK. You can lock any fields on the screen, edit them, you can react to various events (field
                                  • Zoho desk domain mapping not working

                                    Hi, I have followed this knowledge base support from your zoho site: https://help.zoho.com/portal/kb/articles/support-customers-from-your-own-domain-domain-host-mapping . First created a sub-domain(support.website.com), then went to zone editor to point "support.website.com" to cname desk.cs.zohohost.com . But it won't work out. What did I lack? Please I need it very much. Please see images below of the result: Please see below images of what I did: 1.)  2.) 3.) Hope to hear from you soon.
                                  • Zoho Analytics pulling data from Zoho Sheets and Zoho Forms

                                    It would be smart to have Analytics import data from Zoho Sheets or Forms. 
                                  • Feature Request – Support for Saskatchewan PST Self-Assessment in Zoho Books

                                    I’d like to suggest a feature enhancement for Zoho Books regarding Saskatchewan PST (SK PST) self-assessment. Currently, when filing the SK PST return using Zoho Books’ return generator, there is a field labelled “Consumption Tax”, which is intended for
                                  • Exporting Presentations with Embedded Integrations

                                    I am embedding Zoho Analytics charts and tables - how can I export the presentations so that the embedded images show ? At the moment it just shows broken images . *note* I do not need the exports to have the live data or links - just a snapshot of what
                                  • Next Page