HI im new with appsheets and im having trouble referencing values in an ongoing form that im editing. I know I can hide a form field based on certain values by leveragin the 'Show_If' of each field you want to hide or show, but I cant figure out (or find) how do I reference a value from a EnumList in the context of a Form. So far Ive tried these formulas (on the Show_If of the fields):
IF([App]="MOVING",FALSE,TRUE)
IF([App]=MOVING,FALSE,TRUE)
They dont work and I get the error that "I cannot compare List with Text". Now I know how to reference values that already exist in the database but how do I reference an EnumList value(s) for the current item im creating in a Form?
Thank you.
Solved! Go to Solution.
Thanks for the reply @sandeepraon . I just couldnt make it work with Select() is still very confusing for me but I randomly came with a solution by isolating the value I wanted first with a List() function on the EnumList ([App]) and then converting the result value to Text with an IF statement. So in the Show If of several columns I did:
IF(TEXT(LIST([App]))= "Moving", false, true))
User | Count |
---|---|
24 | |
14 | |
4 | |
3 | |
3 |