Formula Field Logic

[Anonymous]

Trying to save a formula field and I am getting this message:

Cannot save rules, check to ensure that all of the choices are valid

Has this happened to anyone before?

[Devraj_Grewal]

Dolores,

Please move this discussion to Products​ as it is Marketo-specific and not a general marketing discussion.

As for your question, is the field you are trying to compute a string field? I believe formula fields can only be used to compute on string fields.

[Anonymous]

I am trying to send a communication with an IF THEN logic.

The logic goes like this:

IF FIELD A = VALUE1 then "TEXT" AND IF FIELD B = VALUE2 then TEXT, ELSE "TEXT"

I may not be using the correct tools to do this. Not sure if formula is the correct way to go here.

[Grégoire_Miche2]

You can do this with formula fields, but you could also use a script token, or even a simple choice in a flow step.

Again, provide a screenshot of your formula field definition, so that we can help you.

-Greg

[Anonymous]

Hey Dolores!

were you able to solve this issue?

I am trying to do the same thing with the formula custom field.

I want the sender name and email address to be different depending on the country... Do you have any idea how can I program this with formula field?

Thanks!

[SanfordWhiteman]

This is going to be more sensible with a Velocity (Email Script) token.

[Grégoire_Miche2]

Hi Dolore,

Devraj is right it works for string fields only. And also about moving the question to Products.

But if you can provide screenshots, we might be able to help you more.

-Greg