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.
Solved! Go to 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
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
Worked like a charm, Thank you for the big help @Suvrutt_Gurjar.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |