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

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

Hello everyone,


AlertFormula 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


      • Sticky Posts

      • 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

      • 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

        • Recent Topics

        • Zoho / Outlook Calendar sync

          The current Marketplace -> Microsoft -> Meetings integration needs 2 changes. 1. The current language for the Two-Way sync option should be changed. It currently states, "Sync both your Zoho CRM Calendar and Office 365 Calendar meetings with each other."

        • Customer members area

          Does FSM support a customer members area? If not what do you propose we use if we want the data used in FSM for customers to give them an area / login to see past orders, create new orders and general announcements.

        • Zoho Books-Accounting on the Go Series!

          Dear users, Continuing in the spirit of our 'Function Fridays' series, where we've been sharing custom function scripts to automate your back office operations, we're thrilled to introduce our latest initiative – the 'Zoho Books-Accounting on the Go Series'.

        • Desktop app doesn't support notecards created on Android

          Hi, Does anybody have same problem? Some of last notecards created on Android app (v. 6.6) doesn't show in desktop app (v. 3.5.5). I see these note cards but whith they appear with exclamation mark in yellow triangle (see screenshot) and when I try to

        • Notes created in mobile can no longer be accessed in desktop

          Working with a 2013 Mac running OS 10.14.6; Desktop Notebook version 4.5.3. Using Motorola Moto G Power 5G - 2024; Android app version 6.7 I have been using Notebook for some years. Starting several weeks ago, the notes newly created ion the phone can

        • Function #49: Manage varying installment payments using Zoho Books

          . Hello everyone, and welcome back to our series! Last week, we discussed automating the collection of fixed installment payments in Zoho Books. But what if your payment structure involves charging varying percentages of the invoice total as installments?

        • Zoho Writer - Option to Export as .zdoc format

          I've noticed that it's not possible to export a Zoho Writer Document in the .zdoc format. Isn't zdoc, Zoho Writer's own format? My use case is that I sometimes need to create quite complex documents with floating elements, which sometimes need to become

        • Is it possible for contacts to "Re-enter" a workflow in Zoho Campaign?

          We are currently working on a way to automatically add users to from one list to other lists based on specific criteria, but can't seem to find a native way of doing this so we are trying to use Workflows to do this. So, for example, if a user's status is set to "Active," then they should be added to the list "Active Users." If the same user's status is then set to "Paused," they should be added to the list "Paused Users" and removed from the list "Active Users." This works fine for the first go

        • Bulk upload images and specifications to products

          Hi, Many users have asked this over the years and I am also asking the same. Is there any way in which we can bulk upload product (variant) images and product specifications. The current way to upload/select image for every variant is too cumbersome.

        • Out of Office for Just One of My Alias Email

          Can I set up the Out of Office Reply for Just One of my Alias Email Addresses?

        • Can I map multiple Surveys into the CRM using the same fields?

          Hello, We are a healthcare practice that offers two distinct services (Nutrition and Primary Care). We use Zoho Survey for our lead generation form (Get Started Survey), which allows people to express interest in one of the two services and even allows

        • Dealing with API responses where integers have more than 16 digits

          Hi there How do I deal with an api response contaning an int or float with more than 16 digits (before any decimal places for a float). I constantly receive the response "Unable to cast the 'BigInteger' value into a 'BIGINT' value because the input is

        • Need Inactive accounts to be visible in Reports in Zoho Books

          I N=need Inactive accounts to be visible in Reports in Zoho Books to do recons of the accounts but when i see the same they are not visible in the Accountant - Account Transactions report

        • unblock e-mail

          please unblock my e-mails info@meatnews.gr and myrtokaterini@meatnews.gr

        • Add Zoho Mail for users who do not need Zoho One

          We have licenses for ZOho One for teams that need to use the suite of products that Zoho One offers.  We have 8 more people who only need email access and we would like to add just a Zoho Mail.  They do not need the Zoho One license.  We are currently

        • ZML vs HTML Snippet - which is better?

          Are there certain use cases where one is better than the other?

        • Auto CheckOut Based On Shift.

          This Deluge script runs on a scheduled basis to automatically set the 'Actual_Check_Out' time for employees who haven't manually checked out. If the current time is past their scheduled 'Shift_End_Time', the script updates the check-out time to match

        • How to remove some users in zoho accounts

          How to remove some users in Zoho accounts.

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

        • Load PO_Date field (Purchase Order) with current date in Deluge

          Hi, I'm not a full time developer, just helping to customize our CRM, in the small company I work for. There must be something wrong with me, because I can't do something so simple as complete a field with the current date in a function using Deluge.

        • Zoho CRM in Microsoft Power Automate Custom Connector

          Hi everyone, I’m building a Power Automate flow that integrates Microsoft Bookings with Zoho CRM. The goal is to automatically create a meeting (event) in Zoho CRM whenever a new appointment is booked via Microsoft Bookings. To achieve this, I created

        • Spell check sucks

          Come on guys, it's 2024 and your spell check is completely retarded. You gotta fix it.

        • How to include total km for multiple trips in expense report.

          Whenever I create a mileage report it only shows the total dollar amount to be reimbursed. The mileage for each individual trip is included but I also need to see the total distance for all trips in a report? How do I do this?

        • Outgoing blocked: Unusual activity detected.

          I just made payment for my Zohomail Today and have been debited so i will like to be Unblocked because this is what it says (Outgoing blocked: Unusual activity detected) Thank you i await your swift responses

        • Zoho One Login Issue - Unable to receive OTP

          Hi Support Team, I am experiencing a unique login issue with Zoho One. I am attempting to log in from India using Zoho Login credentials provided by a USA-based client. Their Zoho account is hosted on a US data center. After entering the username and

        • Question Regarding Managing Sale Items in Zoho Books

          Good day, I was wondering about something. Right now, Zoho Books doesn’t seem to have a way to flag certain items as being on sale. For example, if I want a list of specific items to be on sale from October 1 to October 12, the user would have to export

        • In the Zoho Creator Customer Payment form i Have customer field on select of the field Data want to fetch from the invoice from based on the customer name In the Customer Payment form i Have subf

          In the Zoho Creator Customer Payment form i Have customer field on select of the field Data want to fetch from the invoice from based on the customer name In the Customer Payment form i Have subform update Invoice , there i have date field,Invoice number

        • Problem of Import Client Users From CRM and or Expense

          I am premium plan user on Projects. I have about 500 customers on Expense and CRM that integrated with each other. According to at below link, I am trying to import clients from CRM, system not allowed to select any customer. If I import from Expense,

        • Unable to see free plan option

          Hello Zoho Support Team, I hope you are doing well. I am trying to sign up for Zoho Mail, but I am unable to see the option for the free plan. Could you please guide me on how I can access or activate the free plan? Thank you for your assistance.

        • unblock my zoho mail account. outlines@zoho.com

          please unblock my zoho mail account, outlines@zoho.com

        • domain not verified error

          Hi when i try to upload a video from zoho creator widget to zoho work drive iam getting domain not verified error.I don't know what to do .In zoho api console this is my home page url https://creatorapp.zoho.com/ and this is my redirect url:www.google.com.Iam

        • equest to Disassociate Bigin from Zoho One and Migrate to Standalone (Upgrade to Bigin Premier – 3 Seats, Annual)

          Dear Zoho One Support Team, I’m writing to request your assistance to disassociate (remove) the Bigin application from our Zoho One organization while preserving all existing Bigin data. After the disconnection is successfully completed, we intend to

        • SMTP email sending problem

          Hello, I've sent emails before, but you haven't responded. Please respond. My work is being disrupted. I can't send emails via SMTP. Initially, there were no problems, but now I'm constantly receiving 550 bounce errors. I can't use the service I paid

        • billing

          hi, I am being billed $12/year, and I can't remember why. My User ID is 691273115 Thanks for your help, --Kitty Pearl

        • How to add receipts

          How to add receipts

        • Unable to enable tax checkboxes

          Hi Zoho Commerce Support, I'm writing to report an issue I'm having with the tax settings in my Zoho Commerce store. I've created several tax rates under Settings > Taxes, but all of them appear with the checkbox disabled. When I try to enable a checkbox,

        • Zoho Commerce - Enable Company Name and Tax Number collection for B2B orders in Global Edition

          Please enable Company Name and Tax Details option on checkout settings in Zoho Commerce Global Edition. It is still important to collect Company Name and Tax Number for B2B sales in many countries. My business is based in Ireland (in the EU) and I have

        • ZohoSign and ZohoBooks Integration/Workflow

          Hello All, We utilize ZohoSign for signatures on tax eFiles. We utilize Dynamic KBA. Additionally, we use ZohoBooks for invoicing for these services. Is there a way to accomplish the following: Send a copy of the Tax Return, Invoice and eFiles in one

        • Manage monthly tasks with projectsf

          Hi All I run a finance and operations team where we need both teams to complete monthly tasks to ensure we hit our deadlines. Can Zoho projects be used for this. There many finance focused tools but we have Zoho one so want to explore Thanks Will

        • Zoho Suite is very slow

          Since today Zoho is incredibly slow over all applications! What's going on?

        • Next Page