Viewing Formula Field in Android
Formula field is currently available only on Early Access. Kindly fill out this Registration Form to request early access.
Formula field is a custom field that automatically derives a value by computing the values in the different fields. The output is, for example, the sum, difference, mean, or average of two or more values. It eliminates the need for manual computations that can render inaccurate inputs.
The users can compute various types of values, including numeric, string, and date values, or more complex formulas involving multiple fields. For example:
- Calculate warranty period using purchase date
The tickets coming to a customer support team handling product service requests will compute the expiry of the warranty period based on the purchase date, which will be visible under the respective field.
- Total work experience using the employment date
When all the employee details are added under the Contacts module, the formula field can be used to calculate the total years of experience from the date of joining of each employee.See also More about the formula field.
The formula fields can only be created in the web application.
In the mobile app, users can only view the fields. Once a formula field is created, it will be reflected in the mobile app only after refreshing the portal metadata.
To refresh the portal metadata, open the Zoho Desk app > Hamburger Menu 
> Settings 
> Refresh Portal Metadata.
The computed data will be visible in the following pages in six different data types (Decimal, Boolean, Currency, String, Date, Datetime):
- Ticket properties
- Activities (Events and Tasks),
- Contacts
- Accounts
It will not be visible while creating or editing a ticket.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Creating Formula Fields
Managers and support agents often require quick access to key metrics, such as the time remaining before a ticket becomes overdue or the calculated costs associated with services. Manually extracting and calculating these metrics can be ...Working with Custom Fields
In Zoho Desk, custom fields help you capture and organize information that may not be covered by default system fields. Because custom fields are user-defined, they can be tailored to meet the specific needs of your business and industry. For ...FAQs: Formula Field
1. What is a formula field? A formula field is a custom field that automatically calculates values based on other field values. It helps automate data calculations based on a predefined expression using fields, constants, operators, and functions. It ...Related Tickets by Custom Fields for Zoho Desk
Being able to view tickets that have the same custom field value as the current ticket helps agents provide better, faster, and more personalized customer responses. For example, you might want to view tickets with a similar custom field value as ...Creating Custom Lookup Fields in Zoho Desk
The ability to establish connections between different sets of data is crucial in any business. For example, in the hospitality industry, departments like sales, marketing, and bookings can derive essential insights from customer data if it is linked ...
New to Zoho LandingPage?
Zoho LandingPage Resources