Introducing Formula Fields for performing dynamic calculations

Introducing Formula Fields for performing dynamic calculations

Greetings,

With the Formula Field, you can generate numerical calculations using provided functions and available fields, enabling you to derive dynamic data. You can utilize mathematical formulas to populate results based on the provided inputs. This field is available as a custom field.

                                         

If your business is dealing with numbers and your decision-making is based on mathematical calculations, this feature will be beneficial to you.
You can create the field like how you create other fields. Navigate to Settings > Fields > Customize Fields > +Custom Field, provide a field name, and choose Formula as the type. 

Once you select the field type to be Formula, you will have to choose the Output Type. The return type specifies the type of result obtained from a calculation. Once you select and save a return type, you cannot change it afterward, so choose carefully.


Formula Expression

The formula field comprises three key components: 
  • Functions
  • Fields
  • Operators
When you access the Functions tab, you'll see a pop-up with a list of available functions on the left side. These functions can be added to the formula by clicking on them. Hovering over a function reveals details, such as its syntax, description, and examples, providing helpful context.


Within the formula editor, you can use shortcuts for quick access:
  • Use '@' to insert functions.
  • Use '#' to add fields.
  • Use '~' to add operators.

The formula editor validates the formula and identifies any issues related to incorrect functions or fields when you click the "Check Syntax" button. You can only save the formula once the expression has no errors.

Additionally, you can add a tooltip for the formula field to provide extra information. This tooltip appears next to the formula field in detail view.


Blank Value Computation 

When you create a formula field, you can specify how to handle blank values in the fields used in the formula.
You can find this option under Blank Value Preference, where you can choose one of the following:
  • Consider blank values as empty for strings: This option is selected by default when you create a new formula field.
  • Consider blank values as 0 for integers and decimals: This option interprets the blank value as 0 depending on the data type.
Example:

Profit is the formula field, calculated as: Revenue - Cost.
The fields used to generate the profit field are:
  • Revenue
  • Cost
If the Profit field is blank:
  1. If you select blank values as empty for the Profit field:
    • Revenue is seen as empty.
    • Therefore, the formula doesn't produce a result, leaving Profit blank or empty.
  2. If you select blank values as 0 for the Profit field:
    • Revenue is treated as 0.
    • The formula calculates Profit as based on this value.


Permissions

Both administrators and users with field-level permissions can access this feature.

Availability

  • This feature is exclusively available for Premier Edition users.
  • The limitation is set to 10 per module. 

Help documents 

That's all for this enhancement. We sincerely hope you find it useful. Please give it a try and leave your feedback in the comments section below. Watch this space for future announcements.

Thanks and have a good day!
 



    • Recent Topics

    • メモの保存場所、見直しませんか？― Zoho Notebookで始める情報管理

      ユーザーの皆様、こんにちは。ゾーホージャパンの朝香です。 AIを利用した業務が広がる中、AIによる情報漏洩対策を進めている組織も多いのではないでしょうか。 一方で、日常的に使っているメモの管理については、対策できていますか？ 業務中のメモには、重要な情報が含まれていることがあります。 そのため、AIへの入力だけでなく、メモの保存先についても是非確認をおすすめしたいと思います。 そこで今回は、使いやすさだけでなく、セキュリティにも配慮して設計されたZohoのノートアプリ「Zoho Notebook」をご紹介します！

    • Zoho Sheet offline is now live on iPhone

      Hello everyone, We've just rolled out offline support for Zoho Sheet on iOS—you can now create, edit, and analyze spreadsheets on your iPhone without an internet connection. Offline support has been a sustained priority for us. We're on the verge of bringing

    • You can now sync records from Custom Modules in Zoho CRM

      p.MsoNormal, li.MsoNormal, div.MsoNormal { margin: 0.0cm; font-size: 12.0pt; font-family: Cambria; } p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph { margin-top: 0.0cm; margin-right: 0.0cm; margin-bottom: 0.0cm; margin-left: 36.0pt; font-size: 12.0pt; font-family: Cambria; } p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst { margin-top: 0.0cm; margin-right: 0.0cm; margin-bottom: 0.0cm; margin-left: 36.0pt; font-size: 12.0pt; font-family: Cambria;

    • Zoho ERP | Product updates | July 2026

      Hello users, We're back with another round of updates to help you streamline your operations. This month's release brings new features and enhancements designed to help you work more efficiently. Read on to discover everything that's new in Zoho ERP this

    • Fixed cost per task

      Is there any way to assign a fixed cost per task, but track time for internal reporting? Don't see a way to do this currently.

    • Set custom date creation for ticket using API in Desk

      Hi. all.. I want know if is possible to add ticket with custom creation date via API... This would to be great because we are moving from another platform to Zoho and we have need to keep all statistics for old tickets also. In api docs i didnt see nothing about custom date in ticket creation but i would prefer a confirm from comunity/support. Thank you P.S.: Sorry for bad english language

    • Allow Shopify / marketplace orders to be cloned

      Many businesses now use Shopify as a B2B ordering portal, not just a D2C ecommerce website. For B2B businesses, once these orders are imported into Zoho Inventory, Zoho often becomes the main system used to manage purchasing, stock, fulfilment and customer

    • How to Display a Logo Image on a Public Form?

      I would like to display a logo image in the header of a form. To achieve this, I added an Add Notes field to the form. The code below works perfectly for Zoho users accessing the form. However, when the form is made public, the image does not load properly:

    • Possible to define default font and size in Zoho Campaigns?

      Is it possible to define a default font (font, size and colour) for the text, H1 and H2 in Zoho Campaigns? For example: In a campaign, I add a text block, and the text is automatically century gothic, size 11, grey (6f6f6e) by default? Thank you!

    • Set Custom Colurs/Fonts/Style

      I know I can save blocks as books marks but it would be nice to be able to define a custom colour pallet, the style of the H1, H2 etc to save me having to copy a previous block and set them manually over and over again. Since the colour picker doesn't

    • Zoho CRM - Kiosk Studio: Build Once, Execute Multiple Times with Loops

      Hello Everyone, Introducing Loop Functionality in Kiosk Studio. If you've ever built a Kiosk that needed to perform the same action multiple times like updating a list of contacts, scheduling calls for a batch of leads, or processing multiple products

    • Switching from Notebook to another product, too unreliable

      Not only is the spell check worse than useless, now there is a lag AFTER EVERY KEYSTROKE! This makes it impossible to use when there are innumerable products which provide this basic function. I made the mistake of relying on Notebook and have so many

    • Accidentally deleted a meeting recording -- can it be recovered?

      Hi, I accidentally deleted the recording for a meeting I had today. Is there a way I can recover it?

    • Zoho Desk: A Estruturação do Atendimento ao Cliente na era da IA

      O mercado de atendimento ao cliente vem passando por uma transformação que não é apenas tecnológica, é também comportamental. As empresas que antes mediam qualidade de suporte pelo tempo de resposta, hoje precisam medir pela experiência completa, unindo

    • API bookings/v1/json/appointment not adding additional fields he is returning this "customer_more_info": {"booking_form_type": "service"}

      Hi, I'm trying to add additional fields inside zoho booking appointment api and I'm passing same data as you told inside your documentation. He is returning following response "customer_more_info": { "booking_form_type": "service" } I'm using this parameter

    • Basic report- open sales order by item, with filter for customer ..

      HI, we really need a basic report that sorts all open sales orders by Item, so you can see which items in your inventory are awaiting invoicing. Then you need a filter by customer, so you can see all the items a particular customer is waiting for. daily,

    • Record sharing for Activities modules in CRM

      Hello everyone, We've got a few quick enhancements to what we covered in this previous announcement: record sharing is now available for Activities modules. 1. Sharing Tasks, Meetings, and Calls Until now, activity records could only be shared indirectly

    • Stock Count

      The stock count is a nice new feature, but we cannot figure out how to: 1. Use it without assigning to a person, we have a team or one of multiple do stock counts as do most any company. 2. Add any extra fields to what the "counter" sees. The most important

    • Action Required: Update your TLS configuration to ensure uninterrupted access to Zoho WorkDrive

      Hi everyone, To further strengthen the security of Zoho WorkDrive, we’re updating the TLS cipher suites supported across our services. As part of this change, older and less secure cipher suites are being phased out. If your browser, API client, desktop

    • Free webinar: Zoho Sign in Q2 2026 - A quick walkthrough

      Hi there, The second quarter of 2026 has flown by, and the Zoho Sign team has been hard at work releasing features to enhance how you send, sign, and manage documents. Join us for our upcoming webinar, where we'll discuss what's new and what's to come.

    • Kiosk Studio + Zia Agents: Automate renewal risk classification in your CRM | Kiosk Studio Session #10

      Renewal management is vital in a recurring revenue business. Your CRM already knows which accounts are at risk; the signals are present in contact titles, deal stages, call logs, account descriptions, and so on. What's missing is something that reads

    • How to Prefill Data in an Additional Form Submission from the First Form Submission

      We need to prefill data in the second form submission based on the previously submitted form (when using the "Add Another Response" option). We have a form which allows customers to send us files via upload. It requires them to provide name, company name,

    • Enable Credit Note creation for Sales Returns BEFORE receiving goods

      Currently, it is not possible to issue a Credit Note linked to a Sales Return until the goods have been officially marked as "received" in the system. In our business, we often need to issue a credit note to our clients immediately upon the initiation

    • Request to Make Billing Company and Service Company Fields Editable.

      Hello Latha, We noticed that once a Request, Estimate, or Work Order is created, we are unable to edit the Billing Company and Service Company details, as these fields become non-editable. Could you please make these fields editable after record creation?

    • Client Script | Update - Client Script Support For Custom Buttons

      Hello everyone! We are excited to announce one of the most requested features - Client Script support for Custom Buttons. This enhancement lets you run custom logic on button actions, giving you greater flexibility and control over your user interactions.

    • Why associate tickets are just one direction?

      When I associated the ticket #A with #B, in ticket #A I can see that exists another ticket associated. However, when I go to ticket #B, there is no reference that ticket #A is associated to #B. Is there a reason for that? Because it is confused and hard

    • Physical Batch Stock by Warehouse

      We have activated batch tracking in Zoho Inventory. To reconcile our inventory with the physical stock reported by our 3PL, we need a report showing the total physical quantity still present in each warehouse, broken down by batch. This quantity is the

    • No "Import Users" option in Zoho FSM

      I recently noticed that there is no option to import Users into Zoho FSM, and this has become a serious challenge for us. When migrating data, especially technicians or other user profiles, we often have hundreds of users to bring into the system. Currently,

    • Elevate your Radar experience: Best practices part 2

      In the Spotlight: Zoho Desk's Radar app Hello Everyone, In part 1 of Zoho Desk’s Radar app best practices, we explored role-based permissions, exceptions handling for critical alerts, daily toasts for a quick view of tickets, and landscape reports for

    • Suggestions for Improving the Deluge Development Experience

      Hello, I would like to share some ideas that could significantly improve the Deluge development experience, especially for partners and developers building larger solutions across the Zoho ecosystem. Some key areas that would add a lot of value: Deluge

    • "Subject" or "Narration"in Customer Statement

      Dear Sir, While creating invoice, we are giving in "Subject" the purpose of invoice. For Example - "GST for the month of Aug 23", IT return FY 22-23", "Consultancy", Internal Audit for May 23". But this subject is not coming in Customer Statement. Only

    • Email journaling is now available in Zoho Mail

      When issues escalate, IT, security, compliance and audit teams rarely need just “the latest email”. They need a dependable record of everything that was sent and received, in sequence, that isn’t affected by inbox clean ups or account changes. Email journaling

    • Ability to Export Field Dependency Structure in Zoho Desk

      Hi Zoho Team, We’d like to request a feature enhancement in Zoho Desk that would greatly improve configuration management for organizations like ours: Requested Feature: The ability to export the full structure of Field Dependencies, especially for multi-level

    • How to use Zoho Billing info in a workflow

      We have Zoho Billing and CRM sync'd and the Billing info appears as expected for each Account in Zoho CRM, including subscription status, plan type etc. But how can we use this in a workflow? Thanks Dylan

    • Account Reconciliation via API

      I am suggesting that the Zoho Books team considers making it possible to do an Account Reconciliation via API. The use case I have in mind is specific, but also fairly common: merchant services clearing accounts. Currently, the only way to reconcile an

    • First Day of Work Week selection - Add every day of the week

      It would be very helpful to have every day of the week available as a choice for the start of a work week.  In fact, it would be even MORE helpful if we could select a different work week per Customer. For instance, for one client, I invoice weekly: Friday through Thursday (so the first day of that work week, as far as Zoho is concerned, is Friday).  For another client, I invoice monthly, and would keep the traditional M-F work week.

    • Zoho CRM Error message #2 : Fixing [Invalid Credentials] and [Authentication Fail] while configuring IMAP

      Hi Everyone! As a part of our Zoho CRM Error messages series, we're going to focus on couple of error messages that you might encounter while configuring IMAP and ways to resolve them. These are: [Invalid Credentials] [Authentication Fail] The annoying

    • Unable to add a pick list field to a standard layout.

      Adding a picklist filed this morning to any module causes a grey/unresponsive screen. Inspecting the web console shows a javascript error.

    • Introducing Color Coding of Picklist Values

      Dear Everyone, Greetings!! Zoho CRM is uplifting the user experience. Recently, we had some notable aesthetic improvements in CRM like Kanban View UI enhancement, New List view UI enhancement, color coding of tags, and color coding of picklists in meetings.

    • Finish Line: Reading the Story Your Number Tells

      Three times on this journey, we pulled into a pit stop, a pause to catch our breath before pressing on. This time, this isn't a pit stop. This is the finish line. Over the last five posts, we saw that Zoho Invoice's reports aren't five separate features

    • Next Page