Formula Field Logic

Anonymous
Not applicable

Formula Field Logic

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?

6 REPLIES 6
Devraj_Grewal
Level 10 - Champion Alumni

Re: Formula Field Logic

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
Not applicable

Re: Formula Field Logic

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
Level 10

Re: Formula Field Logic

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
Not applicable

Re: Formula Field Logic

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
Level 10 - Community Moderator

Re: Formula Field Logic

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

Grégoire_Miche2
Level 10

Re: Formula Field Logic

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