Solved: Multiple conditions to get a pre-defined result - Page 2

Wee_Chin_Lim · 04-21-2021 02:22 AM

Hi All,

I have three columns here, Objective (Enum), Verticals (EnumList) and Sub Programme (Text).

If i wish to have Sub Programme to have a pre-defined result D, when Objective = A and Verticals = B and Verticals = C, is there any way for me to go about doing this?

Aurelien

You are on the good way

The first input of each pair must be a condition, and that means you can include as many AND, OR, IF, etc as you want in it.
These are evaluated in a sequential way, which means the first condition that returns a Yes will stop the evaluation and give the result.
In your case, because you had first the condition [Objective] = “Monetization” to return Yes, then the following condition is not evaluated.
You may want to evaluate double conditions, so you should use the AND operator.

Try something like this:

IFS(
   AND([Objective]="Monetization",
       IN(“Creator”,[Verticals])
   ), 
   “Brand Jam”,

   AND([Objective]="Monetization",
         IN(“Musics”,[Verticals])
   ), 
   “Monetization Workshop”,

   otherCondition,
   “otherResult”
)

View solution in original post