Two Views in AND() Expression

[Tameron]

Hi, I have an expression to make a dropdown column (NUMBER) adjust values in the "Suggested values" based on  two view (Master/Data Entry). (It ignores any row that has "-" in the INFO column.). I figured out how to make it work for one view but how do I make this expression include two different views? I looked up the AND() Appsheet info but I still missing something.

AND(SELECT(Master[NUMBER], and(ISNOTBLANK([NUMBER]), [INFO]<>"-")),

SELECT(Data Entry[NUMBER], and(ISNOTBLANK([ NUMBER]), [INFO]<>"-")))

[SkrOYC · Accepted solution]

Remove AND completely because that's not the way you use it.
Instead just use a list addition.

First Select() + Second Select(), that's it

AND() - AppSheet Help
Combine lists - AppSheet Help

[Tameron]

I get it now! I didn't even consider using + . Still wrapping my old brain around expressions but I'm starting to see it. Thank you!

[Lynn]

Hi @Tameron 

Have you checked out CONTEXT view?