# Formulas

Datalexing formula fields let you calculate a value automatically for every cell in a field, based on a formula you define. The syntax works much like the formulas you already know from spreadsheet tools — combined with a fast, growing function library built for tables.

A formula is built from two building blocks:

* **Operators** — symbols (`+`, `=`, `>`, etc.) that act directly between two values.

* **Functions** — named, predefined calculations (e.g. `SUM`, `IF`, `LEFT`) that take arguments, do something with them, and return a result.

**On this page**

* [Operators](https://chatwoot.help/hc/datalexinghelp/articles/1783707551-formulas#operators)

* [Function categories at a glance](https://chatwoot.help/hc/datalexinghelp/articles/1783707551-formulas#function-categories-at-a-glance)

* [📝 Text functions](https://chatwoot.help/hc/datalexinghelp/articles/1783717297-text-functions)

* [🔢 Number functions](https://chatwoot.help/hc/datalexinghelp/articles/1783717272-number-functions)

* [✅ Logical (True/False) functions](https://chatwoot.help/hc/datalexinghelp/articles/1783717212-logical-true-false-functions)

* [📃 List & Aggregation functions](https://chatwoot.help/hc/datalexinghelp/articles/1783716944-list-aggregation-functions)

* [🔁 General & Reference functions](https://chatwoot.help/hc/datalexinghelp/articles/1783717017-general-reference-functions)

* [🗓️ Date & Time functions](https://chatwoot.help/hc/datalexinghelp/articles/1783717058-date-time-functions)

* [🔗 Link functions](https://chatwoot.help/hc/datalexinghelp/articles/1783714609-link-formulas)

* [Editor's notes — what changed](https://claude.ai/chat/2e30ee8e-5010-4f55-8b0f-89fb6fcae0b5#editors-notes--what-changed-in-this-revision)

---

## Operators

Operators are symbols that perform arithmetic, comparisons, or text joins directly between two values, without needing to write a function name. Most operators have a matching function that does the exact same thing (listed below) — use whichever reads better in your formula.

| Operator | Function equivalent     | Description                                                               | Example              |
| -------- | ----------------------- | ------------------------------------------------------------------------- | -------------------- |
| `+`      | `ADD`                   | Adds two numbers and returns the sum.                                     | `1 + 2 = 3`          |
| `-`      | `MINUS`                 | Subtracts the second number from the first.                               | `10 - 2 = 8`         |
| `*`      | `MULTIPLY`              | Multiplies two numbers together.                                          | `10 * 3 = 30`        |
| `/`      | `DIVIDE`                | Divides the first number by the second.                                   | `10 / 5 = 2`         |
| `=`      | `EQUAL`                 | Returns `TRUE` if the two values are equal, `FALSE` otherwise.            | `10 = 10` → `TRUE`   |
| `!=`     | `NOT_EQUAL`             | Returns `TRUE` if the two values are **not** equal, `FALSE` otherwise.    | `10 != 10` → `FALSE` |
| `>`      | `GREATER_THAN`          | Returns `TRUE` if the first value is greater than the second.             | `10 > 11` → `FALSE`  |
| `>=`     | `GREATER_THAN_OR_EQUAL` | Returns `TRUE` if the first value is greater than or equal to the second. | `10 >= 10` → `TRUE`  |
| `<`      | `LESS_THAN`             | Returns `TRUE` if the first value is less than the second.                | `10 < 11` → `TRUE`   |
| `<=`     | `LESS_THAN_OR_EQUAL`    | Returns `TRUE` if the first value is less than or equal to the second.    | `19 <= 1` → `FALSE`  |

---

## Function categories at a glance

Every function in Datalexing belongs to one of the categories below, shown by an icon. Here's what each one actually covers:

<!--cw-colwidths:212,0-->
| Category                                                                                                       | Covers                                                                                                                                                             |
| -------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| [Text](https://chatwoot.help/hc/datalexinghelp/articles/1783717297-text-functions)                             | Reading, cleaning, and transforming text strings.                                                                                                                  |
| [Number](https://chatwoot.help/hc/datalexinghelp/articles/1783717272-number-functions)                         | Arithmetic, rounding, and mathematical calculations.                                                                                                               |
| [Logical](https://chatwoot.help/hc/datalexinghelp/articles/1783717212-logical-true-false-functions)            | Comparisons and conditions that return `TRUE` or `FALSE`.                                                                                                          |
| [List & Aggregation](https://chatwoot.help/hc/datalexinghelp/articles/1783716944-list-aggregation-functions)   | Summarizing values pulled in through a link/lookup field (sums, averages, counts, filters...).                                                                     |
| [General & Reference](https://chatwoot.help/hc/datalexinghelp/articles/1783717017-general-reference-functions) | Functions that pull in or combine data across *any* type — a field's raw value, a linked table's value, a row's ID — rather than being limited to text or numbers. |
| [Date & Time](https://chatwoot.help/hc/datalexinghelp/articles/1783717058-date-time-functions)                 | Creating, formatting, and measuring dates and timestamps.                                                                                                          |
| [Link](https://chatwoot.help/hc/datalexinghelp/articles/1783714609-link-formulas)                              | Building and reading clickable buttons and hyperlinks.                                                                                                             |

*Related: [*Column Types*](https://docs.datalexing.sa/en/articles/9065086-column-types) · [*Formulas Guide*](https://docs.datalexing.sa/en/articles/9259891-formulas-guide) · *[*Score Cards*](https://docs.datalexing.sa/en/articles/10538781-score-cards)