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.
Solved! Go to Solution.
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.
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')