Data store and Export

Formula functions reference

This is your complete guide to every formula function available in TexAu. Each function includes a description, syntax, practical examples with expected input and output, and tips for getting the most out of it.

Use this page as a reference whenever you are building or troubleshooting a formula.


Logic functions

Logic functions let you make decisions in your formulas. Use them to categorize data, check conditions, and handle missing values.

IF —conditional logic

What it does: Returns one value when a condition is true and a different value when it is false.

Syntax:

IF(condition, value_if_true, value_if_false)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
conditionAn expression that evaluates to true or false
value_if_trueThe value returned when the condition is true
value_if_falseThe value returned when the condition is false

Examples:

  1. Categorize companies by employee count:
IF(employee_count > 500, "Enterprise", "Mid-Market")

This table scrolls sideways on small screens.

employee_countResult
1200Enterprise
85Mid-Market
  1. Flag high-value deals for your sales team:
IF(deal_value > 50000, "High Priority", "Standard")

This table scrolls sideways on small screens.

deal_valueResult
75000High Priority
12000Standard
  1. Nested IF for multi-tier classification:
IF(revenue > 1000000, "Tier 1", IF(revenue > 100000, "Tier 2", "Tier 3"))

This table scrolls sideways on small screens.

revenueResult
2500000Tier 1
350000Tier 2
45000Tier 3

Tips:

  • You can nest IF functions up to 5 levels deep for multi-tier logic.
  • Conditions use comparison operators such as >, <, ==, !=, >=, and <=.
  • Think of it as: "If this is true, do A. Otherwise, do B."

AND —all conditions must be true

What it does: Returns true only when every condition you provide is met.

Syntax:

AND(condition1, condition2, ...)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
condition1, condition2, ...Two or more expressions that each evaluate to true or false

Examples:

  1. Identify qualified leads based on multiple criteria:
AND(industry == "Technology", revenue > 100000, hiring == true)

This table scrolls sideways on small screens.

industryrevenuehiringResult
Technology250000truetrue
Technology50000truefalse
Healthcare300000truefalse
  1. Check that key fields are filled in:
AND(email != "", phone != "", company != "")

This table scrolls sideways on small screens.

emailphonecompanyResult
john@acme.com5551234567Acmetrue
john@acme.comAcmefalse
  1. Combine with IF for actionable output:
IF(AND(status == "active", plan == "enterprise"), "Renewal Candidate", "Other")

Tips:

  • AND is strict —every condition must pass for the result to be true.
  • Pair with IF to take action when multiple criteria are met at once.
  • Commonly used for data quality checks and lead qualification.

OR —at least one condition must be true

What it does: Returns true when any one of the conditions you provide is met.

Syntax:

OR(condition1, condition2, ...)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
condition1, condition2, ...Two or more expressions that each evaluate to true or false

Examples:

  1. Identify executive-level contacts:
OR(title == "CEO", title == "CTO", title == "CFO")

This table scrolls sideways on small screens.

titleResult
CEOtrue
Sales Managerfalse
CFOtrue
  1. Check for target industries:
OR(industry == "SaaS", industry == "FinTech", industry == "Healthcare")
  1. Flag incomplete records:
IF(OR(email == "", phone == ""), "Incomplete", "Complete")

This table scrolls sideways on small screens.

emailphoneResult
john@acme.com5551234567Complete
5551234567Incomplete
john@acme.comIncomplete

Tips:

  • OR is more permissive than AND —only one condition needs to pass.
  • Useful for grouping records into categories (e.g., "Is this a target industry?").
  • Combine with IF to produce readable labels based on the result.

NOT —reverse a boolean

What it does: Flips true to false and false to true.

Syntax:

NOT(condition)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
conditionAn expression that evaluates to true or false

Examples:

  1. Find contacts who are not yet customers:
NOT(is_customer == true)
  1. Flag unverified leads:
IF(NOT(email_verified), "Needs Verification", "Verified")

This table scrolls sideways on small screens.

email_verifiedResult
trueVerified
falseNeeds Verification
  1. Exclude a specific group:
NOT(AND(industry == "Competitor", deal_stage == "Closed"))

Tips:

  • NOT is cleaner than writing condition == false.
  • Combine with AND and OR for advanced filtering logic.

COALESCE —return the first non-empty value

What it does: Checks a list of values in order and returns the first one that is not empty. This is how you handle missing data gracefully.

Syntax:

COALESCE(value1, value2, value3, ...)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
value1, value2, ...Two or more values or column references, checked in order

Examples:

  1. Build an email waterfall (prefer personal, fall back to work, then backup):
COALESCE(personal_email, work_email, backup_email)

This table scrolls sideways on small screens.

personal_emailwork_emailbackup_emailResult
john@gmail.comjohn@acme.comjohn@backup.comjohn@gmail.com
sarah@acme.comsarah@backup.comsarah@acme.com
mike@backup.commike@backup.com
  1. Prioritize phone number sources:
COALESCE(mobile_phone, office_phone, home_phone)
  1. Provide a default when data is missing:
COALESCE(city, "Not Provided")

This table scrolls sideways on small screens.

cityResult
San FranciscoSan Francisco
Not Provided

Tips:

  • Order matters —COALESCE checks values from left to right and stops at the first non-empty one.
  • Great for waterfall enrichment workflows where you have multiple data sources.
  • Use a quoted string as the last value to set a fallback default.

Text functions

Text functions let you combine, extract, clean, and transform text data across your columns.

CONCAT —join text together

What it does: Combines multiple text values into a single string.

Syntax:

CONCAT(value1, value2, ...)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
value1, value2, ...Two or more text values or column references to join

Examples:

  1. Create a full name:
CONCAT(first_name, " ", last_name)

This table scrolls sideways on small screens.

first_namelast_nameResult
JohnSmithJohn Smith
SarahJohnsonSarah Johnson
  1. Build a display label:
CONCAT(first_name, " at ", company_name)

This table scrolls sideways on small screens.

first_namecompany_nameResult
JohnAcme CorpJohn at Acme Corp
  1. Assemble a full address:
CONCAT(street, ", ", city, ", ", state, " ", zip)

This table scrolls sideways on small screens.

streetcitystatezipResult
123 Main StDenverCO80202123 Main St, Denver, CO 80202

Tips:

  • Always include separators (spaces, commas, dashes) explicitly —CONCAT does not add them automatically.
  • You can join as many values as you need in a single CONCAT call.
  • Mix column references with quoted text freely.

LEN —count characters

What it does: Returns the number of characters in a text value, including spaces.

Syntax:

LEN(text)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
textA text value or column reference

Examples:

  1. Check if a description is substantial:
IF(LEN(company_description) > 100, "Detailed", "Brief")
  1. Validate email length:
IF(LEN(email) < 5, "Likely Invalid", "Probably Valid")

This table scrolls sideways on small screens.

emailLEN(email)Result
john@acme.com13Probably Valid
a@b3Likely Invalid
  1. Verify phone number format:
IF(LEN(phone_number) >= 10, "Valid Format", "Needs Review")

Tips:

  • LEN counts every character, including spaces and punctuation.
  • Combine with IF for simple data quality checks.
  • Useful as a quick validation before sending data to other systems.

UPPER —convert to uppercase

What it does: Converts all letters in a text value to uppercase.

Syntax:

UPPER(text)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
textA text value or column reference

Examples:

  1. Standardize state abbreviations:
UPPER(state)

This table scrolls sideways on small screens.

stateResult
caCA
nyNY
  1. Normalize industry labels:
UPPER(industry)

This table scrolls sideways on small screens.

industryResult
technologyTECHNOLOGY
SaaSSAAS

Tips:

  • UPPER affects letters only —numbers and symbols remain unchanged.
  • Useful for standardizing values before comparisons.
  • Combine with TRIM to clean and uppercase in one step.

LOWER —convert to lowercase

What it does: Converts all letters in a text value to lowercase.

Syntax:

LOWER(text)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
textA text value or column reference

Examples:

  1. Standardize email addresses:
LOWER(email)

This table scrolls sideways on small screens.

emailResult
John@ACME.comjohn@acme.com
  1. Normalize domains for matching:
LOWER(domain)

This table scrolls sideways on small screens.

domainResult
ACME.COMacme.com
Startup.IOstartup.io
  1. Case-insensitive comparison:
LOWER(status) == "active"

Tips:

  • Often used before comparisons to handle inconsistent data entry.
  • Combine with TRIM for thorough data cleanup: LOWER(TRIM(value)).

TRIM —remove leading and trailing spaces

What it does: Strips extra spaces from the beginning and end of a text value.

Syntax:

TRIM(text)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
textA text value or column reference

Examples:

  1. Clean up imported company names:
TRIM(company_name)

This table scrolls sideways on small screens.

company_nameResult
" Acme Inc. ""Acme Inc."
" Tech Corp ""Tech Corp"
  1. Standardize before comparison:
TRIM(title) == "Sales Manager"
  1. Combine with other cleanup functions:
UPPER(TRIM(industry))

Tips:

  • TRIM removes spaces from both ends but does not affect spaces in the middle of the text.
  • Good for data imported from external sources where formatting is inconsistent.
  • Combine with UPPER or LOWER for thorough text standardization.

REPLACE —find and replace text

What it does: Finds all occurrences of a specified text within a string and replaces them with new text.

Syntax:

REPLACE(text, old_text, new_text)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
textThe original text value or column reference
old_textThe text to search for
new_textThe text to substitute in its place

Examples:

  1. Remove dashes from phone numbers:
REPLACE(phone_number, "-", "")

This table scrolls sideways on small screens.

phone_numberResult
555-123-45675551234567
  1. Remove "www." from domains:
REPLACE(domain, "www.", "")

This table scrolls sideways on small screens.

domainResult
www.acme.comacme.com
  1. Stack REPLACE calls to handle multiple patterns:
REPLACE(REPLACE(phone, "-", ""), " ", "")

This table scrolls sideways on small screens.

phoneResult
555-123 45675551234567

Tips:

  • REPLACE is case-sensitive —"Corp" will not match "corp".
  • To handle multiple replacements, nest REPLACE calls inside each other.
  • Use an empty string "" as the replacement to delete text.

SPLIT —break text into parts

What it does: Splits a text string into an array of parts using a separator you specify.

Syntax:

SPLIT(text, delimiter)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
textThe text value or column reference to split
delimiterThe character or string to split on

Examples:

  1. Extract the domain from an email address:
SPLIT(email, "@")[1]

This table scrolls sideways on small screens.

emailResult
john@acme.comacme.com
  1. Get the first word from a job title:
SPLIT(title, " ")[0]

This table scrolls sideways on small screens.

titleResult
Vice President SalesVice
  1. Parse a structured code:
SPLIT(product_code, "-")[0]

This table scrolls sideways on small screens.

product_codeResult
PROD-2024-001PROD

Tips:

  • SPLIT returns an array. Use [0] for the first part, [1] for the second, and so on.
  • Indexing starts at 0 (the first piece is [0]).
  • Best suited for data that follows a consistent pattern or structure.

SUBSTRING —extract a portion of text

What it does: Returns a specific portion of a text string based on a starting position and length.

Syntax:

SUBSTRING(text, start, length)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
textThe text value or column reference
startThe position to start from (0-based)
lengthHow many characters to extract

Examples:

  1. Extract the year from a date string:
SUBSTRING(date_string, 0, 4)

This table scrolls sideways on small screens.

date_stringResult
2024-01-152024
  1. Get the first three characters of a company name:
SUBSTRING(company_name, 0, 3)

This table scrolls sideways on small screens.

company_nameResult
Acme CorporationAcm
  1. Extract an area code from a phone number:
SUBSTRING(phone, 0, 3)

This table scrolls sideways on small screens.

phoneResult
5551234567555

Tips:

  • Position counting starts at 0, not 1.
  • Best for data in fixed formats where you know the exact position of the information you need.
  • For variable-format data, consider SPLIT or AFTER instead.

AFTER —get everything after a delimiter

What it does: Returns all text that appears after the first occurrence of a specified delimiter.

Syntax:

AFTER(text, delimiter)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
textThe text value or column reference
delimiterThe character or string to search for

Examples:

  1. Extract domain from an email address:
AFTER(email, "@")

This table scrolls sideways on small screens.

emailResult
john@acme.comacme.com
sarah@startup.iostartup.io
  1. Get the path from a URL:
AFTER(url, "//")

This table scrolls sideways on small screens.

urlResult
https://acme.com/aboutacme.com/about
  1. Extract the value after a separator:
AFTER(employee_code, "-")

This table scrolls sideways on small screens.

employee_codeResult
DEPT-ABC123ABC123

Tips:

  • The delimiter itself is not included in the result.
  • Simpler than SPLIT when you only need the text after a single separator.
  • If the delimiter is not found in the text, the original text is returned unchanged.

Math functions

Math functions let you perform calculations, round values, and work with numbers in your formulas.

ABS —absolute value

What it does: Returns the positive version of a number, removing any negative sign.

Syntax:

ABS(number)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
numberA numeric value or column reference

Examples:

  1. Show variance magnitude regardless of direction:
ABS(revenue_variance)

This table scrolls sideways on small screens.

revenue_varianceResult
-50005000
32003200
  1. Calculate how far actual results deviate from target:
ABS(target_revenue - actual_revenue)

This table scrolls sideways on small screens.

target_revenueactual_revenueResult
1000008500015000
10000011200012000

Tips:

  • ABS is useful when you care about the size of a difference, not its direction.
  • Common in performance tracking and variance analysis.

MIN —smallest value

What it does: Returns the smallest number from the values you provide.

Syntax:

MIN(number1, number2, ...)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
number1, number2, ...Two or more numeric values or column references

Examples:

  1. Find the lowest vendor quote:
MIN(vendor_a_price, vendor_b_price, vendor_c_price)

This table scrolls sideways on small screens.

vendor_a_pricevendor_b_pricevendor_c_priceResult
4500320051003200
  1. Find the fastest delivery option:
MIN(standard_days, express_days, overnight_days)

This table scrolls sideways on small screens.

standard_daysexpress_daysovernight_daysResult
7311
  1. Make sure a value never drops below zero:
MAX(profit, 0)

Tips:

  • MIN compares numeric values only.
  • Useful for finding the best (lowest cost, shortest time) option across multiple sources.

MAX —largest value

What it does: Returns the largest number from the values you provide.

Syntax:

MAX(number1, number2, ...)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
number1, number2, ...Two or more numeric values or column references

Examples:

  1. Find the best-performing quarter:
MAX(q1_revenue, q2_revenue, q3_revenue, q4_revenue)

This table scrolls sideways on small screens.

q1_revenueq2_revenueq3_revenueq4_revenueResult
12000095000145000110000145000
  1. Find the highest lead score across categories:
MAX(engagement_score, fit_score, activity_score)

This table scrolls sideways on small screens.

engagement_scorefit_scoreactivity_scoreResult
72886588
  1. Cap a value at a maximum (use MIN for this):
MIN(quota_attainment, 1.5)

Tips:

  • MAX returns the single highest value.
  • Pair with MIN for range analysis: MAX(a, b) - MIN(a, b) gives the spread.

ROUND —round to decimal places

What it does: Rounds a number to the number of decimal places you specify.

Syntax:

ROUND(number, decimals)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
numberA numeric value or column reference
decimalsHow many decimal places to keep (0 for whole numbers)

Examples:

  1. Round to the nearest whole dollar:
ROUND(monthly_cost, 0)

This table scrolls sideways on small screens.

monthly_costResult
123.456123
89.7290
  1. Round a percentage to two decimal places:
ROUND(percentage, 2)

This table scrolls sideways on small screens.

percentageResult
75.678975.68
  1. Calculate and round a monthly cost:
ROUND(annual_cost / 12, 2)

This table scrolls sideways on small screens.

annual_costResult
150001250.00

Tips:

  • Use 0 for whole numbers, 2 for currency values.
  • Standard rounding rules apply (0.5 rounds up).

FLOOR —always round down

What it does: Rounds a number down to the nearest whole number, regardless of the decimal value.

Syntax:

FLOOR(number)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
numberA numeric value or column reference

Examples:

  1. Calculate complete years from days:
FLOOR(days_as_customer / 365)

This table scrolls sideways on small screens.

days_as_customerCalculationResult
14634.014
2000.550
  1. Calculate full months of tenure:
FLOOR(tenure_in_days / 30)

This table scrolls sideways on small screens.

tenure_in_daysResult
1274

Tips:

  • FLOOR always rounds down, even if the decimal is .99.
  • Useful when you only want to count complete units (full years, full months, full dozens).
  • Opposite of CEIL.

CEIL —always round up

What it does: Rounds a number up to the nearest whole number, regardless of the decimal value.

Syntax:

CEIL(number)

Parameters:

This table scrolls sideways on small screens.

ParameterDescription
numberA numeric value or column reference

Examples:

  1. Calculate billable hours (always round up partial hours):
CEIL(task_minutes / 60)

This table scrolls sideways on small screens.

task_minutesCalculationResult
651.082
1202.002
  1. Calculate the number of pages needed:
CEIL(total_words / 500)

This table scrolls sideways on small screens.

total_wordsResult
24005
  1. Determine how many groups of five you need:
CEIL(employees / 5)

This table scrolls sideways on small screens.

employeesResult
235

Tips:

  • CEIL always rounds up, even if the decimal is .01.
  • Useful for "you need at least this many" calculations (seats, pages, hours).
  • Opposite of FLOOR.

Combining functions: real-world recipes

You get the most out of formulas when you combine multiple functions. Here are recipes you can adapt for common B2B data tasks.

Clean and standardize a domain from an email

LOWER(TRIM(AFTER(email, "@")))

What it does: Extracts the domain, removes any stray spaces, and converts to lowercase for consistent matching.

This table scrolls sideways on small screens.

emailResult
John@ACME.COMacme.com
" sarah@Startup.IO "startup.io

Categorize leads by multiple criteria

IF(AND(revenue > 500000, employee_count > 200), "Enterprise",
  IF(AND(revenue > 100000, employee_count > 50), "Mid-Market", "SMB"))

What it does: Assigns a segment label based on both revenue and team size thresholds.

This table scrolls sideways on small screens.

revenueemployee_countResult
800000350Enterprise
25000080Mid-Market
5000015SMB

Build a personalized greeting

CONCAT("Hi ", first_name, ", I noticed ", company_name, " is growing in ", industry, ".")

What it does: Creates a personalized outreach opening line from your table data.

This table scrolls sideways on small screens.

first_namecompany_nameindustryResult
SarahAcme CorpSaaSHi Sarah, I noticed Acme Corp is growing in SaaS.

Find the best available contact method

IF(COALESCE(mobile_phone, "") != "", "Call Mobile",
  IF(COALESCE(work_email, "") != "", "Send Email", "No Contact Available"))

What it does: Determines the best way to reach a contact based on available data.

This table scrolls sideways on small screens.

mobile_phonework_emailResult
5551234567john@acme.comCall Mobile
sarah@acme.comSend Email
No Contact Available

Calculate and format a monthly cost

CONCAT("$", ROUND(annual_cost / 12, 2), "/month")

What it does: Converts an annual cost to monthly, rounds to two decimal places, and formats with a dollar sign.

This table scrolls sideways on small screens.

annual_costResult
15000$1250/month
8400$700/month

Score and label data quality

IF(AND(LEN(email) > 5, LEN(phone) >= 10, company != ""), "Complete",
  IF(OR(email != "", phone != ""), "Partial", "Missing"))

What it does: Rates each record's data completeness based on the presence and format of key fields.

This table scrolls sideways on small screens.

emailphonecompanyResult
john@acme.com5551234567AcmeComplete
john@acme.comPartial
Missing

Quick function finder

This table scrolls sideways on small screens.

I need to...Use this function
Make a decision based on a conditionIF
Check that all conditions are metAND
Check that at least one condition is metOR
Reverse a true/false valueNOT
Get the first non-empty value from a listCOALESCE
Combine text from multiple columnsCONCAT
Count characters in a text fieldLEN
Convert text to uppercaseUPPER
Convert text to lowercaseLOWER
Remove leading and trailing spacesTRIM
Find and replace textREPLACE
Break text apart by a separatorSPLIT
Extract a fixed-length portion of textSUBSTRING
Get everything after a separatorAFTER
Check if text contains a keywordINCLUDES
Get the absolute value of a numberABS
Find the smallest numberMIN
Find the largest numberMAX
Round to a specific number of decimalsROUND
Always round downFLOOR
Always round upCEIL

Next steps