Skip to main content
A Children table record with a date of birth and an Age of 7 years worked out from it A Children table record with a date of birth and an Age of 7 years worked out from it 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: 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.
You cannot change a formula once the column is added. To change it, add a new formula column and archive the old one.

Next

Table reminders

Get a reminder before a worked-out date or when a value is reached.

Tracking certifications

Filter a table and file records for a person.

Still need help?

Contact support

Email the Begin team and we’ll get back to you.

Ask Begin AI

Open the AI assistant and get instant answers based on these docs.