Multiple conditions with enumlist

[yoroshiku]

I need to filter with these 2 conditions :
AND( [in_use] = TRUE , [storage_area] = “Bar” )

From what i understand, it doesnt work because [storage_area] is a enumlist type variable.
I have spent half my afternoon on this … can somebody help please?
Thanks !

[Steve]

Try:

AND( [in_use] = TRUE , IN( “Bar”, [storage_area] ) )

See also:

help.appsheet.com

IN()

Is item in list?

[yoroshiku]

Thank you Sir, it works.
Meanwhile, i managed to work it out this way :

AND( [in_use] = TRUE , CONTAINS([storage_area] , “Bar”) )

[Steve]

help.appsheet.com

CONTAINS()

Does text contain fragment?