Currency Invalid Symbol

Currency Invalid Symbol

Hello everyone!
The formula is correct! =CURRENCY(1;"USD";"BRL")
Why does the value appear as invalid symbol?



      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

          • Introducing Forms in Zoho Sheet

            We hereby bring you the power of ​forms in Zoho Sheet. ​Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you
          • 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

                                  • Voicemail to Text Transcription

                                    Hello, We use the Twilio phone integration in Zoho Desk. When a voicemail is left, it creates a Ticket in Zoho Desk, and we are able to listen to the audio recording in the Ticket. My hope is to also have a voicemail-to-text transcription show up in the
                                  • Workflow to update the field "Deposit To" in Sales Receipt/Invoice

                                    After an invoice/sales receipt is created, I can't find a way to create a workflow that would update the field "Deposit To". Apparently, some other fields are visible in the workflow, but not the "Deposit To". Any insight?
                                  • payment gateway disabling in my ecommerce store

                                    hi i have disabled my payment gateway paytm from my website soigne from the backend but it is showing in my front end part when someone orders my products i want to remove it completelty so that it does not show in the front end part plz give me a suitable
                                  • Record GST Paid for Imported Goods

                                    In Australia, goods that imported from overseas needs to pay GST per invocied value. In most case, the freight forwader (logistic agent) paid this on behalf of importer (us), and invoice us in together in their freight invocie.  How do we setup a proper
                                  • subscribe email list for offer and updates is not working for zoho commerce

                                    my subscribing to email list is not working for offers and updates for my ecommerce website soignee it is saying please wait can anyone tell me the reason for this
                                  • how do i see a list of active End Users?

                                    looking for a list of who i sent invitations to be an End User?  who has signed up? 
                                  • Email template for customer notification on ticket reply is not being used

                                    I've set up an email template for notify contact up upon receiving a reply in ticket. When I send a reply to the ticket, it is not using that email template. It just sends a normal looking email. How do I make it so that the email template is being used?
                                  • Conversation to Resolution

                                    Good day, I'd like to know how others are doing it. When we close a ticket, we reply to the ticket via email with photos of the issue and disclaimers. Then, we enter (copy and paste) the exact text in the resolution for reporting. I asked Zogo for a possible
                                  • Zoho Desk - Feature Request - Add more social channels on Community user profile

                                    Hi Team, While updating my profile here I noticed that it is only possible to add Facebook and Twitter social links. 1. Please consider adding at least LinkedIn and if possible, other popular channels. 2. Please consider renaming Twitter field name to
                                  • 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
                                  • ViewID and Zoho Desk API

                                    I'm looking at the documentation for Listing contacts and it looks like you can filter by ViewID. I assume this is views created in a department or all departments. Is this correct? And if so, how do I find the ViewID for that view? EDIT: I see the view
                                  • In Zoho CRM, is it possible to transition from Approach 1 to Approach 3 based on the contract End Date? automatically

                                    In Zoho CRM, is it possible to transition from Approach 1 to Approach 3 based on the contract End Date? I have one issue between Approach 1 to Approach 3 there is another transition Approach 2 Iam faceing the issue if use the blue print API means i able
                                  • HOW CAN I ADD NOTE FIELD IN EMAIL TEMPLATE?

                                    I have an email template which i use as a lost deal notification. I would like to mention "Note" field also which captures the reason for the lost deal. I am not able to do so and i checked with help desk and they confirmed that it is not possible. Is
                                  • Remove OpenAI Dependency for Zia Meeting Keynotes & Add Hebrew Support

                                    Hi Zoho Meeting Team, Hope you're doing well. We would like to request the following enhancements to the Zia integration for meeting keynotes in Zoho Meeting: 1. Remove the Dependency on OpenAI's ChatGPT Currently, Zia uses OpenAI’s ChatGPT to generate
                                  • ZOHO Task deleted accidently

                                    Hello team, Can you please help me with a deleted task that was created in general task list for one of my project. The task is very important to me as it was created by client. Please help me.
                                  • I dont see Timesheet configuration for my client

                                    I dont see Timesheet configuration for my client
                                  • Add Hebrew Support for Meeting Transcripts Provided by ZIA in Zoho Cliq

                                    Hi Zoho Cliq Team, Hope you're doing well. We would like to request the addition of Hebrew language support for the Meeting Transcript and Summary feature in Zoho Cliq. Currently the transcript and summary feature is available for recorded meetings and
                                  • Zoho Inventory for VEHICLE Business

                                    Can someone guide me, how we can import list of stock items pertaining to stock of cars. The unique number is Chassis Number
                                  • update warehouse id for closed credit notes

                                    the code run successfully but its not updating the warehouse, i send payload of warehouse id and name ,then tried to clone exisitng with updated fields .. lost one week in this.. <?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Libraries\ZohoConnector;
                                  • Monitor Ticket Transition Through Lifecycle Report

                                    Hello everyone, We have introduced lifecycle report under the pre-defined or static reports to provide better visibility of ticket transitions. For more information kindly refer to the help doc: Monitoring Ticket Transition with Lifecycle Reports Importance
                                  • Importing Tasks : Where is the flexible work hours field ?

                                    I need to be able to import a years worth of flexible hours for our part time workers, but I can't find what field to import to. When I do an export, there is nothing that signifies Standard/Flexible and whenever I import it automatically sets it to Standard...
                                  • Zoho Campaign initial Setup

                                    Clarification on Contact Consent for Email Campaigns in Zoho Campaigns I’m currently setting up an email marketing campaign for my organization using Zoho Campaigns, and while going through the process, I came across the requirement of having contact
                                  • Zoho Projects Roadshow, Australia & New Zealand - 2025

                                    Dear Users, We are happy to announce the Zoho Projects Roadshows 2025 in Melbourne & Auckland. Our team will discuss industry specific solutions as well as help network with other participants. If you are an existing user of Zoho CRM, Zoho Books, or Zoho
                                  • Filter lookup field using client script

                                    Hi, I used client scipt to filter a lookup field- the trigger is on detail page onload. It works, however sometimes when I start typing in that field the filter is removed and the whole list is shown. What can I do so that should not happen? Thanks
                                  • Múltiple Deals when converting a Lead

                                    Hello!!! I hope someone can help me figure out the best way to handle this scenario. I have a multi-select field named “Service” in the Leads module that captures either Service A, Service B, or both. When converting a lead, Zoho CRM currently creates
                                  • Zoho Sprints Integration with Zoho Desk

                                    Hi Team, I'm trying to integrate Zoho Desk with Zoho Sprints, but it's showing the message, "There are no teams available in Zoho Sprints. You don't have any teams! Click here to add." What should I do next to ensure a smooth integration?
                                  • CRM API Search Record for Last Name equals "."

                                    When using the CRM API to look for all contacts with a lastname = "." The API returns an Invalid Query Reponse I have tried (Last_Name:equals:.) (Last_Name:equals:%5C.) (Last_Name:equals:\.) We have a scenario where the Last Name may not be known for
                                  • Layout Rules Based on Task Owner

                                    We are managing our entire workflow on Zoho Projects From Deal to Shipment to Receiving Payment Now there is one thing that I would like to the ability is to Show or Hide different fields based on Task Owner For example for Shipment Tasks I would like
                                  • Important: Changes to Microsoft (Outlook) Bulk Email Sending

                                    Dear Marketers, We want to bring your attention to an important upcoming change announced by Microsoft (Outlook) that will impact users sending bulk emails to Outlook.com, Hotmail.com, and other Microsoft-hosted inboxes. This update focuses on strengthening
                                  • 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
                                  • Important: Changes to Microsoft (Outlook) Bulk Email Sending

                                    Dear Marketers, We want to bring your attention to an important upcoming change announced by Microsoft (Outlook) that will impact users sending bulk emails to Outlook.com, Hotmail.com, and other Microsoft-hosted inboxes. This update focuses on strengthening
                                  • Zoho Projects Work Hours into Analytics

                                    Since the most recent update, my Analytics reports that were comparing Zoho Projects Work Hours (estimate) against Timesheet Hours are gone.  They were actually deleted.  When I try to recreate them in Analytics there is no "Work Hours" field.  Where
                                  • 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
                                  • Quick Books to Zoho Analytics integration issue

                                    We have observed that few transactions are not flowing from Quick Books to Zoho Analytics when we integrate. There is no specific pattern observed. For Ex: In an accrual transaction a row is created for both Credit & Debit but for either of one row the
                                  • Zoho Not Receiving Emails Sent via PHP mail() – Arrives at Gmail/Outlook, but Not Zoho

                                    I have a PHP script on my website that sends emails using the basic mail() function — not SMTP or wp_mail() from WordPress. The email sends successfully to other addresses I own (like Gmail and Outlook), but emails sent to my Zoho-hosted address are never
                                  • Currency column showing $ symbol

                                    Hello, I'm importing data from Zoho Projects to Zoho Analytics and I was wondering why "Budget amount" column is set in dollars even if the "Currency" column = EUR: Is there a way to get the budget amount as "EUR" + nnnnnn? Thank you
                                  • Record Locking for Meetings CRM

                                    How can I lock meetings module in CRM? For other modules I can use Record Locking or Client Script, to lock some fields But for Meetings Client Script and Record Locking are both absent We have a problem, where employees are able to change meeting time
                                  • How to get the Logo

                                    Hii Can you please Help me the how to get the Company Setting Photo using the Deluge I will Write this Code But here Will Fetch the Photo_id but We needed the image curl1= "https://www.zohoapis.eu/crm/v7/org"; info curl1 ; getTemplate1 = invokeurl [ url
                                  • Zoho API integration - missing tables even after using MODULES.READ scope across all modules

                                    I tried to connect Zoho CRM to my Airbyte connector. I used clientid, client secret and the refresh token to do so. All I see is 77 tables available after connector. I miss few tables like lead agreement deal contact Can you please let me know, what scope
                                  • Product Updates in Zoho Workplace applications | March 2025

                                    Hello Workplace Community, Let’s take a look at the new features and enhancements that went live across all Workplace applications this March. Zoho Mail Include original attachments in reply email When you Reply or Reply All to an email, original attachments
                                  • Next Page