Calculate service cost, ticket age, and other metrics using Formula Fields

Hello everyone,

Formula Field is currently available on Early Access. Kindly fill out this Registration Form to request early access.

We have made an important update to the fields and layouts in Zoho Desk that will allow users to compute values within the record using Formula Fields.

This feature is available for both Standard and Custom modules.

Support agents often need to calculate tax, interest, the total cost associated with a service, and other details, such as the time remaining before a ticket becomes overdue. Performing these calculations manually can be time-consuming and even cause errors.

 

Formula Fields automate these essential computations directly within the support system to ensure teams have quick access to accurate, real-time insights. This helps them prioritize tasks, allocate resources efficiently, and deliver fast resolutions.

What is a formula field?  

Formula fields are custom fields that allow you to perform calculations by combining functions, operators, and existing Zoho Desk fields. With formula fields, you can create custom equations to automate complex calculations. Formula fields can perform:

 

• Numeric calculations: Calculate service costs, refund amounts, and expenses.
• Date-based calculations: Calculate the time elapsed since ticket creation and determine upcoming service deadlines.
• Text/String outputs: Create a customized message by combining other fields' values.

 

For example, a formula field can instantly calculate the total cost of handling a service request or display customized text like "SLA deadline approaching." 

How do formula fields benefit support teams?   

Support managers and agents need quick access to accurate data to make decisions and prioritize tasks. Here’s how formula fields improve operations:

 

Minimize manual errors

 

Manually calculating the refund amounts or insurance policy renewal date can lead to inconsistencies. Formula fields automate these types of calculations to ensure accuracy.

 

Example: A formula calculates the total refund for a ticket by summing eligible costs, such as the product price, tax, and shipping and handling charges.

 

Save time and increase efficiency

 

Automating repetitive computations lets agents focus on resolving customer issues.

 

Example: A formula field calculates the Days Since Manufacturing by subtracting the Manufacturing Date from the Current Date (using the now() function). This eliminates the need for agents to manually calculate how many days have passed since the manufacturing of the raw material, which helps agents track material age efficiently.

 

Provide real-time insights for decision-making

 

Formula fields update dynamically as ticket data changes, offering managers and agents immediate insights so they can take prompt action.

 

Example: A formula combines the now() date function with the SLA Due Time to create a custom field like Days Overdue, which dynamically shows the number of days a ticket has remained unresolved since its SLA due date. This enables managers to quickly identify and address the most pressing overdue tickets.

Industry-specific use cases for formula fields  

Formula fields are highly customizable and can meet unique business requirements across industries. Below are some of the real-world use cases to illustrate their benefits:

 

Raw material cost calculation in the automobile industry

 

Goal: To calculate the total cost of raw materials by including base price, shipping, and taxes (GST).

 

Formula: (cf_raw_material_base_price + cf_shipping_charges) + ((cf_raw_material_base_price + cf_shipping_charges) * (cf_gst_percent / 100))

 

This formula computes the total cost of raw material by summing the base price, shipping cost, and applicable GST. The calculation helps procurement teams understand the total cost of materials to assist in better budgeting and financial planning.

 

 

Calculating the total cost of the purchased product using different cost components

Goal: To determine the total cost of a purchased electronic product, the calculation considers the unit price, number of units, shipping cost, and any applicable discount.

 

Formula: Total cost = (unit price * number of units) + shipping cost - discount

 

This computation helps customers and businesses accurately determine the final payable amount for an electronic product purchase. It ensures transparency by factoring in all cost components, including product price, quantity, shipping charges, and applicable discounts.

 

Warranty expiration date for the purchased product

 

Goal: To calculate the warranty expiration date for a purchased product.

 

Formula: Adddate(purchasedate, 'P1Y')

This formula helps in automatically determining the warranty expiration date, which is typically one year from the purchase date. By applying this calculation, businesses or users can easily track when the warranty period ends, which is useful for customer support, product returns, or any warranty-related inquiries.

 

Determining the reminder date for renewing the software license before it expires

Goal: Notify customers when their software license is about to expire.

Formula: Subdate(LicenseExpiryDate, 'P15D')

This formula helps to generate a reminder date that is 15 days before the license expiry, ensuring that customers are notified in advance. By using this calculation, businesses can send renewal reminders ahead of time, giving customers ample time to renew their licenses and avoid service interruptions.

For more information on the available operations and functions for creating formula fields, please refer to the help document.

Give it a try, and share your experiences, feedback, or suggestions in the comments below. We’d love to hear how Formula Fields helps your support teams.

Thanks, and have a great day!

Regards,

Varsha P

Zoho Desk - User education

• Topic Participants

• Varsha P

  

• Sticky Posts

• 2024 Email Authentication Standards: Elevating Security with Google and Yahoo

  In contemporary email communication, email authentication plays a pivotal role in mitigating email fraud, spam, and phishing attacks. Brace yourself for a new level of security. Starting February 2024, Gmail and Yahoo will be implementing robust email

• Using Agent Email Address as From Address

  Currently, while replying to a ticket, it is possible for agents to choose their own email addresses as 'from' addresses. Although we built this just for that little extra flexibility, in hindsight, it hasn't figured much in conventional usage.  Almost all businesses prefer that responses to their customers' tickets be sent from the common support/service email address and NOT from those of individual agents. During personal interactions at events, some of you have even made passing mentions about

• Edit and Delete options in Comments

  A lot of teams have been using ticket comments extensively to collaborate everyday. Notification Center further improved this experience by bringing real-time updates. As we continue to build more improvements to this experience, we've shipped a small-yet-important

• Webinar 2: Supercharged customer support for growing business

  Join us for this webinar and learn how to step up your support game using a real-time communication platform to generate happier, more successful customers. In this live webinar, we will will discuss the importance of SalesIQ for your support team and how it can help you:  Understand your customers better and their journeys to proactively support and engage them even before they ask for help.  Integrating real time conversations into Zoho Desk’s Support, providing a conversational customer service

• Customize Colors of your Customer Self Service Portal

  You asked for it. We heard you. We're happy to roll out the most sought after feature request, Customizing the Colors of your Customer Self-service Portal. Now you can set the color of your customer portal to mimic your company's web site, so that your customers visiting the portal will not feel alienated by the default theme.  Go ahead and configure the color of the header, tabs, fonts and background according to your needs. You can either choose between default color themes like Blue, Grey, Green

• Recent Topics

• Able to Send Emails from Zoho but Not Receiving Emails from Gmail

  Hello, I am experiencing an issue with my shopify domain email setup and would appreciate your help. Current situation: I can successfully send emails using Zoho. I can receive emails from some services (for example, Facebook). However, I cannot receive

• Antispam validation failed for your domain in Accounts

  I tried adding a domain to zeptomail.zoho.com, but the “add domain” operation failed. The front‑end error reads: “Domain could not be added. Please contact support@zeptomail.com.” The back‑end API returned: ``` { "error": { "code": "TM_3601", "details":

• Announcing new features in Trident for Windows (v.1.38.5.0)

  Hello Community! Trident for Windows just received a major update, with a range of capabilities that focuses on strengthening and enhancing communication. Let’s dive into what’s new! View complete technical email details. For those who need deeper visibility

• Windows Desktop App - request to add minimization/startup options

  Support Team, Can you submit the following request to your development team? Here is what would be optimal in my opinion from UX perspective: 1) In the "Application Menu", add a menu item to Exit the app, as well as an alt-key shortcut for these menus

• Accounting of Amazon

  I have recently started selling on Amazon.in and I am facing issues with different types of transactions: What entry to do in case of return? If I had sent two products and customer returned both the products but I had received only one and got the claim

• Compose Emails Faster Using Templates and Snippet

  Hello everyone, We have made an enhancement to the Send as Email option in Tickets. Agents can use templates and snippets to draft their response, which helps save time and maintain consistency. The Send as Email page will display the available templates

• Customize Colors used on graphs and charts according to users desire.

  It would be great if we could customize the graph's colors as we see fit. I hate that yellow is always the default color!

• Emails not integrating

  My emails from Hubspot did not integrtate over. How do I fix that?

• Creating meetings from an email

  Hi. Similar to Outlook, it would be helpful if a meeting can be scheduled from an email so that the attendees need not be manually entered every time it's created.

• Create custom rollup summary fields in Zoho CRM

  Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were

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

• CRM Percent custom fields: When will it show the % symbol and behave like %?

  1. Actually Percent custom fields fail to show the % symbol. 2. When in formulas Percent fields work like number: 100 x 5% = 5 ideal world 100 x 5% = 500 what happens actually 3. When importing Percent fields the % symbol has to be removed and the data

• 【Zoho CRM】商談タブへのデータインポート

  Zoho使用前にエクセルで管理していた商談情報を、Zoho一括管理のため、商談タブにインポートしたいのですが、お客さまの氏名だけが紐づけられませんでした。 「Zoho CRMにインポートする項目を関連付ける」のところが画像のようになっています。 （弊社では、「姓」を「★個人データ名」という項目名に変更し、フルネームを入れて使用しています。） どのようにしたら氏名をインポートできるかご存じの方がいらっしゃいましたら、ご教示いただきたく、よろしくお願いいたします。 （投稿先が間違っていましたらご指

• Deprecation of the Zoho OAuth connector

  Hello everyone, At Zoho, we continuously evaluate our integrations to ensure they meet the highest standards of security, reliability, and compliance. As part of these ongoing efforts, we've made the decision to deprecate the Zoho OAuth default connector

• RouteIQ for Zoho FSM

  Beste, Zou wel top zijn dat we een RouteIQ hebben voor FSM aangezien we constant moeten zien wat de beste route is voor onze monteurs. Nu moeten we een speciale aparte programma hebben om de beste route te berrekenen voor onze monteurs aangezien de planning

• Let us view and export the full price books data from CRM

  I quote out of CRM, some of my clients have specialised pricing for specific products - therefore we use Price Books to manage these special prices. I can only see the breakdown of the products listed in the price book and the specialised pricing for

• Changes to the send mail Deluge task in Zoho CRM

  Hello everyone, At Zoho, we continuously enhance our security measures to ensure a safer experience for all users. As part of our ongoing security enhancements, we're making an important update on using the send mail Deluge task in Zoho CRM. What's changing?

• How to Invoice Based on Timesheet Hours Logged on a Zoho FSM Work Order

  Hi everyone, We’re working on optimizing our invoicing process in Zoho FSM, and we’ve run into a bit of a roadblock. Here’s our goal: We want to invoice based on the actual number of hours logged by our technicians on a job, specifically using the timesheets

• Zoho Books | Product updates | January 2026

  Hello users, We’ve rolled out new features and enhancements in Zoho Books. From e-filing Form 1099 directly with the IRS to corporation tax support, explore the updates designed to enhance your bookkeeping experience. E-File Form 1099 Directly With the

• Inclusion is the new engagement

  When in a very challenging situation, you may have peers or friends around you saying, “Everything will be okay.” They speak to you in a way that they are connected or in a language or tone that feels close. But your inner voice comes to you in a truly

• DKIM verification for Squarespace website - Corrections to instructions

  Zoho Campaigns DKIM TXT record instructions for Squarespace show that Host field should show: 22111._domainkey.[domain name, e.g. mywebsite.com] However, after 72hrs, I had to reach out to Squarespace tech support, and they confirmed that the domain name

• Passing the image/file uploaded in form to openai api

  I'm trying to use the OpenAI's new vision feature where we can send image through Api. What I want is the user to upload an image in the form and send this image to OpenAI. But I can't access this image properly in deluge script. There are also some constraints

• My client requires me to have custom pdf file names to except payment for invoices, how can I customize this before emailing.

  Hello! I love the program so far but there are a few things that are standing in the way. I hope you guys can code them in so I can keep the program for years to come. My client requires I customize the pdf file names I send in for billing. Can you please

• Disable All

  I want to disable all the fields on the form when it loads.  I know there is a way to do this by listing all the fields as follows: disable Name; disable Address; disable City;  ... I have over 50 fields on my form and i am wondering if there is a single command or way to just disable all fields on load.   On load = disable All Thank you for any help.  

• Migrating my email from GMAIL to ZOHO MAIL..........

  I am a long time GMAIL user and I really only understand how they operate, but after reviewing your tutorials and forums online, it is quite unbelievable how much more and how much more streamlined ZOHO mail is, not to mention ZOHO's wonderful, more advanced capabilities. I do have several questions about transitioning over to ZOHO.  Primarily, where is the best place to start, what do I do first? And how hard is it actually to move all my business and personal accounts over here?  When I sign up

• iOS Zoho Mail App Crashesruni

  Whenever I trying to search emails via the Zoho Mail app on my iPhone the app crashes, I am running the latest version of the app and the latest iOS version. I have all set reset the app and deleted the app and still have the same issue. Thank you in

• Assessment Answered - Automation (Related List)

  Hello everyone, We have linked a candidate assessment to our job posting. When someone applies, they are required to answer all the assessment questions. However, some candidates submit their applications without completing the questions. In such cases,

• Rebrand your CRM with the all-new custom domain mapping setup

  UPDATES TO THIS FEATURE! 19th Jan, 2024 — Custom domain mapping has been made available for portal users in Zoho One and CRM Plus. 23rd June, 2023 — Custom domain mapping has been made available for all users, in all DCs. Hello everyone! We are elated

• Paid Support Plans with Automated Billing

  We (like many others, I'm sure) are designing or have paid support plans. Our design involves a given number of support hours in each plan. Here are my questions: 1) Are there any plans to add time-based plans in the Zoho Desk Support Plans feature? The

• How Does Knowledge Base Search and Article Recommendation Work?

  Hello, I would like to understand how the Knowledge Base search engine works. Specifically, does it search based on: The article title only? The full article content? Both, the article and the content? Keywords? Tags? Also, how does the system determine

• Can't change form's original name in URL

  Hi all, I have been duplicating + editing forms for jobs regarding the same department to maintain formatting + styling. The issue I've not run into is because I've duplicated it from an existing form, the URL doesn't seem to want to update with the new

• Calendar report with order options and more quick view templates

  I think many of us regularly work with calendar-style reports. It would be great to be able to customize the quick view with new templates and have options to sort the entries for each day of the calendar by different criteria. I think this is an interesting

• Shared Views

  Hello, is there a way to prevent an agent from changing a shared table view? I have no issues with agents being able to create and customize their own view, but when I create a view and share it to my team -- the expectation is that they are viewing it

• Using Zoho answer bot across departments (help center articles from another department)

  Hi Zoho Community, I’ve run into a major issue and hope someone here has experience with this setup. We currently have a Help Center in the department A where all of our knowledge base articles are maintained. However, we would like to use a Zoho Answer

• Zoho Desk Partners with Microsoft's M365 Copilot for seamless customer service experiences

  Hello Zoho Desk users, We are happy to announce that Zoho Desk has partnered with Microsoft's M365 to empower customer service teams with enhanced capabilities and seamless experiences for agents. Microsoft announced their partnership during their keynote

• how to avoid duplicate customer

  How can i avoid to create a duplicate customer. I charged a same customer with two different plans and it showed up twice in my customer list and subsequently in Zoho books contacts. It creates confusion to have a same customer appears multiple times in customer or contact list. How can i avoid it.

• The Social Wall: January 2026

  Hello everyone, We’re back with the first edition of The Social Wall of 2026. There’s a lot planned for the year ahead, and we’re starting with a few useful features and improvements released in January to help you get started. Create a GBP in Social

• API keys not showing in ZeptoMail dashboard

  Hi there, I'm hoping someone can provide some assistance as support isn't replying. I am trying to configure my transactional emails, but the dashboard doesn't show any of my API details - the `div` is there but it's emtpy. Every time I click "Generate

• Pipeline: Copying rulesets from one data source to another

  When creating and editing data pipelines, it would be really helpful to be able to copy the ruleset from one data source and 'paste' it to another. This would save time and reduce manual mistakes.

• Doubt about maximum email reach

  Good morning, greetings. This is Bramdon García from EDULABS S.A.S ESP, located in Colombia. I'm writing to inquire about the possibility of sending an email to 35,000 people simultaneously. Our company has a Zoho account, but we'd like to know if there's

• Next Page