I want fectch list using two condition in same column

AppSheet AppSheet Q&A
1

Hi

C Status
B-Supv 1
B-Scan 2
B-Bscan 2
B-Seg 1
B-Load 3
S-Seg 2
S-Load 3

In this table want to list 2 status at a time

used this code not working-- select(Atend_List[List], [Status]=1 and 2)

Example :

status 1, 2, 3

i want to dropdown status 2 and 3

can any help me in listing status 2 and 3

2

It’s unclear what you’re trying to accomplish.

One clear issue is your expression’s syntax. Review the syntax of the [AND](AppSheet function list - AppSheet Help function.

AND([Status]=1, [Status]=2)

It seems also likely that the AND function may not be what you need. Contrast the purpose of the AND and [OR](AppSheet function list - AppSheet Help functions.

OR([Status]=1, [Status]=2)
2 Likes
3

hi dbaum

thank you

select(Atend_List[List],and ([Status]<>3, [Status]<>2 ))

this syntax worked

1 Like