Create a formula field
Click the + icon to the right of the AI Table header bar, pick Formula as the field type.
Edit formula
Click Edit formula — the formula editor opens.
Edit the formula directly in the top input box.
In the Formula edit tab, reference fields or pick functions by category.
In the AI generate formula tab, generate a formula from natural language — details: Generate formulas with AI.
Concepts
| Term | Meaning |
|---|---|
| Field | The value of a column at a given row, used in formula computation |
| Whole-column field | The collection of values for an entire column, used in formula computation |
| Brackets | Used in formulas to reference AI Table tables or fields |
| Operator | Logical or arithmetic symbol used in a formula |
| Function | Produces an expected output via a specific computation rule |
| Argument | Number or text that participates in formula computation |
| String | A sequence of text used in formula computation |
| Array | A collection of values |
Common operators
| Type | Operator | Meaning | |
|---|---|---|---|
| Arithmetic | + | Add two values | |
- | Subtract two values | ||
* | Multiply two values | ||
/ | Divide two values | ||
| Text concat | & | Concatenate two strings; concat number with text when one is numeric | |
| Logical | > | Greater than | |
>= | Greater than or equal | ||
< | Less than | ||
<= | Less than or equal | ||
= | Equal | ||
!= | Not equal | ||
&& | AND | ||
| ` | ` | OR |