Select () with 3 or more criteria

[Former Community Member]

I’ve followed the below thread on Select with AND configuration but can only get this to work with 2 criteria. How do you do it with 3 or more criteria?

SELECT() with multiple conditions Questions

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

I tried nesting the AND within itself but doesn’t seem to work.

[bonameblisto]

It’s simple

help.appsheet.com

AND()

Are all true?

[Former Community Member]

Thank you! And () takes more than 2 arguments. Also had to disable auto-complete.