Enhancements to the formula field in Zoho CRM: Auto-refresh formulas with the "Now" function, stop formula executions based on criteria, and include formulas within formulas

Enhancements to the formula field in Zoho CRM: Auto-refresh formulas with the "Now" function, stop formula executions based on criteria, and include formulas within formulas

Dear Customers,

We hope you're well!

By their nature, modern businesses rely every day on computations, whether it's to calculate the price of a product, assess ROI, evaluate the lifetime value of a customer, or even determine the age of a record.
With Zoho CRM, you can include such calculations within records using the formula field. Today, we're introducing some new enhancements that aim to improve the accuracy and usability of formulas in your business processes.


Let's look at them!

Enhancement 1: Auto-refresh time-based formulas to view real-time values.

Businesses rely on time-based computations to conduct various analyses. Some computations measure time like a stopwatch. For example:
  • To ascertain the possibility a customer might churn, you would compute the age of their deals.
  • To validate an applicant's eligibility for an insurance policy, you would calculate the age of the applicant as of the current date.

The above examples are ongoing calculations that show the age of the record or of the customers. For these types of computations, you might expect that the formula is constantly ticking and rendering an accurate time measurement whenever you view the record. However, formula fields in fact compute and render the latest result only when the record is edited manually or updated via automation. By simply viewing a record, an agent may not be seeing accurate results. This enhancement addresses this.
Though formulas that provide the latest values include a "now" function in their syntax, computing all of these formulas continually and concurrently across all records poses a significant technical constraint. To address this constraint, we've introduced a checkbox to the formula field property labeled, Automatically refresh formula fields containing the Now function in real time.

If checked, the auto-refresh checkbox makes the relevant formula run every time the user visits or edits the record. This means users will always see the correct time measurements.

Info
Limitation:
  • You can apply the auto-refresh only for two fields with the Now function per module.
  • Formulas with date/ date time return types cannot be used in workflows that are based on date/time -based triggers.
  • Fields enabled with auto-refresh will have updated values every time you view them. But, this doesn't qualify for record edit. If you have automations based on edit of a record, this record will not be used unless the record is really "edited".
  • Also, creating custom views and filters using these fields cannot be done.

Enhancement 2: Stop formula executions based on criteria

In contrast to the case above—where you'd expect the formula to run constantly—there are scenarios wherein you may want to stop a computation from executing. Let's say a customer has churned, and you want to calculate the time it took them to churn. In that case, you might want the formula to stop computing under certain conditions.

Accordingly, you can use this new function to:
  • Calculate the number of days the deal was under negotiation
  • Calculate the number of days spent in trial before conversion
  • Calculate the number of days taken to ship a product
You may want to stop ongoing computations whenever there are events acting upon a given record. By doing so, you can determine the amount of time the record spent in a particular stage.

Previously, there hasn't been any functionality in Zoho CRM that effectively stops a formula from computing. Even when a cutoff date has passed, formulas continued to compute durations. With this enhancement, you can stop computations or freeze values based on specific criteria.

With these two enhancements, you can choose how you want your time-based formulas to be computed—to keep them running or to stop at a given time.

Info
Limitation:
A formula field that has auto-refresh and stop criteria enabled, then those fields cannot have multiline fields, picklists, and lookup fields as participating fields.

Enhancement 3: Include an existing formula as part of another formula's component

A formula is only as powerful as its components. Zoho CRM enables you to construct various complex formulas, but one missing piece has been the inability to include an existing formula field to construct a new one.

Thus far, you could do this by building a long and linear syntax.

For example, let's say you want to determine the discounted value and overall discount percentage for your finalized quotes. Firstly, to determine the discount value, you'd write a formula.

Next, to find the discount percentage, you'd write another formula that looks something like this:

As you can see, the structure of the formula involves an existing computation. In Zoho CRM, to achieve this, you'd first formulate the discount value, and then—to find the percentage—you have to repeat the discount formula to get the percentage.

For a simple formula like this, the syntax is fairly easy to understand. But imagine calculating commissions, which would involve several smaller formulas—in which case, you have to repeat the entire formula structure even if you already have them computed in your record layout.

This is complex, redundant, and time-consuming—problems that this latest enhancement addresses.

A formula field looks like any other field in Zoho CRM. Thus, in addition to the list of fields available under the fields part of the formula configuration, all the existing formula fields will also be listed. Admins can construct new formulas using the existing formulas without having to repeat syntax.

That's all for the updates. If you have any feedback or questions, please drop them in the comments section. Let's connect!

QuoteRelease plan: These enhancements are lined up for release DC by DC, gradually. We will keep you posted on the comments accordingly.

Thanks and have a good one!
Kind regards,
Saranya Balasubramanian



        • Recent Topics

        • Cash Basis VAT RETURN REPORT Required in Saudi Arabia

          Zoho Books in Saudi Arabia not showing TAX RETURNS report on CASH Basis.. It only showing accrual basis. Oforur requirement is both reports (Cash Basis and Accrual Basis ) , same like indian Edition of Zoho Books showing. CASH BASIS RETURN is our Basic

        • Tips & Tricks Series - #4 Customize your manual PDF before export

          Hello everyone! We’re back again with our Tips & Tricks series. Today, we’ll look at how you can customize your manual PDF before exporting it. With Zoho Learn, you can personalize the exported PDF with options such as headers, footers, colors, and custom

        • Digital Marketing Agency: Transforming Your Brand's Online Presence

          Imagine trying to build a house on your own without the necessary tools or expertise—it’s overwhelming, right? Digital marketing is the same.

        • Introducing Zoho Key Service, a simpler way to access LLMs without API keys

          Available in the Professional, Enterprise, and Ultimate editions in the US, IN, AU, JP, and CA DCs. Hello everyone, We are excited to bring Zoho Key Service (ZKS) in Zoho CRM, a simpler way for organizations to access and use third party LLMs. You can

        • Reach us through our official support channels

          Dear Customers, Thanks a lot for choosing Zoho! Our applications are built to help achieve your day-to-day business goals. We are committed to engaging with you, to understand and develop solutions that enhance your productivity. We are happy and ready

        • I cannot add user to my account

          I have an account, I deleted a user from the account and I have one unused licence which lasts for 23 days, I tried adding a new user and it said This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details, please

        • Domain Activation Issue

          I purchased a domain through Zoho, and as I understand it, you were supposed to send me a domain activation link. However, I never received it. As a result, I was unable to activate the domain, and it is now suspended. Because of this, I am not receiving

        • Grouping by Stage *type* in widgets

          Hi Can I ask for a new feature? I'd like to be able to group by stage type in a Deal widget. That is by whether the Deal is in an Open Stage, a Closed Won Stage, or a Lost stage. Currently I can group by Stage, but if we have 10 open stages and one Closed

        • Please release domain bravovietnam.com from an old account

          Hello Zoho Support, I am trying to set up Zoho Mail with my domain bravovietnam.com on my account office@bravovietnam.com. Every time I add the domain, I get: "This domain is already associated with this account" — pointing to a DIFFERENT, older account

        • ChatGPT Plugin / MCP Server auth error

          Hi all I'm trying to connect the ChatGPT plugin for Zoho CRM but after username stage of the auth process, I get this error from the URL https://mcp.zoho.eu/mcp-client/ {"error_description":"Invalid request url, Request is not as per defined in oauth

        • Creator -Dynamic addition of Customer Portal User Licenses

          Hi, We have a Creator App for B2C about to get released. We are experiencing the Portal User license challenge. Unable to predict the number of users who will download and Subscribe. When a User is about Subscribe and the portal licenses does not exists,

        • Need Multiple currency for Suppliers and Buyers

          Hello, We need multiple currency support for buyer and suppliers, We are doing international business and we often sell goods in foreign currency as well as local currency, However zoho does not support this, I am trying Free agent and xero they support all currencies for suppliers Bills & expenses as well as buyers invoices, Kindly work on this feature will be great help to decide using zoho books Thank you

        • 👍 Zoho CRM's Notes now gets Reactions and a new look

          Available in SA and JP DCs. Rolling out to other DCs in phases. Hello everyone, Notes help users capture important updates, collaborate with teammates, and maintain context for records. Now with Note Reactions, users can quickly acknowledge updates, express

        • Enhanced Zoho CRM and Office 365 calendar synchronization features!

          Dear customers, We're excited to share some significant improvements to our Office 365 calendar synchronization features, aimed at providing you with more control and a more personalized experience. What’s new Choose your Office 365 calendar: During the

        • Zoho Books Support

          Dear Team, Zoho Books offers a demo before you purchase zoho books. But after that when he actually purchases the product he has to rely on toll free number or help documents. But this might get frustrated in the initial period. Specially in initial period.

        • How to add a fee based on payment method

          I currently accept both ACH payments and credit card. I want to add a 3% fee to a number of my subscription plans if the customer chooses to use a credit card (and not ACH/checking). How do I do this? Is there an in-built feature, or would i have to create

        • What's New in Zoho Invoice | July – September 2026

          Hello everyone! We're back with the latest updates and enhancements we've rolled out in Zoho Invoice from July to September 2026. Here's what's new this quarter: Zoho Invoice is Now Available in Nigeria Introducing the Super Admin Privilege E-Invoicing

        • Notes - Reaction Buttons

          Using the native notes option within CRM is fine, it works and the RTF features are great, however, would it be possible - if there isnt already something in place, where we can add a reactions button, similar to teams/whatsapp to show that its been read

        • ZohoBooks - "Account transactions" report doesn't have any "Desciptions"

          Hi, I'd like to push for this to be included in ZohoBooks: In a "account transactions" report all the numbers are right, but I'd really like to see the "Description" as part of this report, i.e. the line-item-description as I would see it in the bank statement. Essentially all you see is a list of numbers adding up to the total. It is very difficult to see if things are right without being able to see what exactly each transaction refers to. Going into each transaction one-by-one is not a workable

        • Address limits per customer by edition

          I’m on the Standard edition and have reached a limit of 30 addresses under a single customer. Before I move to an annual Professional subscription, I need to confirm the following: What is the maximum number of addresses allowed under one contact, and

        • Export from List view

          I'm constantly having the issue where my users are building lists in ListView for various objects and then realising they cant export the data, then they have to go and build the data set in reports to export. I would like to see the ability to export to excel/csv from ListView.

        • Cannot apply tags to multiple items at once

          It is very frustrating needing to apply tags to notes individually. Even worse that it takes multiple clicks to do it. Can there please be an update to: 1.) Allow us to apply tags to batches of notes in one go. 2.) Make it less clicks to add a tag 3.)

        • Get all hiring updates via Zoho Cliq bot notifications

          We’re introducing a new way to stay updated on recruitment activities: Cliq Bot notifications. Now you can receive Zoho Recruit notifications directly in Zoho Cliq—alongside your existing in-app alerts and emails. Whether it’s a candidate status change,

        • Notes Acknowledgement

          It would be great to have emojis that can be used for Notes. Emojis such as Thumbs Up to let someone know you agree with them or a emoji for thanks. It's a simple way to acknowledge that you read someone's note. Moderation update: Emoji reactions for

        • Is it possible to log text messages from iphone into Zoho CRM

          My team is more and more utilizing text messaging to communicate with clients. Does Zoho have a solution for logging these text messages when clicking "Send Text Message" from the Zoho app. Much like when you call, you get prompted to log a call, can

        • Project Finances: Fully Accessible within Projects

          Project finances and work items are now on the same screen and it transforms the way you run your project. Managing your project finances is now much easier and in the same screen as your work items. Access quotes, invoices, bills, sales orders, and purchase

        • UI / UX Improvements

          Please consider changing the Dependency Details window from a column-based layout to a list-based layout, or allowing users to choose their preferred layout. The current column-based view uses screen space inefficiently and makes navigation difficult,

        • Zoho CRM and Desk sandboxes for testing native integration

          Hello team, We are evaluating the native integration between Zoho CRM and Zoho Desk, We have sandbox instances of both products and want to test the integration there, without any effect on our production CRM or production Desk data. While setting up

        • Function #24: Automatically display deal name from Zoho CRM on quotes in Zoho Books

          Deals allow businesses to organize and visualize their sales pipeline. This provides a clear overview of all potential opportunities and helps in making informed decisions. Zoho CRM empowers you to create deals or potentials for your clients and monitor

        • Auto-Sync Field of Lookup Values When Parent Record Changes

          Hi Zoho Team, Currently, when you use a "Field of Lookup" in Zoho CRM, the value is captured as a snapshot at the time the lookup is set. If the parent record is later updated, the Field of Lookup value on the child record does NOT update and stays stale.

        • [Request] Pivot filter date option : from set date to relative value ie from 01Jan to LastMonth

          I don't think I can currently do this... but it's worth asking if it's possible. My use case is concerning annual leave which is calculated from the beginning of the calendar year (01Jan) then each month I want to have details of leave taken etc... In

        • Customer Statement Showing Incorrect Negative Balance Due to Unused Advance

          Dear Zoho Support Team, We are facing an issue with the Customer Statement in Zoho Invoice related to customer advances/mobilization advances. The issue is that when a customer has made an advance payment that has not yet been fully utilized against invoices,

        • Mois de la sensibilisation à la cybersécurité 2026 : faites de la sécurité un réflexe avec Zoho

          Imaginez : vos systèmes informatiques répondent aux normes de sécurité en vigueur et votre entreprise est assurée contre les cyberattaques. Pourtant, un matin, tout bascule. Vos données sont chiffrées et un message glaçant s’affiche à l’écran : « Si vous

        • Specifying time increments on a Date/Time field

          Hi all, Im using a Date/Time field in my CRM module. At the moment the increments are 30 minutes. How can I change these to be 15 minutes? Thanks

        • What's new in Zoho Workplace | August 2026

          Hello Zoho Workplace community! Here's a roundup of all the new features and announcements that went live across Zoho Workplace applications in August. Zoho Mail Zoho Mail is now available in AWS Marketplace! AWS Marketplace users can access and subscribe

        • What's new in Zoho Social - Q3 recap

          Hello everyone, We've rolled out a bunch of exciting updates in Q3, and we're thrilled to walk you through them. Here's a quick look at everything we released in July, August, and September to help you experiment with content, automate engagement workflows,

        • Zoho Books | Product updates | October 2026

          Hello users, October brings a range of new features and enhancements to Zoho Books, designed to simplify compliance, streamline accounting workflows, and improve inventory management. From the launch of the Nigeria Edition and France’s e-invoicing capabilities

        • The Social Wall: September 2026

          Hello everyone! This month, we’re bringing Snapchat to Zoho Social. You can now connect your Snapchat account and manage your content alongside your other social channels. Whether you want to reach a wider audience through Spotlights or share quick updates

        • Turning off the recorded welcome in Zoho Webinar

          Is there a way to turn off the recorded voice that comes up at the beginning of every webinar session? It devalues the experience for attendees from feedback, interrupting their connection with our brand and delaying webinar start unnecessarily.

        • Option to Disable Knowledge Base Section in Feedback Widget Popup Hello Zoho Desk Team

          Hello Zoho Desk Team, How are you? We are actively using Zoho Desk and would like to make more use of the Feedback Widget. One of the ways we implement it is through the popup option. At the moment, the popup always displays the Knowledge Base section,

        • Next Page