Help

Combining 2 Columns with Text

2624 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Stacy_Carlson
6 - Interface Innovator
6 - Interface Innovator

I have a column (%) that has a number. Example 20%
I have a column that has a pre-header text (short text) Example: the perfect fit to your budget software
I have a column that has a lookup for Product Featured Example: Airtable

From these, I want to create the title for my email campaign.

Save {Amount Off} on {Pre-Header} with {Product Featured}

It would look like:

Save 20% on the perfect fit to your budget software with Airtable

How do I put this into a formula?

2 Replies 2
AlliAlosa
10 - Mercury
10 - Mercury

Use the following formula:

"Save " & {Amount Off} & " on the " & {Pre-Header} & " with " & {Product Featured}

Thank you. That worked!