Is there anything wrong in this statement. I am using this in Slice to filter out Rows when both condiions are TRUE. Status is ENUMLIST.
AND([Route] = โYelahankaโ, ANY( [Status]) = โWonโ)
This conditon is not working for me.
Note that in AppSheet, if the left-side operand value of an is-equal-to (=) or is-not-equal-to (<>) operator is blank, the expression will be TRUE regardless of the right-side operand.
In your expression, if [Route]
is blank, [Route] = โYelahankaโ
is TRUE; likewise, if [Status]
is blank, ANY( [Status]) = โWonโ
is TRUE.
The simplest way to avoid this behavior is to put the non-blank value on the left side:
AND(โYelahankaโ = [Route], โWonโ = ANY( [Status]))
thanks will try didnt know the " " values can be placed in left of = sign.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |