Formulas

Generate formula with AI

To generate a formula with AI:

1. Enter your formula instructions. Type / to insert a column reference.
2. Click Generate formula to create your AI formula

AI formula generator examples

Here are examples of formulas you can create with the formula generator:

1. Extract the domain from {{Email}}
2. Use {{LinkedIn URL}} if available; otherwise use {{LinkedIn Profile}}.url
3. Extract the text after @ in {{Twitter Handle}}
4. Split {{city}} by comma, keep everything before the first comma, remove "Area" if present, then add quotes
5. Extract the first word from {{Column_1}}, combine with {{Column_2}}, then remove all non-letter characters
6. Calculate the number of days between {{Created Date}} and {{Closed Date}}

FAQs

Can I create or change my formula without running it?

Yes! When editing a formula, you'll see the option to Save and don't run enrichments.

Clicking this prevents your formula from running on any enrichment columns that would cost credits. These columns will appear greyed out to indicate they're out of date.