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

    • Marketing Tip #9: Track your traffic sources

      Not all marketing channels work equally well. Knowing whether your visitors come from Google, Instagram, or email helps you focus on what actually drives sales. Try this today: Check your Zoho Commerce reports or connect Zoho PageSense to see your top

    • Google Analytics import data inaccurate (as of October 11, 2025)

      We have Zoho Analytics connected to GA4 to import daily event data. This has been running without issue for a couple of years. However, a month ago we started noticing discrepancies. All data until October 10 lines up perfectly - October 11 onward is

    • Zoho Recruit Slow and Freezing on all screens

      We have had an issue with Zoho Recruit for weeks being extremely slow and at times freezing.  We have 100 mega internet, and I went into each computer and updated the virtual memory so there is more available.  Also restarted all computers daily.  Still having the issues.  Almost unable to work.

    • Prevent accidental duplicate entry of Customer Ordersome

      Zoho Support has confirmed that Zoho currently does not have any method (using Deluge, flow or any other method) to alert a user when a sales order has been entered twice using the same customer reference number (i.e. a duplicate). Most ERP platforms

    • Zoho Books | Product updates | November 2025

      Hello users, We’ve rolled out new features and enhancements in Zoho Books. From translating email notification templates to the new transaction locking restrictions, explore the updates designed to enhance your bookkeeping experience. Making Tax Digital

    • Insert Image into Notebook page

      Prior to today, I could add images to my notebook pages. Today when I tried to do this I got an error message that said something like, "There's been a problem on our end. Try again later." So, I've tried all the ways I know how, but I can't insert an

    • 【開催報告】名古屋 ユーザー交流会 Vol.2 2025/11/21 Zoho Analytics / Inventory で実現する在庫の"未来予測"

      ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 11/21(金)に名古屋 ユーザー交流会 を開催しました。 本投稿では、当日実施したセッションの様子及び投影資料をお届けします。 会場にて参加できなかった皆さまも、ぜひご参照ください。 （Zoho 社員セッションの登壇資料については、11/28(金)開催の東京回の開催報告で共有いたします） 今年2回目の開催となる名古屋 ユーザー交流会では、株式会社エンツナクリエイト 野末さんによる Zoho Analytics / Inventory

    • Is there a way to automatically add Secondary Contacts (CCs) when creating a new ticket for specific customers?

      Some of our customers want multiple contacts to receive all notifications from our support team. Is there a way to automatically add secondary contacts to a ticket when our support team opens a new ticket and associates it with an account? This would

    • Improved RingCentral Integration

      We’d like to request an enhancement to the current RingCentral integration with Zoho. RingCentral now automatically generates call transcripts and AI-based call summaries (AI Notes) for each call, which are extremely helpful for support and sales teams.

    • Edit Pinned Comments in Zoho Desk

      It's great that private comments can now be pinned to the top of the ticket but what would be extremely helpful would be to allow for the pinned comment to be edited vs. having to find the comment in the ticket to edit it.

    • Updating Secondary Contact (CCs)

      We use Zoho Forms to capture the user request and integrated with Zoho Desk to raise tickets. Active Microsoft login is captured in our Zoho forms and registered as Primary contact in Zoho desk ticket. We also an have an option to raise ticket on behalf

    • blank page after login

      blank page after logging into my email account Thanks you

    • WriterTh

      After every space Writer goes to capital letters mode in my Android tablet. The cap mode stays till the second letter is typed in the word then it comes to normal mode.

    • Zoho writer unable to merge documents to PDF with basic fonts in Hebrew or fonts from my computer

      I created several forms that will be merged into PDF files through Zoho Writer and I am unable to receive the PDF in the basic fonts of the Hebrew language or in the fonts I have on my computer. The writer exports to PDF an exchange font that looks very

    • I have already created some Bots, Commands, and Widgets in Cliq, but I am still not seeing the “Create Extension” option in my account. Could you please help me enable or access this option?

    • Infinite loop of account verification

      Hi I can't do anything on my zoho account.  I always get this message Hi Sheriffo Ceesay As a security measure, you need to link your phone number with this account and verify it to proceed further. When ever I supply the details, it displays that the number is associated with another account. I don't have any other account on zoho so this is really annoying. 

    • How we cut CRM updates from ~20 minutes down to 2, our real workflow

      Updating the Zoho CRM after every call used to be one of the biggest time sucks for our team. By the time you write your notes, clean them up, fill in the fields, and log everything properly… you’ve easily lost 15–20 minutes per call. We started experimenting

    • Arattai App Features Update

      1. Offline Messaging & Sync Enable users to compose messages without internet and deliver them automatically via peer-to-peer methods (Bluetooth/WiFi Direct) when nearby users are available. This would be a game-changer for rural India with unreliable

    • How to add Product Add-Ons, Mandatory Forms, and Auto-Save Address in Zoho Commerce

      Hi all, I need help setting up several behaviors in Zoho Commerce. I can’t find the correct configuration options, so I want to confirm whether these are supported or if there is a workaround. 1. Product-Specific Add-Ons (Example: GWB Subscription) When

    • Zohomail

      Im trying to setup email address zoho

    • PROBLEMA

      Salve, non riesco a inviare email, e mi esce una tabela errore temporaneo. come posso risolvere il problema ?

    • Forever FREE Business Email with Zoho Mail

      Forever FREE Business Email with Zoho Mail: is it available?

    • Weekly Tips : Make collaboration effortless with Whiteboard in Zoho Mail

      Working with your team often means switching between emails, notes, and other applications just to explain an idea. Maybe you are trying to sketch a layout, plan a workflow, or quickly brainstorm ideas—with text alone, things can get confusing. So how

    • Formula field number of days between 2 dates

      Hi, I want to have a formula field which calculates the following: IF EndDate < TODAY and Oproep is true (this is a checkbox field) than EndDate - StartDate, otherwise TODAY - StartDate It should calculate the number of days How can I write this for

    • 'email address already exists'

      I deleted a user from my organization and want to use the same email address that user had, but the email address seems to still exist somewhere as I get 'email address already exists' when I try and create it. I have deleted the entire organization and

    • ZOHO reporting DKIM entries are not configured, when they have been configured and verified by 3rd parties

      Why is ZOHO reporting to my organisation users the following: "The DKIM entries in your domain's DNS records are not configured. Please contact your administrator for configuring DKIM to ensure optimal RSVP invite delivery." When I have configured the

    • Manage Bookings directly from Zoho Mail

      Greetings from the Zoho Bookings team! We’re introducing the new Zoho Bookings extension for Zoho Mail, designed to help you view appointments, copy time slots and share booking links without leaving your inbox. This integration brings scheduling right

    • My notes from the past 2 months have disappeared

      Hola, necesito ayuda urgente. Hoy, al iniciar sesión en mi Zoho Notebook como todos los días, me llevé una gran sorpresa al descubrir que todas mis notas de los últimos dos meses habían desaparecido. Estas notas son muy importantes para mí, ya que uso

    • How can I load a network into the cliq desktop app?

      I have both the standard cliq log in for my org and I am part of a cliq network. In the browser I can choose which I log in to. However, in teh desktop app if I log in it will alwasy load my org's cliq. Can I switch this to the network I have create

    • Ability to modify what displays in calendar invite?

      I am a long time calendly user and want to make the switch to bookings.  I understand that there is not currently a meets/hangouts integration, is one on the roadmap? Is there anyway I can modify the calendar invite to include the meet link?  I can add it to the emails no problem, but I would also like it to display on their calendar.  Is there some work around I can do to get it on the calendar?  Also am I able to modify the calendar event title?

    • Issue with Booking Confirmation Page Not Displaying, Leading to Customer Anxiety and Unnecessary Support Calls

      I am writing to express my growing concern regarding the confirmation process in Zoho Bookings, particularly the inconsistent display of the confirmation page after a successful payment. As a mobile service provider, I rely on Zoho Bookings platform for

    • Is it possible to turn off all capabilities for a customer to schedule, reschedule or cancel an appointment?

      Is it possible to turn off all capabilities for a customer to schedule, reschedule or cancel an appointment? I would like to set it up so only staff can schedule appointments. Is this possible?

    • Is there a way to generate a virtual meeting for a group service in Zoho Bookings?

      Are virtual meetings not supported for group services/meetings? I have integrated Zoom with one-on-one services, but I need a way to create an online group meeting. Thanks

    • Where we can change the icon in social preview

      Hi, we changed our logo, and the image that appear in preview (ex : when we post a appointment link somewhere) is still our old logo. I did change our logo in the org setting. https://bookings.zoho.com/app/#/home/dashboard/settings/basic-info?clview=false

    • Zoho Bookings changes Lead Source

      Hi. i would like to know if there's a way for Zoho Bookings to not change the lead source when booking a lead for an appointment as the lead source will be used in a report. Scenario: Lead source: Website after booking an appointment Lead source: Zoho Bookings Thanks. Dan

    • Need to set workflow or journey wait time (time delay) in minutes, not hours

      Minimum wait time for both Campaigns workflows and Marketing Automation journeys is one hour. I need one or the other to be set to several minutes (fraction of the hour). I tried to solve this by entering a fraction but the wait time data type is an integer

    • Suggestion: Associating Assets with Company in Zoho FSM

      Hello Team, I would like to share an idea based on practical experience. Currently, all assets in the Zoho FSM Asset module are linked to a specific contact person. I would like to know if it is possible to associate assets with a company instead. This

    • Zoho Inventory / Finance Suite - Extend Visibility of File Names on Attachment Fields

      Hi Inventory / Finance Suite team, I noticed recently that when you add an attachment field to a module in Inventory, only the first 8 characters of the file name are visible on the details view. 8 characters is not a useful amount and there is plenty

    • Many Notes Becoming Unusable

      Hello. The Notebook app is becoming unusable. I'm getting odd-looking results from my searches. Some of the notes, after clicking on them, show an update button that does absolutely nothing. Not sure what has happened, but it would be nice to get this

    • Kaizen #218: Actions APIs - Field Updates

      Hello all!! Welcome back to a fresh Kaizen week. In the previous weeks, we covered Workflow Rules APIs, Actions APIs - Email Notification APIs, and Tasks Update APIs. This week, we will continue with another Actions API - the Field Update API in Zoho

    • Next Page