Calculated Property
A field whose value is derived by formula from other fields rather than entered. Cannot go stale through neglect, which makes it preferable wherever the value is derivable at all.
Also called: Formula Field, Roll-up Property
What it is
A calculated property computes its value from other properties: days since last contact, margin from amount and cost, a concatenated display name, whether a renewal falls this quarter. Nobody types it, so nobody forgets to.
Two kinds
Formula: derived from other fields on the same record. Arithmetic, dates, conditionals, string assembly.
Roll-up: derived from associated records — total value of open deals on a company, number of tickets in the last ninety days. Depends on associations being correct, which is worth knowing before trusting one.
Why they are usually the right answer
A manually maintained field is only as current as the last person who remembered. A derived field is current by construction. Any time you find yourself asking someone to keep a field up to date with information the system already holds, a calculated property is the answer.
The limits
They cannot be edited, which is correct but occasionally surprising. They can be expensive to recompute at volume. And a formula referencing a field somebody later deletes fails in ways that are not always loud — so calculated properties belong in the same governance review as everything else.
RELATED TERMS
Data Hygiene
The continuous practice of keeping records accurate, complete and current — as distinct from data quality, which is the state that practice produces.
Data Governance
The rules determining who may change what, how changes are reviewed, and how they are recorded. The control that stops a designed system from drifting back to whatever it was before.
CRM
The system of record for customer relationships — the accounts, people, deals and interactions a revenue team works from. Its value is decided by what is entered into it, not by which vendor supplies it.
Property
A single field on a CRM record. The unit of everything a CRM knows — and the unit of everything it gets wrong, because each one is a promise that somebody will maintain it.
COMMON QUESTIONS
- What is the difference between a formula and a roll-up property?
- A formula works from fields on the same record. A roll-up aggregates across associated records, so it depends on those associations being complete and correct.
- Can I edit a calculated property?
- No — its value comes from the formula. If you need to override it, you need a separate editable field and a deliberate rule about which one wins.
- When should I not use one?
- When the value is a judgement rather than a derivation. Health scores and qualification calls often look derivable and are not; forcing them into a formula produces a number that is precise and wrong.
Build the capability
Definitions are the vocabulary. The courses are where you learn to operate it, with the interactive audit tools.
See the courses