Using filter for: Condition X and (Condition Y or Condition Z)

[Adityasa]

Hi All,

I am trying to write a custom formula in the filter tool for the following requirement: 

If Column A = "Apple" AND (Column B = "Ball" OR Column B = "Cat")

So, if column A has Apple written, and Column B has either Ball or Cat, I want those rows to flow through the True node in the filter. What should be the formula for this?

Thanks.

[Emil_Kos]

Hi @Adityasa,

The filter tool should have this formula:

[Column A] = "Apple" AND ([Column B] = 'Ball' OR [Column C] = 'Cat')

I have created a workflow for you. 

[afv2688]

Hello @Adityasa ,

How about this:

[Column A] = "Apple" AND [Column B] IN ('Ball','Cat')

Regards

[Emil_Kos · Accepted solution]

Hi @afv2688,

My mistake as I was thinking that it should look into Column B or C my bad. Instead of:

[Column A] = "Apple" AND ([Column B] = 'Ball' OR [Column C] = 'Cat')

you can also go with:

[Column A] = "Apple" AND ([Column B] = 'Ball' OR [Column B] = 'Cat')