Jan 17, 2019 12:48 PM
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?
Jan 17, 2019 12:53 PM
Use the following formula:
"Save " & {Amount Off} & " on the " & {Pre-Header} & " with " & {Product Featured}
Jan 22, 2019 10:19 AM
Thank you. That worked!