Show_If Conditions

[Jerome_Canete]

HI Appsheet, a beginner here. I’m having trouble with the show_if function not fully working.

I have column A with enumlist with list for example “one”, “two”, “three”, “four”, “five”, “six”, & “none”.
Now i want column B to show only if 1 or any 2 or more of the choices in column A are selected except the choice “none”.

I did this condition but seems not working right:
CONTAINS([A],ANY({one,two,three,four,five,six,}))

Thanks in advance for any help.

[Suvrutt_Gurjar · Accepted solution]

Hi @Jerome_Canete,

Welcome to AppSheet.

Please try an expression something like below in the show_if of Column B

AND(COUNT([A])>0, NOT(IN(“None”,[A])))

Please take a look at following articles, just in case you have not

help.appsheet.com

COUNT()

Number of list items

help.appsheet.com

IN()

Is item in list?

[Jerome_Canete]

Worked like a charm, Thank you for the big help @Suvrutt_Gurjar.