Query with AND & OR

AppSheet AppSheet Q&A
, , ,
1

Hello to all

I am looking for a way to solve the following problem:
I need to be able to use AND and OR in the same query.

This is the query I have so far:

AND([Client] = ‘client1’,[validation] = true,YEAR([date_Searched]) = YEAR(TODAY()))

I need to be able to select multiple clients not just one.

AND([validation] = true,YEAR([date_Searched]) = YEAR(TODAY())
OR [client] = ‘client1’,‘client2’,‘client3’)

A solution something like this.

2 
AND(
 [validation], // IF it's a Y/N field aka boolean you don't need to compare to true
 YEAR([date_Searched]) = YEAR(TODAY()),
 IN(
  [client],
  LIST(
   "client1",
   "client2",
   "client3"
  )
 )
)

IN() | AppSheet Help Center

1 Like