{"id":4042,"date":"2026-05-29T19:46:34","date_gmt":"2026-05-29T19:46:34","guid":{"rendered":"https:\/\/aaxonix.com\/resources\/?post_type=glossary&#038;p=4042"},"modified":"2026-05-29T19:46:34","modified_gmt":"2026-05-29T19:46:34","slug":"formula-field","status":"publish","type":"glossary","link":"https:\/\/aaxonix.com\/resources\/glossary\/formula-field\/","title":{"rendered":"Formula Field"},"content":{"rendered":"<style>\n.gt-body { font-family:'Poppins',sans-serif; color:#111; line-height:1.75; }\n.gt-def { border-left:4px solid #E8650A; padding:16px 20px; background:#fff8f4; border-radius:0 8px 8px 0; margin:0 0 32px; font-size:1.05rem; }\n.gt-section { margin:0 0 36px; }\n.gt-section h2 { font-family:'Fraunces',serif; color:#0A1628; font-size:1.5rem; margin:0 0 12px; }\n.gt-section p { margin:0 0 12px; }\n.gt-example-box { background:#f0f4ff; border-radius:10px; padding:20px 24px; margin:0 0 32px; }\n.gt-example-box strong { color:#2563EB; }\n.gt-related-pills { display:flex; flex-wrap:wrap; gap:10px; margin:0 0 32px; }\n.gt-related-pill { background:#f7f4ef; border:1px solid #ddd8cf; border-radius:20px; padding:6px 16px; font-size:0.875rem; color:#0A1628; text-decoration:none; transition:all .2s; }\n.gt-related-pill:hover { background:#0A1628; color:#fff; border-color:#0A1628; }\n.gt-faq-item { border:1px solid #ddd8cf; border-radius:10px; padding:16px 20px; margin:0 0 12px; }\n.gt-faq-item h3 { font-size:1rem; color:#0A1628; margin:0 0 8px; }\n.gt-faq-item p { margin:0; font-size:0.9rem; color:#444; }\n<\/style>\n<div class=\"gt-body\">\n<div class=\"gt-def\">A Formula Field in Zoho CRM is a custom field whose value is automatically calculated from an expression using other fields on the same record. Unlike regular fields that store user-entered data, formula fields compute and display their value dynamically based on the formula defined by the administrator.<\/div>\n<div class=\"gt-section\">\n<h2>What Formula Fields Can Do<\/h2>\n<p>Formula fields support arithmetic operations (add, subtract, multiply, divide), string functions (concatenation, uppercase, substring), date functions (date difference, add days), and conditional logic (IF, AND, OR). For example, a &#8220;Days Since Last Activity&#8221; formula field could calculate the number of days between today and the last activity date, giving managers an instant view of which deals are going cold.<\/p>\n<\/div>\n<div class=\"gt-section\">\n<h2>Formula Field Limitations<\/h2>\n<p>Formula fields are read-only &#8211; they cannot be edited directly. They recalculate whenever the record is opened or saved. Formula fields cannot reference fields on related records (use a <a href=\"https:\/\/aaxonix.com\/resources\/glossary\/rollup-summary-field\/\" class=\"sp-content-link\">Rollup Summary Field<\/a> for that). They also cannot be used as the primary field in a <a href=\"https:\/\/aaxonix.com\/resources\/glossary\/lookup-field\/\" class=\"sp-content-link\">Lookup Field<\/a>.<\/p>\n<\/div>\n<div class=\"gt-section\">\n<h2>Industry Example<\/h2>\n<div class=\"gt-example-box\"><strong>Real Estate:<\/strong> A real estate CRM uses a Formula Field on Deals called &#8220;Days on Market&#8221; that calculates the difference between today and the &#8220;Listing Date&#8221; field. This value appears on every deal card in the pipeline view, making it instantly visible which properties have been listed the longest without a sale &#8211; without any manual calculation or data entry.<\/div>\n<\/div>\n<div class=\"gt-section\">\n<h2>Related Terms<\/h2>\n<div class=\"gt-related-pills\"><a href=\"https:\/\/aaxonix.com\/resources\/glossary\/custom-field\/\" class=\"sp-content-link gt-related-pill\">Custom Field<\/a><br \/>\n<a href=\"https:\/\/aaxonix.com\/resources\/glossary\/rollup-summary-field\/\" class=\"sp-content-link gt-related-pill\">Rollup Summary Field<\/a><br \/>\n<a href=\"https:\/\/aaxonix.com\/resources\/glossary\/subform\/\" class=\"sp-content-link gt-related-pill\">Subform<\/a><br \/>\n<a href=\"https:\/\/aaxonix.com\/resources\/glossary\/page-layout\/\" class=\"sp-content-link gt-related-pill\">Page Layout<\/a><br \/>\n<a href=\"https:\/\/aaxonix.com\/resources\/glossary\/deluge-scripting\/\" class=\"sp-content-link gt-related-pill\">Deluge Scripting<\/a>\n<\/div>\n<\/div>\n<div class=\"gt-section\">\n<h2>Frequently Asked Questions<\/h2>\n<div class=\"gt-faq-item\">\n<h3>What is a Formula Field in Zoho CRM?<\/h3>\n<p>A Formula Field is a read-only custom field that automatically calculates its value from an expression using other fields on the record. It supports arithmetic, string, date, and conditional functions, eliminating the need to manually calculate and enter derived values.<\/p>\n<\/div>\n<div class=\"gt-faq-item\">\n<h3>Can a Formula Field reference fields on related records in Zoho CRM?<\/h3>\n<p>No. Formula fields can only reference fields on the same record. To aggregate or reference values from related records, use a Rollup Summary Field, which can sum, count, or find the maximum or minimum of a related module&#8217;s field values.<\/p>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>A Formula Field in Zoho CRM is a custom field whose value is automatically calculated from an expression using other fields on\u2026<\/p>\n","protected":false},"template":"","meta":{"seo_title":"Formula Field | Zoho Glossary","seo_description":"A Formula Field in Zoho CRM is a custom field whose value is automatically calculated from an expression using other fields on the same record. Unlike regu","seo_keyword":"formula field","seo_faqs":"[{\"q\": \"What is a Formula Field in Zoho CRM?\", \"a\": \"A Formula Field is a read-only custom field that automatically calculates its value from an expression using other fields on the record. It supports arithmetic, string, date, and conditional functions, eliminating the need to manually calculate and enter derived values.\"}, {\"q\": \"Can a Formula Field reference fields on related records in Zoho CRM?\", \"a\": \"No. Formula fields can only reference fields on the same record. To aggregate or reference values from related records, use a Rollup Summary Field, which can sum, count, or find the maximum or minimum of a related module\"s field values.\"}]","term_type":"Technical","glossary_related":"","glossary_links":""},"glossary_category":[1238],"class_list":["post-4042","glossary","type-glossary","status-publish","hentry","glossary_category-zoho-crm"],"_links":{"self":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary\/4042","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary"}],"about":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/types\/glossary"}],"wp:attachment":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/media?parent=4042"}],"wp:term":[{"taxonomy":"glossary_category","embeddable":true,"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary_category?post=4042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}