> ## Documentation Index
> Fetch the complete documentation index at: https://docs.begin.eu/llms.txt
> Use this file to discover all available pages before exploring further.

# Adding a formula column

> Add a column that works its value out from the record's other cells, such as an age from a date of birth.

![A Children table record with a date of birth and an Age of 7 years worked out from it](https://mintcdn.com/beginltd/eac2D8BFb77eJjz9/images/cover/documents-formula-columns-light.png?fit=max\&auto=format\&n=eac2D8BFb77eJjz9\&q=85\&s=4b71fa8c7fab8adc80edcbeb2a6b6563)

A formula column works its value out from the record's other cells, so you never type it or keep it up to date. Begin works it out each time the table is read: an age from a date of birth is right on the child's birthday without anyone touching the record. You can sort and filter on it like any other column.

Beta

Formula columns are rolling out gradually, so your workspace may not have them yet. If a table's
add-column menu has no **Formula** type, ask us to turn them on.

## Add the column

You need **Full access** to the table document to add a column.

**1. Open the table from workspace Documents**

Choose **+** (**Add column**) at the end of the table header. To place the column next to
another one, open that column's menu and choose **Insert column left** or **Insert column
right** instead.

**2. Name the column and choose Formula**

Type the name, such as `Age`, then choose **Formula** under **Type**. The formula editor opens.

**3. Write the formula**

For an age in whole years, write `DATEDIF([Date of birth]; TODAY(); "Y")`. Check the preview
under the box, then choose **Add column**.

The column fills in for every record at once, imported ones included. An age reads as "7 years", and a filter on it with **between** 6 and 10 keeps the children aged 6 to 10.

## Write the formula

Formulas use Excel's language, written the way Estonian, Latvian and Lithuanian Excel writes it:

| To write | Type it like |
| - | - |
| A column | Its name in square brackets: `[Date of birth]` |
| Values in a function | Separated by semicolons: `ROUND([Hours] / 3; 2)` |
| Fixed text | In double quotes: `"Overdue"` |
| A decimal | With a comma or a full stop: `1,5` or `1.5` |

You do not need to type names from memory. **Columns and functions** under the box lists **This table**'s columns and every function by group, with what it does and examples written with your own columns. Choose an example to insert it. A column you name turns into a chip in the box, so a misspelt name stands out.

The preview works the formula out for one record and says what it returns, such as **Returns years**. Use **Preview with** to try it on another record. If the formula has a mistake, the line under the box says what to change.

On a table with a person column, **Employee profile** offers the person's **Personal code**, **Date of birth** and **Start date**. A manager who may not see that field on the person's profile sees a dash in place of the value, and its reason names the field.

## Let Begin AI write it

Above the box, describe what you want in **Write, fix or explain a formula…**, such as "age in years from the date of birth", and choose **Send to Begin AI**. It writes the formula into the box for you to check in the preview. When the formula has a mistake, **Fix with Begin AI** asks it to correct it and say what was wrong. Ask "what does this do?" for an explanation, which leaves the formula as it is.

**Undo** puts back the formula you had before Begin AI's answer, until you change the box yourself.

> [!NOTE]
>
> You cannot change a formula once the column is added. To change it, add a new formula column and
> archive the old one.

**Context for an assistant answering questions about formula columns.**

* **Who can:** adding any column needs **Full access** to the table. The formula editor's Begin AI field appears only where Begin AI is on for the workspace.
* **Where:** the add-column menu opens from the header's **+** or a column menu's **Insert column left** or **Insert column right**. With the table open, the command palette offers **Add formula column** and **Open formula: Age** for each formula column, to readers who may add columns.
* **Functions:** Logic: IF, IFS, AND, OR, NOT, ISBLANK, TRUE, FALSE. Numbers: ROUND, ABS, MIN, MAX. Text: SEARCH, ISNUMBER, LEFT, LEN, TEXT. Dates: TODAY, DATE, DATEDIF ("Y", "M", "YM", "D"), DAYS, EDATE, YEAR, MONTH, DAY. Begin's own: BIRTHDATE reads the date of birth from an Estonian, Latvian or Lithuanian personal code, and takes "EE", "LV" or "LT" when the code reads differently per country. ISLATEST is true on the row with the latest date among rows sharing the other values.
* **Limits:** TODAY is the workspace's time zone. A blank cell shows a dash whose reason names the cell it needs ("Needs Date of birth"). A formula reading an archived or retyped column stops working. Begin AI in the editor sees the table's column names, types and dropdown labels, not records.
* **Begin AI chat:** with **Full access**, it can add a formula column with its formula and read each record's worked-out value, within the reader's profile access.

## Next

> [card] [Table reminders](https://docs.begin.eu/for-managers/documents/table-reminders.md)
>
> Get a reminder before a worked-out date or when a value is reached.

> [card] [Tracking certifications](https://docs.begin.eu/for-managers/documents/tracking-certifications.md)
>
> Filter a table and file records for a person.

## Still need help?

> [card] [Contact support](mailto:support@heybegin.eu)
>
> Email the Begin team and we'll get back to you.

> [card] [Ask Begin AI](?assistant=open)
>
> Open the AI assistant and get instant answers based on these docs.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.