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.
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"
)
)
)
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |