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

• Zoho learn Custom portal - networkurl & CustomPortalId

  I want to get my individual account’s networkurl and customportalId to use in this API: https://learn.zoho.com/learn/api/v1/portal/<networkurl>/customportal/<customportalId>/manual How can I retrieve the networkurl and customportalId using the API? I

• Connecting zoho creator to zoho writer to send prefilled documents

  i will paste the worflow below // Get user's submitted data from the form userSalary = input.Current_Salary; userCIBIL = input.CIBIL_Score; userEmail = input.Email; userName = input.Name; // You need to get the Document ID from the URL of your Zoho Writer

• Zoho Creator to Zoho Writer for prefilled documents...

  In response to the question about connecting Zoho Creator to Zoho Writer for prefilled documents, I wanted to share a working implementation that demonstrates how to use the record_id parameter with the Zoho Writer Merge API. This allows Writer to automatically

• WebDAV / FTP / SFTP protocols for syncing

  I believe the Zoho for Desktop app is built using a proprietary protocol. For the growing number of people using services such as odrive to sync multiple accounts from various providers (Google, Dropbox, Box, OneDrive, etc.) it would be really helpful

• Managing functions

  Can someone let me know if there are any plans to improve the features for managing functions in CRM? I have lots of functions and finding them is hard. The search only works on the function name and the filter only works on function type. I have created

• Introducing our latest privacy enhancement - Hiding email IDs in Zoho Cliq Networks

  Hello everyone, Zoho Cliq Networks offers a powerful collaboration platform that allows businesses to create dedicated digital workspaces for external vendors, partners, or individuals you want to communicate with professionally without adding them to

• zoho performance

  OVERALL CONFIGURATION OF ZOHO PERFORMANCE Quarterly performance review Self rating and scoring Manager rating and scoring

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

• When will it be possible to edit Subform records via either views or tabular reports?

  Hey there, data maintenance often requires mass update of quite a lot of records. While this is a piece of cake via either List view or Zoho sheet view, the same cannot be carried out for subform records yet. When one of the two options will be made available?

• Onboarding

  Hello Team, Im yuktha working as HR at Ossisto Technologies. We are currently utilizing zoho for onboarding candidate. right now facing issue with onboarding Attaching the screenshots for your reference

• Archiving Contacts

  How do I archive a list of contacts, or individual contacts?

• How do I change a form's name? Why isn't this more intuitive?

  Can someone please let me know how to change a form's name?

• Control Over Zia Generative AI Reply Assistance Behavior

  Hello, I would like to request an enhancement to the Zia Generative AI feature, specifically concerning the Reply Assistance within Zoho Desk. Current Issue: When replying to a ticket, the Ticket Properties section is automatically replaced by the Zia

• Zia now integrated with Open AI in Zoho Desk

  The powerful integration of Zia with OpenAI, has empowered Zoho Desk reach a new level of efficiency and performance. With contextual self-service capabilities, Zia enables agents to boost their productivity and delivers superior customer experiences.

• 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

• Employee self-service portal: Onboarding and continuous learning platform for support reps

  Hello everyone, In any organization, employees must go through multiple courses to learn about the product, their organization's standards, and how to respond to customer queries using the knowledge base articles available. This typically requires completing

• 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

• Contact custom field in layout

  Good day, all, I have an "Extension" custom field in contacts, and would like to display the contact extension in the ticket layout, but I don't seem to be able to. What am I missing? Thanks Rudy

• Exact match in name when searching workdrive

  Hello, I am wondering how to search workdrive files/folders with an exact match in the name. For example, when I search across folder with the url param search[name]=someName, I get multiple results such as "someName", "someNameAndMore", or "someName

• Meeting impossible to use when sharing screen

  he Meeting tool in Brazil is practically unusable when sharing anything, whether it’s a presentation or simple navigation. When accessed via Cliq, the situation gets even worse: even basic calls fail to work properly, constantly freezing. And as you are

• Changing the Default Search Criteria for Finding Duplicates

  Hey everyone, is it possible to adjust the default search criteria for finding and merging duplicate records? Right now, CRM uses some (in my opinion nonsensical) fields as search criteria for duplicate records which do nothing except dilute the results.

• Is there a way to create a desktop shortcut for a website course portal?

  Hello everyone, I recently got a laptop and bought an online course from a website, Skillwint.com, which I visit regularly. I open that site many times a day and want to create a desktop shortcut so I can open it directly instead of searching in the browser

• SalesIQ Tip for Admins: Your Safety Net for Data Recovery

  Ever clicked 'Delete' in your SalesIQ and then realized it was the wrong item? Maybe it was a prospect's chat that held important context you needed to refer to later on. Or, maybe you deleted an elaborate Zobot that you were still testing or planning

• Depreciated mergeAndStore Function Help!

  Hello, I have a function designed to create a PDF containing information from the fields in a Deals record. There is a Writer Mail Merge template in WorkDrive that is populated via Deluge code, and a copy of the resulting PDF is then attached to the record.

• Can I execute two 'functions' when completing a mail merge from CRM?

  Hi, I have set up a mail merge from CRM Deals to a template. I want a copy of this to be saved in Workdrive, and then a copy also saved back into the deal record from which the merge occurred. I can do both independent of each other, and managed to get

• External Share > Edit: Cannot Create Zoho Files

  Hi Zoho, When we create an external share link with Edit permission, our external users are unable to create a Zoho file (Zoho Writer, Zoho Sheet and Zoho Show). They can only upload files. They can edit the Zoho files if we create them internally and

• the custom domain forwards by default to the old career site / how to switch it off??

  dear friends, how to switch off the old version of the career site?? The set up custom domain forwards directly to the old site, so that I cant publish it... Any ideas? Thank you! KR, Victoria

• Zoho Mail iOS app update - RTL languages support and access emails using permalink and universal link, image upload resolution

  Hello everyone! In the most recent version of the Zoho Mail iOS app update, we have brought in support for RTL languages(Arabic and Urudu), providing a seamless reading experience with proper text alignment and layout throughout the app. We have also

• Why are emails sending with @viazohocrm.com ?

  I just sent out mass emails from CRM. They are sending from the email below and people cannot reply, and they are getting this message: Address not found Your message wasn't delivered to sales.XXXXXXXX.com.au@viazohocrm.com because the address couldn't

• Duplicating and referencing datasets

  I am moving from PowerBI to Zoho Analytics and while I find Zoho easier to use in many ways, there is one function that I use in PowerBI that I have not been able to find in Zoho.   I have several data sets that I need to modify in different ways to get

• Zoho Inventory Now Supports VeriFactu for Businesses in Spain

  Starting from January 1, 2026, Spain requires real-time invoice reporting for all B2B transactions. From July 2026, this requirement will extend to B2C transactions as well. All reporting must be carried out through the VeriFactu to AEAT (Agencia Estatal

• Why am I seeing deleted records in Zoho Analytics syncing with Zoho CRM?

  I have done a data sync between Zoho CRM and Zoho Analytics, and the recycle bin is empty. Why do I see deleted leads/deals/contacts in Zoho Analytics if it doesn't exist in Zoho CRM? How can I solve this problem? Thanks

• Enhancements to Zoho Map integration tasks

  Hello everyone, We're excited to announce enhancements to the Zoho Map integration tasks in Deluge, which will boost its performance. This post will walk you through the upcoming changes, explain why we're making them, and detail the steps you need to

• Let’s Talk Recruit: Meet Zia, your all-in-one AI assistant (Part-3)

  Welcome back to the Let’s Talk Recruit series. In the part 2 post, we explored how Zia has evolved with smarter summaries and seamless AI-assisted content creation. This time, we’re diving into the latest upgrades that take productivity even further —

• Announcing Early Access to "Zoho CRM for Everyone" — A new and exciting update to Zoho CRM

  Update : Zoho CRM For Everyone's Nextgen Interface gets an upgrade! Hello everyone, We’ve updated the Zoho CRM for Everyone Nextgen interface based on your feedback. The UI is now simpler with a unified sidebar, a more visible global search and features

• Unable to verify domain for Zoho People

  I have added TXT records in my DNS (GoDaddy) [screenshot attached], but unable to verify even after 12 hours after adding. On checking the console, it shows some errors [screenshot attached]. It appears that the verification flow is broken - please provide

• Zoho Invoice Now Supports VeriFactu for Businesses in Spain

  Starting from January 1, 2026, Spain requires real-time invoice reporting for all B2B transactions. From July 2026, this requirement will extend to B2C transactions as well. All reporting must be carried out through the VeriFactu to AEAT (Agencia Estatal

• Zoho Billing Now Supports VeriFactu for Businesses in Spain

  Starting from January 1, 2026, Spain requires real-time invoice reporting for all B2B transactions. From July 2026, this requirement will extend to B2C transactions as well. All reporting must be carried out through the VeriFactu to AEAT (Agencia Estatal

• Weekly Tips : Make your email content error free with Spell check in Zoho Mail

  As someone who writes multiple emails a day, we are bound to make both grammatical and spelling errors. Most of them we may not even notice, and even if we do, we may not have the time to correct each one individually when we are in a hurry. So how do

• Introducing Enhanced Storage Management

  We’re excited to roll out two new enhancements in Zoho Recruit, Subscription Information and Storage Management — designed to give admins complete visibility into subscription details, feature limits, and storage consumption — all from one place inside

• Next Page