Show_if: how to combine two conditions?

AppSheet AppSheet Q&A
1

Hello,

I’m trying to have 2 conditions for a Show_if in a form.

The first has to check if “Bestemming status” = “Voorraad”
IN([Bestemming status], LIST(Voorraad))

The second one has to check if the “Product type” = LIST(Chair, table, closet)
IN([Product type], LIST(Chair, table, closet))

2

Please use

AND()

AND() - AppSheet Help

or

OR()

OR() - AppSheet Help

depending on need, something like below

AND( IN([Bestemming status], LIST(Voorraad)) ,

IN([Product type], LIST(Chair, table, closet))

)

2 Likes