How to get multiple result for IF() function in appsheet

AppSheet AppSheet Q&A
1

Hi,

I have column 1 with enum list with only four options ($, €, TL, rub). I see them as buttons in the app. I have another column 2 with YES/NO options (also buttons). When I choose YES, I need only one button to be shown from this list: TL. If I choose NO button, I need all four variants to be shown (as buttons).

I tried IF([POS?]=YES,“TL”, LIST(“$”,“€”, “TL”, “RUB”)) thinking that if it is a NO option, then there will be a list shown as buttons. But it doesn’t work this way.

How can I manage this issue? Thanks in advance

2

In the Valid_if of the enumlist field, please try

IFS([POS?], LIST( “TL”) ,NOT([POS?]), LIST(“$”,“€”, “TL”, “RUB”))

2 Likes
3

Thank you very much for a fast reply! It works as I need! :slightly_smiling_face:

2 Likes