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

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.

Preparation

Accepted answers

Emil_Kos

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')

All comments

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.

Filter.yxmd

afv2688

Hello @Adityasa ,

How about this:

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

Regards

Filter.yxmd

Emil_Kos

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')

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703