Formula Column Examples and Use Cases

This article shows practical formula patterns you can use in TexAu to transform, combine, and evaluate data across columns.

What formulas do in TexAu

A Formula Column computes a value from other columns in the same row. Formulas run entirely within TexAu. They do not call any API and cost 0 credits. Use them to:

• Combine or format text before passing it to an Action Column
• Extract part of a value (e.g., domain from an email address)
• Calculate scores or apply conditional logic
• Clean dirty input data before enrichment

Add a Formula Column

1. Click + Add column at the right edge of your table.
2. Select Formula Column.
3. Enter your formula in the formula editor.
4. Click Preview to check output against the first few rows.
5. Click Save.

Formula syntax

Reference column values using double curly braces: {{Column Name}}.

Literal text goes inside quotes: "https://linkedin.com/in/".

Operators: + (concatenation and addition), -, *, /, ==, !=, >, <, >=, <=.

Common formula patterns

Combine first name and last name

{{First Name}} + " " + {{Last Name}}

Use this before actions that take a full name as input.

Extract domain from email address

SPLIT({{Email}}, "@", 1)

Returns everything after the @ sign. Pass this to actions that need a company domain.

Build a full LinkedIn URL from a handle

"https://linkedin.com/in/" + {{LinkedIn Handle}}

Use this when your data has bare handles instead of full URLs.

Conditional value selection

IF({{Email}} != "", {{Email}}, {{Personal Email}})

Returns the work email if it exists. Falls back to the personal email if not.

Clean extra whitespace from text

TRIM({{Company Name}})

Removes leading and trailing spaces. Useful for imported CSV data.

Convert text to lowercase

LOWER({{Email}})

Normalizes email addresses before deduplication or verification steps.

Check if a value contains a specific word

IF(CONTAINS({{Job Title}}, "VP"), "Senior", "Other")

Returns "Senior" if the job title contains "VP", otherwise "Other".

Calculate the length of a string

LEN({{Bio}})

Useful for checking whether a field has meaningful content.

Concatenate a search query

{{First Name}} + " " + {{Last Name}} + " " + {{Company Name}} + " LinkedIn"

Build a Google search query string to pass into a web search action.

Extract the first word from text

SPLIT({{Full Name}}, " ", 0)

Returns the first name when you only have a full name column.

Chain formulas with action columns

Formulas are most useful when they prepare input data for an action. A common pattern:

1. Input column - LinkedIn Handle (raw data from your CSV)
2. Formula Column - Full URL: "https://linkedin.com/in/" + TRIM({{LinkedIn Handle}})
3. Action Column - Find Mobile Number by LinkedIn URL, using the formula column as input

This keeps your raw data intact and ensures the action always receives a clean, properly formatted URL.

Troubleshooting

The formula returns "undefined" or blank for some rows. A referenced column is empty for those rows. Wrap the reference in an IF to handle empty values: IF({{Column}} != "", {{Column}}, "fallback").

SPLIT is returning an unexpected part of the string. SPLIT uses zero-based indexing. SPLIT({{Email}}, "@", 0) returns the part before the @. SPLIT({{Email}}, "@", 1) returns the part after.

The formula preview looks correct but the full run produces different results. The preview uses the first few rows. Some rows may have edge cases (unusual characters, mixed-case values, extra spaces). Scan the output after running and adjust the formula to handle variations.

The Formula Column option is not available. Formula Columns are available on all plans. If you do not see the option, refresh the page and try again. Contact support if the issue continues.