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

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.

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!

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.