Accounts

Formula basics: creating calculated columns

If you have used Excel or Google Sheets formulas before, you will feel right at home with TexAu formulas. The difference is that TexAu formulas are built for B2B data —cleaning leads, enriching contact records, segmenting accounts, and preparing data for outreach at scale.

This guide walks you through everything you need to write your first formula and start transforming your data.


What are formulas?

A formula is an expression that takes data from one or more columns in your table and produces a new calculated value. When you create a formula column, TexAu evaluates the formula for every row automatically —both existing rows and any new rows added in the future.

Real-world examples of what formulas can do:

  • Combine first and last name into a single "Full Name" column for outreach personalization
  • Calculate deal value by multiplying quantity by unit price
  • Extract the domain from an email address (e.g., pull "acme.com" from "john@acme.com")
  • Segment accounts by checking if revenue falls within a certain range
  • Clean up messy text by trimming extra spaces or standardizing capitalization

Instead of exporting your data to a spreadsheet, running calculations, and re-importing, you define the formula once and TexAu handles the rest.


Adding a formula column

Follow these steps to create your first formula column:

  1. Open your table and navigate to the Columns section.
  2. Click + Add Column at the bottom of your column list.
  3. Select Formula as the column type.
  4. Give your column a descriptive name (for example, "Full Name" or "Domain Extracted").
  5. Click Create Column.
  6. In the formula editor that opens, write your formula.
  7. Click Test Formula to preview the results on sample rows.
  8. Once you are satisfied with the output, click Save.

Your formula column will now calculate values for every row in the table.


Your first formula: building a full name

Let us start with a practical example. Suppose your table has two columns: first_name and last_name. You want a single "Full Name" column that combines them.

Here is the formula:

CONCAT(first_name, " ", last_name)

Breaking this down:

  • CONCAT is a built-in function that joins text values together.
  • first_name and last_name are references to your existing columns.
  • " " is a literal space character that goes between the two names.
  • The result for a row where first_name is "John" and last_name is "Smith" would be: John Smith

Note: Column names in formulas are case-sensitive. If your column is named FirstName, you must type FirstName exactly —not firstname or first_name.


Understanding the formula editor

When you open the formula editor, you will see four areas:

  • The main text area —This is where you type your formula. It supports syntax highlighting so you can spot errors as you type.
  • Column suggestions —As you begin typing a column name, TexAu suggests matching columns from your table. Select from the dropdown to make sure you reference the column correctly.
  • Function library —A sidebar reference of all available functions. Click any function to see its syntax and a brief description.
  • Error messages —If your formula has a problem, TexAu displays a message explaining what needs to be fixed. These appear in real time as you type, so you will know immediately when something is wrong.

Referencing other columns

Formulas get useful when they pull data from multiple columns. Here are the rules for column references:

Column names must match exactly. Use the suggestions dropdown to avoid typos. If your column name contains spaces, type the name as-is —TexAu handles it automatically.

# All of these are valid column references:
company_name
Company Name
email_address
First Name

You can reference multiple columns in a single formula:

CONCAT(first_name, " ", last_name, " (", company_name, ")")

This produces output like: John Smith (Acme Inc.)

Tip: If a column reference is not working, double-check the spelling and capitalization. The name must match the column header exactly.


Formula syntax basics

Formulas support standard math, comparison, and logic operators. Here is a quick reference.

Math operators

This table scrolls sideways on small screens.

OperatorDescriptionExample
+Additionprice + tax
-Subtractiontotal - discount
*Multiplicationquantity * unit_price
/Divisionrevenue / employee_count
%Modulo (remainder)number % 2 (returns 0 for even numbers, 1 for odd)

Comparison operators

This table scrolls sideways on small screens.

OperatorDescriptionExample
==Equalsstatus == "active"
!=Does not equalstatus != "inactive"
<Less thanage < 18
<=Less than or equal toage <= 18
>Greater thanrevenue > 1000000
>=Greater than or equal torevenue >= 1000000

Logic operators

This table scrolls sideways on small screens.

OperatorDescriptionExample
&&AND (both conditions must be true)status == "active" && verified == true
||OR (at least one condition must be true)plan == "pro" || plan == "enterprise"
!NOT (reverses a boolean)!is_blacklisted

Understanding data types

Formulas work with three main data types. Knowing the difference helps you avoid common mistakes.

Text (strings)

Text values are enclosed in double quotes. Column references that point to text columns are also treated as text.

"Hello World"
"Sales"
first_name
company_name

Numbers

Numbers are written without quotes. You can perform arithmetic on number values directly.

42
3.14
revenue
quantity * price
(annual_salary / 12)

Parentheses control the order of operations, just like in math:

(total_revenue / total_customers)
(salary + bonus) / 12

Booleans

Boolean values are either true or false. Comparisons produce boolean results, which are commonly used inside IF formulas.

is_verified == true
revenue > 100000
status == "active"

Testing formulas before applying

Always test your formula before saving. Here is how:

  1. Write your formula in the editor.
  2. Click Test Formula (or press Ctrl+Enter on your keyboard).
  3. TexAu displays a preview using real data from your table.
  4. Review the Output column to confirm the results look correct.
  5. If everything checks out, click Save. If not, edit and test again.

The preview uses actual rows from your table, so you see exactly what the formula will produce.

Tip: Testing is your safety net. Always test before saving, especially when working with complex formulas or unfamiliar functions.


Common first formulas

Here are practical formulas you can copy and adapt right away.

Combine text fields

CONCAT(first_name, " ", last_name)

Use when: You need to merge two or more text columns into one, such as building a full name for email personalization.

Extract domain from email

AFTER(email, "@")

Use when: You need the domain portion of an email address. Turns "john@acme.com" into "acme.com".

Categorize with if/then logic

IF(revenue > 100000, "Enterprise", "SMB")

Use when: You want to segment rows based on a threshold. Rows with revenue above 100,000 are labeled "Enterprise"; the rest are labeled "SMB".

Check if text contains a keyword

INCLUDES(company_name, "Inc.")

Use when: You need to flag rows where a text field contains a specific word or phrase. Returns true or false.

Remove extra spaces

TRIM(company_name)

Use when: You have text data with leading or trailing spaces that need cleaning. Turns " Acme Inc. " into "Acme Inc.".

Count characters in a field

LEN(phone_number)

Use when: You want to check the length of a text value. Useful for simple data validation, such as verifying phone numbers have enough digits.

Perform a calculation

(annual_salary / 12)

Use when: You need to derive a new number from existing numeric data. This example converts an annual figure to a monthly one.

All of these functions and many more are explained in detail in the Formula Functions Reference.


Next steps