Create and Use a Concatenated String (Formula) Field

You can combine values from multiple fields or build a conditional value using a Marketo Formula field.

  1. Go to Admin and click Field Management.

  2. Click New Custom Field.

  3. Select Formula for the Type.

  4. Enter a Name for your field then click Create.

  5. Find and select your formula field then click Edit Rules.

  6. Add two choices and define them like the screenshot below.

    TIP

    Learn more about tokens for flow steps.

  7. Now you can add the formula field as a token in an email.

NOTE

Formula fields can be used in landing pages, emails and smart list columns (they are not exported). Emails with formula fields can not be sent using a batch campaign. Please use an email script token in this scenario.

Good work! Now you have a smart field that knows what salutation to include based on gender. Have fun with this and get creative.

On this page