SELECT() with multiple conditions

AppSheet AppSheet Q&A
1

Hi,

I am looking for an expression to get a list selection with multiple conditions.
I tried to write a SELECT() function wich take into account two conditions, but it does not work, like SELECT(myTable, condition1 and condition2, FALSE)

How can i get this kind of table ?

Thanks

2 Likes
2

Hi

Use AND() function for multiple conditions

SELECT ( MyTable[DesiredColumn], AND ( [Column1]=“Something”, [Column2]=“Other” ) )

13 Likes
3

Great ! Thanks a lot, it works perfectly. Have a nice day