thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Business Platforms & EA · Foundational

Formula Field

Read-only field whose value is calculated at runtime from an expression using fields, operators and functions.

Definition

Formula fields can return text, number, currency, percent, date, date/time, time or checkbox. They are evaluated when the record is read, so they are not stored and do not trigger automation on change. Formulas are limited to 3,900 characters and a 5,000-byte compiled size.

Example

IF(Amount > 100000, "Large", "Standard")

Exam tip

Formula values change without a record update, so they cannot trigger record-triggered flows on their own.

Related terms