Is there a way to add multiple filters and join them by AND in google sheets node

Questions
,
1

Describe the problem/error/question

I have 2 columns (domains and status) , domains containing websites of companies and a status column having values loading/NA/done. I am getting a domain id from an api , lets say x. I want to select the row whose domains column = x and status = “NA” . Basically selecting a row satisfying both the conditions. Every time I add multiple filters , its doing OR operation instead of AND.

4

Hi @Shiv_Jyoti_Garai :wave: Sorry to hear you’re running into this!

Could you share an example workflow of what you’re trying to do, and what you’ve tried so far? That might help!