Skip to main content

Combining 2 Columns with Text

  • January 17, 2019
  • 2 replies
  • 59 views
S

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?

    This topic has been closed for replies.

    2 replies

    A
    Forum|alt.badge.img+19
    • AlliAlosa
    • Inspiring
    • January 17, 2019

    Use the following formula:

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

      S
      • Stacy_Carlson
      • Author
      • Known Participant
      • January 22, 2019

      Use the following formula:

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


      Thank you. That worked!

      Terms & ConditionsAccessibility statement