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 

• Forumula Field: Overview 
  
• Use Cases 

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!

 

• Topic Participants

• Saishree T K

  

• Southern Crossings Southern Crossings Australia

• 20077308889@zohoclosedAccount.com

• Lokesh SR

  

• Geberth

• Sticky Posts

• Schedule mass emails, view mass emails status and more!

  Hello everyone, Mass emails help you communicate with multiple customers in a couple of clicks. We have introduced a Mass Emails dashboard in Bigin so that users can see the status of the mass emails like how many emails were opened, clicked and bounced.

• Introducing Bigin 360: Our new pricing edition with increased feature limits and pre-installed toppings

  Dear Biginners Club, Today, we're pleased to launch a brand-new pricing edition called Bigin 360, our highest pricing edition that will sit on top of Express and Premier editions. It's been over four years since our launch, and we're receiving some great

• [New] Create invoices and contracts in minutes with Zoho Writer's Merge Templates for Bigin!

  Do you often find yourself manually entering customer information in your business documents like invoices and contracts? This can be a time-consuming process that can take up valuable time from your business operations. With Zoho Writer's Merge Templates

• Announcing #BiginnersClub meetups in US, Middle East, India & UK (Free Event)

  Exciting news, Bigin enthusiasts! #BiginnersClub meetups are back, and we're hitting some major cities this time, starting from October. Here's what you can expect: Meet our experts face-to-face Deep dive into Bigin and its advanced features Personalised

• Introducing Forms: Streamline data collection with Bigin's new form builder.

  Hello everyone, Bigin's web forms just got a makeover! We are excited to introduce Forms: an online form builder designed to meet all your data collection need. This revamp was inspired by your feedback, resulting in an upgraded and versatile version

• Recent Topics

• Zoho CRM custom button function, how to add line breaks/ new lines in the return message

  When creating button function in CRM it requires a `return "";` Then when the button is client by the user a message pops up with what ever is returned from the function. But I want to have a message with multiple lines, meaning I need to add a line break

• Feature Request: Dynamic Date Filter Criteria

  Please implement the ability to select a dynamic date for all Filter Criteria. This would be helpful to create views that don't constantly need to be updated (example custom date field on an account) Examples: - Today - Tomorrow - This week - This Month

• SalesIQ's Summer '26 Release: For The Moments That Matter

  Every customer journey is made up of moments. The moment someone discovers your business. The moment they need help. The moment you decide to reach out. The moment a simple chat turns into something more. And the moments that continue long after the conversation

• There is no link between Deals and Projects in Analytics

  Hello there, I am trying to link Deals with Projects in a Pivot view on Zoho Analytics. However, there is no relationship, yet on CRM there is a relationship. As you can see below, there is no link between them: However, on CRM, if you go into a Deal,

• How to Access Zoho Mail Messages to Microsoft Outlook? - Zoho Mail Converter

  Zoho Mail is the free email hosting service which provide mailing with CRM service, so if you are one of them who is trying to import Zoho Mail emails to Outlook then keep reading. In this article we are going to provide accurate solution that will help you to import Zoho Mail emails to Outlook format in Batch. Zoho Mail service provide option to export mailbox in Zip format. So first – Export Zoho Mail emails in Zip format later use Zoho Mail to Outlook Converter to migrate Zoho emails into PST

• Zoho Cliq REST APIs v3 : A complete guide to what's changed and why 

  APIs are not just consumed by a developer with numerous automations and a series of open browser tabs. They are parsed by LLMs, fed into agent pipelines, and auto-completed by AI coding assistants that have zero tolerance for inconsistency. A verb tucked

• Feature Request: Include Creator-applicable Deluge updates in the Creator Release Notes

  I'd like to put forward a suggestion about how Deluge updates are surfaced to Zoho Creator developers, and I'm hoping the Creator team will consider it. Zoho Creator is built on Deluge. Every workflow, custom function, validation and schedule we write

• Zoho CRM Reports Module on Mobil App

  I have the mobile app and the reports module doesn't appear in the sidebar for some reason. I saw a Youtube video where the user had the Reports module on mobile. Is there a setting to show it on mobile? Thanks.

• Introducing parent-child ticketing in Zoho Desk [Early access]

  Hello Zoho Desk users! We have introduced the parent-child ticketing system to help customer service teams ensure efficient resolution of issues involving multiple, related tickets. You can now combine repetitive and interconnected tickets into parent-child

• Sigma function call hangs forever from Desk widget — app_install_id/encapiKey are null

  Calling ZOHODESK.request() from the widget to invoke a Sigma DRE function URL hangs forever (never resolves, never rejects, no error) until client timeout. Tried with merge fields app_install_id={{sigmaInstallId}}/{{installationId}} and encapiKey={{enCapApiKey}}

• Workdrive on Android - Gallery Photo Backups

  Hello, Is there any way of backing up the photos on my android phone directly to a specific folder on Workdrive? Assuming i have the workdrive app installed on the phone in question. Emma

• Auto sync Photo storage

  Hello I am new to Zoho Workdrive and was wondering if the is a way of automatically syncing photos on my Android phone to my workdrive as want to move away from Google? Thanks

• Postcode problems

  So we were very pleased to see we could limit shipping with postcodes. Brilliant. Unfortunately we have discovered It does not seem fit for purpose. In the UK we write postcodes in various ways Examples BH217NL BH21 7NL Bh217nl bh217NL and many more ways

• Getting Notifications but unable to load email

  I am getting notifications through the web browser and my phone app that i am receiving emails, but i can not open the email to view. Below is the screen shot of the console panel.

• WORKFLOW ISSUE: Zoho Finance Extension

  Workflows are no longer triggering in my extension. This is true for the testing environment and 5 other organizations it is installed on. There are no conditions set for the workflow, and this is true for both create and delete related actions. Workflows

• Zoho CRM Layout Rules: Nine New Actions, Profile-Based Execution, and Interactive Preview

  Hello everyone, Availability: This feature is now available for customers in the JP and SA DCs. It is planned to be released for other customers in soon. We’re excited to announce powerful new enhancements to Layout Rules in Zoho CRM - a feature built

• Certain items certain shipping

  Me again it would be helpful to have different shipping for different categories. Our example are salt. Delivery is free but have a minimum delivery. Pickup is cheaper so it has its own category- pickup.

• Zia Agents looks promising, but I still cannot deploy my first agent or connect WhatsApp after weeks of support tickets

  Hi Everyone, I am posting here because I am stuck and need practical help from someone who has successfully deployed a Zia Agent with WhatsApp. Zia Agents looks like a very promising product. I have watched the platform expand quickly, and I have noticed

• Cliq iOS can't see shared screen

  Hello, I had this morning a video call with a colleague. She is using Cliq Desktop MacOS and wanted to share her screen with me. I'm on iPad. I noticed, while she shared her screen, I could only see her video, but not the shared screen... Does Cliq iOS is able to display shared screen, or is it somewhere else to be found ? Regards

• Handling Hard Bounce Contacts with Active Phone-Based Users (WhatsApp Use Case)

  In Zoho Marketing Automation, when a contact is marked as “Hard Bounce”, we noticed that the contact stops receiving updates from CRM fields and may be excluded from automations. Is this expected behavior? In our case, the primary identifier and verified

• Integration with existing websites

  So most companies have existing websites. They want to integrate an online store with their existing site. How is that possible in zoho commerce please.

• Subject: Message bar - reducing height and adding scrolling/rotating messages

  Hello Zoho Commerce Support, I am building my store (Moksha Collections) and have the Message Bar enabled and positioned at the top. I have two questions: 1. Height: Is there a native setting to reduce the height (thickness) of the message bar? It currently

• Moving over to commerce but shipping

  In our company we love zoho onebut currently use ECWID for our online shop which is annoying as it requires double entering invoices. our requirements are that we do local deliveries limited by postcode -these are free. we also allow pickup they get a

• Website not properly connecting with Zoho Creator app portal (embed & data sync issue)

  Hello Zoho Community, I’m currently facing an issue while trying to connect my external website with a Zoho Creator app portal. I have a tool-based website ( https://mygardencalculator.com/ ) where users interact with calculators and dynamic content.

• Show current inventory in the item list table for a composite item

  Hello. We have many products that are composite items. Quickly determining inventory levels of individual items that make up a composite item would be beneficial. IDEA: Add columns"current inventory" and "available inventory" to the item table of the

• Increase the "Maximum Saved Entries per User" Options Limit

  Hi, You can create lots of saved entries, yet the Limit when you apply one is 25, we may often expect 32 to be in draft, and therefore want to enforce that, can we increase the limit of this field from 25 to 100 (As you can just turn it off and have more

• When Zoho Tables Beta will be open to EU data center

  Hello all, We in EU are looking at you all using and testing and are getting jealous :) When we will be able to get into the beta also? We don't mind testing and playing with beta software. Thank you!

• Deluge Editor Code Reformatting and Dark Mode Support in Zoho Creator

  Hello Zoho Creator Support Team, I’m enjoying Zoho Creator but facing an issue with the Deluge editor—it's automatically reformatting my code (removing spaces, changing brace placement). Is there a way to turn this off? Also, is there any option to enable

• Workflow Preventing others from editing

  Using workflows in WorkDrive to implement a document review process has been extremely helpful in my organization. The only problem is that other users who have access to the document via standard document sharing rules are unable to edit the document.

• Add @Mention Notifications in Zoho Cliq for Zoho Project Mentions

  Hello Zoho Projects Team, We hope you are doing well. We would like to submit a feature request regarding "Projects Bot" Cliq bot notifications for @mentions inside Zoho Projects comments (Tasks and Issues). Current Behavior: At the moment, when someone

• Canvases Auto-Skewing/Adding Scroll Bars When They Were Not There Prior

  Is anyone else noticing rendering issues in their canvases today? It seems to be mainly icons which now have scroll bars added which makes them all look off, though some fields seemed to revert to squished length as well. Were the icons replaced with

• How to see exact clicked links in CRM from Zoho Campaigns ?

  Hi, I'm wondering how I can see the clicked links from an email sent from Campaigns when I'm in a campaign in the CRM module. I can see the number of clicks but I need the sales team to be able to see which link has been clicked by a prospect or contact.

• Allow native Webhooks to authenticate via Connections

  Allow native Webhooks to authenticate via Connections (Basic Auth) instead of plaintext custom headers Summary Please allow native Webhooks (Workflow Rules > Instant Actions > Webhooks) to authenticate against the destination endpoint using the existing

• Improve your booking page visibility with SEO settings

  We're excited to introduce SEO settings, helping you optimize how your booking pages appear in search engines and reach more customers organically. SEO settings are available for all booking page types: Business, Workspace, Event Type, and User. With

• Related List Expanded View in Zoho CRM: see more related records at a glance, filter and take bulk actions

  Hello everyone! Related lists show you the records connected to what you're working on: contacts under an account, activities tied to a deal, products linked to a quote. But until now, you could only see 10 records at a time. If you needed to filter results

• Kaizen #250: Introducing write-enabled Queries: Auto-populating lookup fields during Kiosk-driven Blueprint transitions

  Hello Everyone, Welcome back to an exceptional edition of the Kaizen series! Today marks Kaizen #250, an exciting milestone in our journey of exploring, learning, and building with Zoho CRM. Over the past 249 editions, we've covered a wide range of features,

• Does anyone else wish you could download Mail Merge quotations from the Zoho CRM mobile app?

  Is it just me, or has anyone else run into this? I’m in sales, so I’m rarely at my desk. I’m usually in meetings, visiting clients, or travelling. One thing that genuinely frustrates me is that if a client asks me for a quotation, I can’t generate or

• How to automatically update a % field according to a dropdown field in the Quote table

  Hello there, I have following couples: Success % Status 0% NP 30% No Feedback 50% PR 80% Opp. Concreta 100% A I would like the Success % field (percent) to automatically update based on the item of the Status field (dropdown). The fields are within the

• Support for tags on mobile apps?

  Hi, please could you suggest when support for tags on the mobile apps is coming?

• Zoho Social API for generating draft posts from a third-party app ?

  Hello everyone, I hope you are all well. I have a question regarding Zoho Social. I am developing an application that generates social media posts, and I would like to be able to incorporate a feature that allows saving these posts as drafts in Zoho Social.

• Next Page