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

• Widget shows error

  Hi， May I ask why below characters will be auto added into the widget link and how to solve this error? As my widget shows 404 error now. ?serviceOrigin=https%3A%2F%2Fcrm.zoho.com&frameorigin=https%3A%2F%2Fcrm.zoho.com

• How to print envelope labels from Zoho CRM

  Can anybody give me any clue how to print envelope/package labels directly from Contacts view? Regards, Alexandru Moderation Update: The Canvas Print View, which also facilitates the formatting of mailing labels, is now available! Learn more here: Zoho

• Data Import: New interface, improved field mapping, and more

  Hello everyone! We’ve redesigned the data import process to ensure accurate field alignment and verify that every column in the uploaded file maps correctly with Desk fields before import. Here's how: Streamlined Import Steps Importing data is now more

• Address labels

  Hi, we've been searching for a long time for a simple way for our employees to print address labels using a Dymo Label Writer 450. We came up with two alternatives that work, bur aren't really optimal.  First one is WebMerge. Webmerge is a great application that does 100% what we need but it is way too expensive for our needs. We only need to print a couple of labels per month. The second one is the integrated print tool in Zoho CRM, (Print preview) You would think this is the obvious way to do this

• This domain is not allowed to add. Please contact support-as@zohocorp.com for further details

  I am trying to setup the free version of Zoho Mail. When I tried to add my domain, theselfreunion.com I got the error message that is the subject of this Topic. I've read your other community forum topics, and this is NOT a free domain. So what is the

• Print Labels

  How can I configure my address to print my labels like this: Name Mailing Address Mailing City, Mailing State Mailing Zip Country Instead of: Name Mailing Address Mailing City Mailing State Mailing Zip Country Thanks!!!!

• Mailing labels - Improperly formatted

  All I'm trying to do is print one, properly formatted, mailing label. I'm in the Contacts module. In the default "list view" for mailing labels I selected a single client, hit the "more actions" drop down and selected print mailing label. Unfortunately,

• Printing mailing labels

  The ability to print mailing labels would seem to be an important, basic, function of a good CRM. I find it very surprising that this has still not been addressed adequately by Zoho. When trying to use the existing "mailing label" included: 1. the data

• Pageless mode needed to modernise Writer

  When we switched from GSuite to Zoho, one of the easiest apps I found to give up, was Docs. In many ways, Writer has always been more powerful than Docs, especially in terms of workflows/fillable forms/etc. However, I went back into Docs because I notice

• Zoho Projects - Visual improvement to parent and sub-task relationship

  Hi Projects Team, My feature request is to improve sub-task visibility. Please see screenshot below. I really think parent child relationships could be visually improved. Even if the first letter of the parent task was inline with other same level tasks

• AI Interview Insights: Turn Recorded Interviews into Quick Transcripts & Summaries

  Evaluating interviews shouldn’t require replaying long recordings or taking manual notes. With AI Interview Insights, you can now review complete transcripts and AI-generated summaries of your One-way (Recorded) interviews right inside Zoho Recruit. This

• API method to get activity feed in Recruit

  Hi community, I'm trying to figure out - is there any API method tto get information about datetime when Recruit/Candidates record tag where added?

• Printing Mailing labels

  Is there any way to adjust the size of the printing labels? or product would I use to print labels from Zoho? Thanks, Josef Krieger Moderation Update (14th April 2025): We have another post discussing the same topic with votes and feedback from users.

• Default to Current Date

  I'm importing data from a excel spread sheet that does not have date column and I'd like the date column in the Zoho Database to default to the current date. Any way I can do this?

• "Spreadsheet Mode" for Fast Bulk Edits

  One of the challenges with using Zoho Inventory is when bulk edits need to be done via the UI, and each value that needs to be changed is different. A very common use case here is price changes. Often, a price increase will need to be implemented, and

• Different Company Name for billing & shipping address

  We are using Zoho Books & Inventory for our Logistics and started to realize soon, that Zoho is not offering a dedicated field for a shipping address company name .. when we are creating carrier shipping labels, the Billing Address company name gets always

• What's New in Zoho Inventory | Q2 2025

  Hello Customers, The second quarter have been exciting months for Zoho Inventory! We’ve introduced impactful new features and enhancements to help you manage inventory operations with even greater precision and control. While we have many more exciting

• Make Packages from multiple sales order of a single customer

  Our customers sends orders to us very frequently, some times what customer wants is to ship items from 5 to 6 sales orders in a single shipment. it will be very nice if, zoho can implement this function, in which we can select items from other sales orders of the customer.

• Print a price list or price book

  Hi Community. Am I right in concluding that Zoho has no functionality to print a price list from either Zoho CRM, Zoho Inventory or Zoho Books? I won't get stuck on the fact that Zoho doesn't sync price books between Zoho CRM and Books/Inventory (more

• Start Workflow from Deluge Script

  I have developed a customized process from our CRM that leverages a deluge script to create a statement of work document. Once the document has been created via the merge and store function, I would like the ability to start a workdrive review & approve

• Show Custom Button in Portal Listview Canvas

  I have created a custom button that shows in a list view of deals (internally I can see it). I have permissions to allow this button on the portal. But it is not displaying in the canvas list? Before I do too much leg work, is this function allowed?

• Zoho Survey Enhancements

  We love Survey. We use it a ton. It needs some enhancements. Maybe some of these are already on the roadmap? API - this is crucial. We have some complex surveys that take place and need to update records, trigger other functions/automations, etc. I would

• Zoho Sites "pages" management page

  I have 80 plus pages on zoho sites. When I go to the "pages" link to view and edit pages, They are not in any kind of order, so I spend lots of time searching for pages when I need to edit or create new. How can I change the view order of all my pages

• AI feature in Zoho Desk suggesting answers based on past ticket threads

  Hi I would like to suggest something that would be very useful : instead of suggesting answers based on the Knowledge Base, I think it would be great if Zia could analyze the history of all customer and agents threads, to suggest answers in new tickets.

• Advanced Customization of the Help Center using JavaScript

  Hello everyone, The Help Center in Zoho Desk can be customized by using HTML and CSS to provide structure and enhance the page's appearance—but what if you want to add interactive and dynamic elements? You can add these effects with JavaScript, a programming

• Introducing Zoho POS for the Kingdom of Saudi Arabia

  Hey everyone, We are excited to kick-start December with a completely personalized edition of POS for retail businesses in Saudi Arabia to help run your operations with ease. It offers four different subscription plans—Free, Standard, Professional, and

• Unveiling Zoho Sites 2.0 - A new dimension in website building

  Dear Zoho Sites Users, We are thrilled to announce the launch of Zoho Sites 2.0 today! This refresh represents a significant step forward in the capabilities of Zoho Sites and is crucial for creating a lasting and positive impact on our customers' businesses.

• 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

• Script Editor not an option

  I am trying to apply a script to a sheet and Script Editor is not an option. I don't want to go outside Sheets to do this (like Creator) if it can be done inside Sheets.

• Zoho CRM - Writing Assistant Tone

  Hi Zoho CRM Team, Text in my emails often gets underlined in yellow because I tend to use a more informal tone with my client's, like using "I'm" instead of "I am". Is there some way for me to tell the system that this is my preferred writing tone, so

• Not able to link email text.

  Kindly check Zoho Sites. I am unable to turn a text into a email link. The save button does not work. Kindly try yourself to see it not responding to save.

• Adding Multiple Files to a Zoho Vault Entry

  There is a old blog post talking about adding multiple file attachments to one Zoho Vault Secret: https://www.zoho.com/blog/vault/introducing-new-features-in-zoho-vault-powerful-password-sharing-wider-storing.html Is that still possible, I can see how

• Migrate data from old to new account

  Hy, Have one Old Zoho Notebook Account with Data , want to migrate that whole Data to New Zoho Notebook Account which is in Zoho One . Is that possible ? If Yes then how?

• Zoho Analytics Regex Support

  When can we expect full regex support in Zoho Analytics SQL such as REGEXP_REPLACE? Sometimes I need to clean the data and using regex functions is the easiest way to achieve this.

• RTL Support for Webforms in Zoho CRM

  Dear Zoho CRM Support Team, We are writing to request an enhancement to the webform builder functionality within Zoho CRM. Currently, to create a webform in a right-to-left (RTL) language, the entire CRM instance must be set to RTL, which can be inconvenient

• Add Custom Reports To Dashboard or Home Tab

  Hi there, I think it would be great to be able to add our custom reports to the Home Tab or Dashboards. Thanks! Chad

• Pricing Strategies: #1 Nuances in Pricing

  When Clara first opened her digital printing shop, pricing was simple. She sold handmade greeting cards, planners, business cards, and other physical items at fixed label prices, individually and in bulk. One SKU, one price, one bill, and that's all it

• [Free Webinar] Learning Table Series – Education Management in Zoho Creator

  Hello Everyone! We’re excited to invite you to another edition of Learning Table Series, where we showcase how Zoho Creator empowers industries with innovative and automated solutions. About the Learning Table Series The Learning Table Series is a free,

• CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

  Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files

• Move attachments from one module to another with Deluge

  I have created a button that works just like the convert button for my custom modules. I would like this custom function to move any attachments in this record to the new module. I can't seem to find any documentation on how this can be accomplished.

• Next Page