A Formula column computes a new value for each row by applying an expression to data from other columns in that row. Formulas run automatically on every row and update whenever the source data changes. You can use them to extract, transform, combine, or calculate values without any manual effort.

You can add a Formula column in three ways: by clicking "+ Add column" at the end of the table and selecting "Formula", by clicking the "Formula" button in the table toolbar, or by clicking "Columns" in the toolbar and hovering over "+ New column" to reveal the column type picker.

There are three ways to build a formula column:

• Use AI — Describe what you want in plain language and let AI write the formula for you.
• Write your own formula — Write a JavaScript expression directly using column tokens.
• Text with tokens — Combine static text and column values into a single string without writing code.

The Use AI tab lets you describe what you want to do in plain English and automatically produces the correct expression. Type "/" to reference a column inside your description, then click "Generate".

Examples of what you can describe:

• Extract the domain from /Email
• Extract the text after @ in /Twitter Handle
• Look at the /CompanyName. Remove legal suffixes like Inc, L.L.C., Corp, or Limited. Also, remove anything in parentheses and any extra whitespace at the end.
• Check the /CompanySize and /Industry. If the size is over 500 AND the industry is "Technology", return "Tier 1". If the size is between 100-500, return "Tier 2". Otherwise, return "Tier 3".
• Take the email address from the /Email column and extract only the part after the @ symbol. If the result is a common provider like gmail.com or outlook.com, return "Personal email", otherwise return the domain

Formulas are powered by our script — a JavaScript-based expression language that runs row-by-row on your table. When you reference a column using {{Column_name}}, Coldout automatically passes that row's value into your expression.

You have access to the full range of standard JavaScript as well as several built-in libraries:

• Standard JavaScript — All standard objects and methods including Math, String, Array, Date, RegExp, Number, Object, and more.
• Lodash — The full Lodash library available via _ for advanced data manipulation (e.g. _.groupBy, _.uniq, _.merge).
• Moment.js — Available via moment for powerful date and time operations (e.g. parsing, formatting, and calculating durations).
• Excel and Google Sheets functions — Hundreds of familiar spreadsheet functions like VLOOKUP, IF, SUM, CONCATENATE, and many more, available through the FormulaJS library.

Type "/" to insert a column token into your expression. Click "Test" to validate the formula against your data before saving.

Text with tokens lets you build a text string by combining static text and column values — no code required. Type your message and use "/" to insert column references inline. For example, typing "/First_name /Last_name works at /Company" would produce a different personalised string for each row.