Formula fields

Formula fields

Zoho People now supports formula fields. This post illustrates it.

Formula fields are fields whose value is calculated instead of being entered by the user. Using this, number, decimal and date manipulations can be done. The value of this field could be numeric or date depending on the output of the formula. In date manipulations, the result will be given in milliseconds, which you can format as per you need. The operators we support are +, - , *, /. Formula fields get recalculated automatically whenever the formula is changed. It also gets recalculated, when a field involved in the formula is changed.

To add formula fields

i)   Go to Customize form.

ii)  Double click or drag formula field from the tool box.

iii) The fields which can be used for calculation are listed at the right side of the formula field popup.

To construct the formula

To select a field or operator for formula construction

i)                     Click at the position in the Specify formula text area where you need to insert the operator or field.

ii)                   Then click on the corresponding operator.

To enclose part of formula within brackets, select that part and then click on the brackets.

To insert current date or timestamp click on the icons (shown in red in the below picture) present near the operators

Sample formula expressions

1.  Formula to calculate leave duration

   ( ToDate – FromDate ) / (1000 * 60 * 60 * 24)

2.  Formula for PF calculation

   ( BasicPay  *  12 ) / 100

For example, let us add a formula field named Net Pay in the Payslip form to calculate the net pay.



To edit the formula field

Use the edit option present at left side of the field in the customize form page. The following figure illustrates this.



Since the user need not enter the value for formula fields, they are not rendered while adding a record. However, formula fields are rendered with the calculated value when the records are viewed. Below picture illustrates this


Error messages

While configuring formulas you can receive error messages like

i)                    Field name 'fdfdfff' does not exist in the form - Arises when you try to specify a field for formula construction which is not there in the listing.

ii)                   Found an error in the formula. Cannot add two date expressions - When you try to add two date fields.



      • Sticky Posts

      • Zoho People 2.0 Help Manual

        Hello All, Zoho People Help Documentation is now available at this link. Please go through and get in touch with us at support@zohopeople.com in case of any questions. Regards, Hemalatha Chandrasekaran | Zoho People

      • Team Zoho People in your city!

        We are back with our next series of community events to meet you at your city! We are delighted to invite you to join us for a day of insightful sessions, interactions with other Zoho People users, and one-on-one sessions with our product experts. This

      • Come, join our HR Community!

        Hello everyone, We are delighted to invite you to join the HR Community, an exclusive forum for HR professionals around the world to collaborate, learn and grow together. In the HR community, you will be part of a tight-knit HR group, wherein you can,

      • Ask the experts: A 5-hour live Q and A session on Zoho People

        We are back with the 'Ask the experts' session of the month! Your platform to get instant answers to your questions on Zoho People is now open. Our team of experts is here, on a continuous 5-hour stretch, to answer and give expert solutions. What to ask? Your questions, doubts or any hiccup revolving Zoho People. If you do not have any questions, you can follow the post to add it to your knowledge.   Where to ask? Simply use the comments' space of this post to type in your questions.You can start

      • Ask the experts: A 5-hour live Q and A session on Zoho People

        The awaited 'Ask the experts' session of the month is here to give instant answers to your questions on Zoho People.  Our team of experts is here, on a continuous 5-hour stretch, to answer and give expert solutions.   What to ask? Your questions, doubts or any hiccup revolving Zoho People. If you do not have any questions, you can follow the post to add it to your knowledge.   Where to ask? Simply use the comments' space of this post to type in your questions. You can start posting your questions

        • Recent Topics

        • Need help getting my mail on iPhone and Tablet

          I need to access my Zoho mail via the iPhone Mail app. I have entered the login name, password and the incoming and outgoing servers, which my Mail Settings page says are imappro.zoho.com and smtppro.zoho.com. The iPhone keeps saying it cannot authenticate.

        • Add an background image to an email template in CRM

          Hi all, We wants to put an background image behind all our email templates. Is there a way to import this thru html. If i put the option background image in <body style="background-image:...</body> and i look to the preview it shows our background, but

        • How do I bulk archive my projects in ZOHO projects

          Hi, I want to archive 50 Projects in one go. Can you please help me out , How can I do this? Thanks kapil

        • Copy contents of File Upload Field into Workdrive

          Hello, I have set up our CRM so that a Workdrive folder is automatically created for each Deal via workflow, this adds the id of the folder into a dedicated field. We also have a field on each Deal called 'Approved Layout', which is a file upload field.

        • ZeptoMail API

          Hello Since today, we experience issues with the ZeptoMail API. When trying to send e-mails using: https://api.zeptomail.eu/v1.1/email we receive the error: (503) Site unavailable due to a traffic surge. Please try again shortly. I kindly ask you to identify

        • 553 Relaying disallowed. Invalid Domain - gzkcompany.ro

          Hi there, Can you please assist me in getting the right domain settings? I just renewed my domain subscription, after expired and i got error: 553 Relaying disallowed. Invalid Domain - gzkcompany.ro Zoho mail can receive emails, but its impossible to

        • Not able to receive emails for a while

          I am not able to receive emails for a while now.

        • Confirmation requested: eligibility and process to downgrade to Forever Free — tenant bigbanghawking.com

          Thank you for your reply. I am testing Zoho Mail from Brazil with the tenant bigbanghawking.com (endpoint: mail.zoho.com) and we are currently on the Premium trial that expires 21/01/2026. Before deciding whether to pay or cancel, I need written confirmation

        • Zoho API v2.0 - get ALL users from ALL projects

          Hello,        I've been trying to work on an automatization project lately and I find it difficult to work with this strict structure. To be more explicit, if i would like to get all users participating in a project i would need to get all projects first.       Same thing with projects. If i want to get all projects, I would need to get all portals first.        The problem with this aproach is that it consumes a lot of time and resources.             I want to ask if there is another way of getting

        • الموقع لا يقوم بالسداد

          السلام عليكم ورحمة الله وبركاته وبعد من أمس وانا احاول السداد للدومين YELLOWLIGHT ولا اتمكن من السداد اقوم بتعبئة جميع البيانات ولكن دون جدوى يطلع لى حدث خطأ ما

        • New in Office Integrator: Enhanced document navigation with captions and cross references

          Hi users, We're pleased to introduce captions, table of tables and figures, and cross-references in the document editor within Zoho Office Integrator. These features allow you to structure documents efficiently and simplify document navigation for your

        • Where Do I set 24h time format in Cliq?

          Where Do I set 24h time format? Thanks

        • 🎉 ¡Seguimos trayendo novedades a Español Zoho Community! 🎉 Confirmada la agenda y ubicación para los Workshops Certificados

          Si todavía no te has hecho con tu entrada para nuestros Workshops Certificados del próximo 26 y 27 de marzo o, por el contrario, estabas esperando que confirmáramos dónde los celebraremos, ¡este post es para ti! 📍¿Dónde nos vemos?📍 Nuestros Workshops

        • User is already present in another account error in assigning users to marketing automation

          Hello everyone Greeting, I had a problem in assigning user in marketing automation, when I try to add it I see this error: (User is already present in another account error) what should I do?

        • What's New in Zoho POS - January 2026

          Hello everyone, Welcome to Zoho POS’s monthly updates, where we share our latest feature updates, enhancements, events, and more. Let’s take a look at how January went. Sort and resolve conflicts Conflicts are issues that may arise when registers and

        • Not receiving email from customers and suppliers

          I am getting error . most of the customers tell me not able to send me email please check i have attached screenshot

        • Create user

          Hello I want to create user, but i get this error Unusual activity detected from this IP. Please try again after some time.

        • File emails in Shared email folder

          Hi, I am unable to allow users to collaborate in Shared email folders: User 1 shares a folder let's say "SharedTopic" with full permissions Users 2 and 3 can see this folder but are unable to add emails to this folder or search in this folder. For example,

        • Consolidated report for multi-organisation

          I'm hoping to see this feature to be available but couldn't locate in anywhere in the trial version. Is this supported? The main aim to go to ERP is to have visibility of the multi-organisation in once place. I'm hopeful for this.

        • How to Switch from Outlook for Mac to Outlook for Windows

          The most often used file formats for users to manage crucial data are OLM and PST files. PST files keep a copy of data on the configured system from Outlook, while the OLM file contains the Mac Outlook data items, which are only accessible with Outlook

        • Zoho Books Inter-company integration

          We have an Indian parent entity, and its accounting is managed in Zoho Books. We also have a subsidiary company in Dubai under the same parent entity, for which we have procured a separate Zoho Books license. I want to understand whether Zoho supports

        • Name autocomplete

          Hi, During searching emails the web tool does not always propose the auto-completion of the saved emails. As a result I either have to go to contacts and look up the exact email, or the exact full name including the middle name and any dots, which is

        • Are custom portals accessible on the Zoho learn smartphone app?

          In other words, can users external to my organisation, once signed up, use the app in the same way as internal users? Thanks

        • How to increase my Zoho sign limit.

          I cannot send a document/contract for signature. Zoho sign says I reached my monthly limit. May I know how to fix this please? Thanks! 

        • Can not add m365 outlook account to zohomail.

          I am attempting to use zoho mail as an imap client to add my outlook.com m365 account. In the m365 exchange admin center i have made sure the imap is enabled. In zoho mail i go to settings, mail accounts, add account, add imap account, i select "outlook",

        • Unable to attach Work Order / Service Appointment PDF to Email Notifications (Zoho FSM)

          I’m trying to include the Work Order PDF or Service Appointment PDF as an attachment in Email Notifications (automation/notification templates), but I don’t see any option to attach these generated PDFs. Is this currently supported in Zoho FSM? If not,

        • local file csv import problem

          The issue occurs when I upload a CSV file via Databridge. In the preview, everything looks correct — the values are in the proper columns. However, after clicking Import, the first column becomes empty, and the values from that column appear in a new

        • Función Deshacer y Rehacer

          Hola. Soy un reciente usuario de Zoho Notebook que he migrado desde Evernote. He encontrado en falta una función que considero muy importante: un botón para "deshacer". Es frustrante cuando se borra un parte del texto o un archivo de una nota, generalmente

        • Tip #59- Technician Console: Exploring View option- 'Insider Insights'

          Hello Zoho Assist Community! Ever wondered how technicians adapt quickly during a live support session? Imagine a customer reaching out with an issue that’s disrupting their work. The technician starts a remote session and begins troubleshooting right

        • MRP or Manufacturing Module for Zoho

          We have been searching for options for a production planning or MRP that will integrate with Zoho.   Zoho Creator is pushed as a platform that can have an MRP built from scratch but we would like to find more of an out of the box solution and modify it to fit our needs.  Are there any recommendations? Would Zoho consider creating a custom solution in Creator to support this need?

        • encountering an error when attempting to associate an email with a Deal using the Zoho CRM extension in Zoho Mail.

          When I click "Yes, associate," the system displays an "Oops!! Something went wrong" error message. I have attached a screenshot of the issue for reference.

        • Can 1 Zoho CRM instance sync with 2 Zoho Marketing Automation instances?

          Can 1 Zoho CRM instance sync with 2 Zoho Marketing Automation instances?

        • Can I add Conditional merge tags on my Templates?

          Hi I was wondering if I can use Conditional Mail Merge tags inside my Email templates/Quotes etc within the CRM? In spanish and in our business we use gender and academic degree salutations , ie: Dr., Dra., Sr., Srta., so the beginning of an email / letter

        • Zoho mail account ownership transfer

          We recently took over another company and have assumed responsibility for its Zoho account, including Zoho Mail and all related services. We would like to formally transfer ownership of this account to our organization. Could you please outline the complete

        • Email Authentication is Failing

          I'm trying to setup gitlab with email authentication. I used the following configs picked up from: https://docs.gitlab.com/omnibus/settings/smtp/ gitlab_rails['smtp_enable'] = true gitlab_rails['smtp_address'] = "smtp.zoho.com" gitlab_rails['smtp_port']

        • DMARC reports for mail I didn't send: how to deal with?

          I know the enthusiastic amateur's bare minimum about e-mail; am able to set up a Thunderbird account and know the basic acronyms. I have a Zoho Mail account connected to my domain, and have set up SPF, DMARC and DKIM successfully according to Zoho's instruction

        • ms

          Email set up for communication

        • Fix the speed

          It takes ages to load on every step even though my dataset is quite small.

        • Image field in custom module

          Hi guy, Is there any hope of adding a custom image field in the custom module? We created a custom module to keep track of assets, and it would be helpful if we could attach an image to the record. Thanks Rudy

        • Deluge Function to Update Custom Field

          I'm trying to get a Deluge function (which will run as part of a Schedule in Desk) that retrieves all tickets with the status "Recurring" and updates the custom field checkbox "cf_recurring" to "true". Here's what I have, which doesn't work: searchValue

        • Next Page