Formulas
A Formula field computes its value from the same record’s fields and updates automatically. Refer to a field by its name in braces: {Quantity}.
| Category | Functions | Example |
|---|---|---|
| Logical | IF SWITCH AND OR NOT BLANK |
IF({Amount} > 1000, "Large", "Normal") |
| Numeric | SUM AVERAGE ROUND ROUNDUP MIN MAX ABS MOD POWER |
ROUND({Price} * 1.15, 2) |
| Text | CONCATENATE LEN LEFT RIGHT MID UPPER LOWER TRIM SUBSTITUTE FIND REGEXP_REPLACE |
CONCATENATE({First name}, " ", {Last name}) |
| Date | TODAY NOW DATE_ADD DATETIME_DIFF DATETIME_FORMAT WORKDAY_DIFF IS_AFTER IS_BEFORE YEAR MONTH DAY |
DATETIME_DIFF({Due date}, TODAY(), "day") |
| Arrays | ARRAY_JOIN ARRAY_UNIQUE ARRAY_COMPACT COUNTALL |
ARRAY_JOIN({Tags}, ", ") |
| System | RECORD_ID CREATED_TIME LAST_MODIFIED_TIME |
RECORD_ID() |
Ready-made examples
Section titled “Ready-made examples”- Days late:
IF(IS_AFTER(TODAY(), {Due date}), DATETIME_DIFF(TODAY(), {Due date}, "day"), 0) - Total with VAT:
ROUND({Quantity} * {Price} * 1.15, 2) - Status icon:
SWITCH({Status}, "Done", "✅", "Late", "⚠️", "⏳")