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

    • What’s New in Zoho Analytics - March 2026

      Hello Users! In this month's update, we bring improvements across integrations, security, reporting, and analytics capabilities to help you work with your data more efficiently and with greater control. Explore what’s new and see how these enhancements

    • Zoho People > Performance Management > Appraisal cycle

      Hello All I am using this 2 users to test out how it work on Performance Management User 1 - Reportee User 2 - Reporting Manager : Li Ting Haley User 1 : Self Appraisal Error How do i fix this error?

    • SalesIQ Tip for Admins: Guide Operators in Real-time Without Interrupting the Chat

      Consider this. You're a supervisor and you're looking through the active conversations. An associate is mid-chat with a high-value prospect. The prospect asks something unexpected, maybe about a tailor-made subscription plan or a bulk discount that’s

    • Early Access: Check Printing in Zoho Books

      Hello Everyone,   Are you constantly writing checks to pay your vendors?   We've got a great news to share with you! You can now pay your vendors by writing and printing a check directly from Zoho Books. The feature is ready and we'll be rolling it out to our customers in phases.  It is available in the  US Edition of Zoho Books and also in the Global edition, where the country is selected as USA and the currency is USD.   Here’s a summary of what’s possible:   1. Write and print a check. 2. Make

    • Connecting Zoho Inventory to ShipStation

      we are looking for someone to help connect via API shipStation with Zoho inventory. Any ideas? Thanks. Uri

    • Syncing zoho books into zoho crm

      I was wondering how I can use zoho books in crm as I have been using them separately and would like to sync the two. Is this possible and if so, how? Thanks

    • Zoho no support response.

      Problem is Zoho support seems to be just a concept. Just completing my trial, am ready to purchae 3 user subscriptions pending answer to a question, submitted two suport request during my trial that weren't responded to. Gave up trying the 888 line. Hard to imagine my production data in hosting environment with no support response.

    • Updating transaction number series for fiscal year 2026-2027 in Zoho POS

      A fiscal year or financial year is a 12-month period that businesses follow to manage and track their financial activities such as expenses, revenue, and taxes. This doesn't need to match the calendar year (JAN-DEC) and varies based on region, and tax

    • Lack of Looping and Carry-Forward Functionality in Zoho Survey

      Zoho Survey currently does not support looping or carry-forward functionality, meaning it is not possible to dynamically generate follow-up questions based on each option selected in a previous question or to pipe selected responses (such as {Looping

    • Forecast in Zoho CRM Just Got Smarter with an upgraded Zia Intelligence

      Hello Everyone, We are here with an interesting enhancement to Forecasts in Zoho CRM — Enhanced Zia Insights for your sales Forecast. Imagine a regional sales manager reviewing their team’s performance using forecasts in Zoho CRM. Instead of switching

    • Update TDS and TCS rates for Income Tax Act, 2025 (effective April 1, 2026)

      Hello everyone, The Income-tax Rules, 2026 (G.S.R. 198(E), dated March 20, 2026) have been notified, marking a significant structural shift in India’s direct tax framework. From April 1, 2026, the Income Tax Act, 2025 replaces the Income Tax Act, 1961.

    • Service line items

      Hello Latha, Could you please let me know the maximum number of service line items that can be added to a single work order? Thanks, Chethiya.

    • Automation Series: Auto-assign Resources as Task Owners

      In Zoho Projects, task ownership can be set automatically during task creation, allowing resources to be assigned based on the task name. Resources are work equipment or tools added to the portal to monitor their usage across projects. They can be assigned

    • Subform edits don't appear in parent record timeline?

      Is it possible to have subform edits (like add row/delete row) appear in the Timeline for parent records? A user can edit a record, only edit the subform, and it doesn't appear in the timeline. Is there a workaround or way that we can show when a user

    • AI secretary

      In our company, Claude is the secretary and creates inquiries and schedules from Gmail. You no longer have to enter them yourself. The secret is that we created an MCP server that connects to CRM. https://x.com/Mac_nishio/status/1917954562566328694

    • 5 small changes to Recruit that make a big difference

      Sometimes, the biggest improvements aren’t new features, they’re small changes that make everyday actions feel smoother. Over the past few weeks, we’ve made a few such updates across Zoho Recruit. They’re subtle, but together, they remove friction from

    • Project Management Bulletin: March, 2026

      We are passionate about equipping our users with efficient solutions that help them run their businesses successfully. Our collective efforts over the past 2 years have culminated in the launch of Sprints 3.0— built with reliable features, impactful integrations,

    • New security enhancements for portal users: MFA and password management

      Hello everyone, We are excited to announce three major security enhancements that are now available to portal users in Zoho CRM: Organization-wide multi-authentication for portal users - Admins can enforce multi-factor authentication across the entire

    • [Free Webinar] Learning Table Series 2026 – Customer agreement & contract management using Zoho Creator

      Hello everyone, We’re excited to announce the next session in Learning Table Series 2026, where we will continue with our purpose-driven approach—focusing on how Zoho Creator’s features help solve real-world business challenges. Each session in this series

    • Zoho Payroll's USA and KSA editions are available in Zoho One!

      Greetings! We’re excited to share that Zoho Payroll, currently available only in India and the UAE, is now introducing the KSA (Kingdom of Saudi Arabia) edition and the USA (United States of America) edition, and these editions are now available in Zoho

    • Looking for Guidance on Building a Zoho Website

      I'm exploring the possibility of building a custom website with specific features using Zoho as an alternative platform. My goal is to create something similar to https://gtasandresapk.com , with the same kind of functionality and user experience. I'd

    • Multilingual website feature

      Would be a great feature to have. I saw that this feature was available for backstage. I think it could be done for zoho sites too.

    • [Webinar] Modernize your sales engine with agentic analytics

      Traditional sales decision-making methods aren't cut out for modern businesses. Leveraging AI in sales helps businesses actively respond to the changing dynamics of the market. Agentic AI is letting sales teams across industries make better decisions

    • Built-in Date Functions in Zoho Analytics Query Tables

      I have a doubt about whether Zoho Analytics Query Tables provide built-in functions for start date, end date, and the current month

    • Zoho Commerce in multiple languages

      When will you be able to offer Zoho Commerce in more languages? We sell in multiple markets and want to be able to offer a local version of our webshop. What does the roadmap look like?

    • Nimble enhancements to WhatsApp for Business integration in Zoho CRM: Enjoy context and clarity in business messaging

      Dear Customers, We hope you're well! WhatsApp for business is a renowned business messaging platform that takes your business closer to your customers; it gives your business the power of personalized outreach. Using the WhatsApp for Business integration

    • Connectivity issues with Google Calendar and third-party integrations

      Description: We are currently experiencing a critical failure with Zoho CRM third-party connections. This issue is heavily affecting our primary workflow. Symptoms: Sync Failure: Existing Zoho CRM to Google Calendar connections have been failing for approximately

    • Dynamic image in form works in the app but not on the customer portal.

      img = frm_Fichas[ID == input.Nombre].Foto; imgno = Nophoto[ID2 = 1].Image; if(len(img) > 1) { img = img.replaceAll("/sharedBy/appLinkName/",zoho.appuri); img = img.replaceAll("viewLinkName","Fichas_de_personal_public"); img = img.replaceAll("fieldName","Foto");

    • Incorrect Functioning of Time Logs API (Version 3)

      We need to fetch the list of time logs for each task for our company internal usage. We are trying to achieve it by using the next endpoint: https://projects.zoho.com/api-docs#bulk-time-logs#get-all-project-time-logs Firstly, in the documentation the

    • How can I export all Deluge code across the application?

      I’m working on a application with multiple forms, reports, and HTML views, where Deluge scripts are used across workflows, field actions, and custom functions. Is there a way to export all Deluge scripts into a single file for easier search?

    • First Name in Mail

      While sending a mail/message to the user, I want only the first name to be displayed—for example: “Hi John” instead of the full name using "Hi ${Name_Field}"

    • Can you import projects into Zoho Projects yet?

      I see some very old posts asking about importing project records into Zoho Projects. But I can't find anything up to date about the topic. Has this functionality been added? Importing tasks is helpful. But we do have a project where importing projects

    • Updating Sales orders on hold

      Surely updating irrelevant fields such as shipping date should be allowed when sales orders are awaiting back orders? Maybe the PO is going to be late arriving so we have to change the shipment date of the Sales order ! Not even allowed through the api - {"code":36014,"message":"Sales orders that have been shipped or on hold cannot be updated."}

    • 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.

    • Deleting unwanted ticket replies

      Hello, In a Zoho Desk Ticket thread, sometimes one of the recipients has auto-reply activated. This creates a new message in the Ticket thread that not only pollutes the thread, but most importantly cannot be replied properly because usually auto-reply e-mails don't do "reply all", so the other recipients are not included. I want to delete such a message in the Ticket thread. I searched the help of Zoho Desk, but only found a way to mark as Spam (https://help.zoho.com/portal/kb/articles/marking-support-tickets-as-spam)

    • Issue updating Multi-Select Picklist via API (saves as string instead of checking boxes)

      Hi everyone, I'm hoping someone can point out what I'm doing wrong here. I'm stuck trying to update a custom multi-select field via the Desk API and it's driving me a bit crazy. I have a multi-select picklist called "Buy years" with options like 2023,

    • Page variable not receiving URL parameter in Creator 6 HTML snippet Deluge — Canada DC

      I have a Creator 6 app on Canada DC. I'm trying to pass a URL parameter to an HTML snippet page via Deluge but the variable always returns empty. Setup: Page: MYC_Meeting_Tool Page variable declared: submission_id, type Text Page Script tab contains:

    • Zoho Campaigns API endpoint for contact details

      there is some REST API support for Zoho Campaigns, however, I am not able to find an endpoint for "get contact details".  in particular, I'd like to access contact's subscription status and also their topic. ideally there is all profile available including

    • Migrating Documentation from Notion to Zoho Help Centre

      Hi there, We have a large chunk of documentation that currently sits on Notion. However, we are eager to move this into our Zoho Help Centre/Knowledge Base. What is the most efficient way of achieving this?

    • Can't add attachment on email template

      The attachment does show up. This is my template. Hi ${Cases.Assigned Programmers}, Please be reminded about the following task that has been assigned to you. Subject : ${Cases.Subject} Description : ${Cases.Description} Ticket # : ${Cases.Request Id}

    • Next Page