Unique list from many lists for data validity

AppSheet AppSheet Q&A
1

Hi, I’m not really good at this, and whatever I’ve tried doesn’t seem to have worked so far. I’m trying to make a unique list or an OR() list from a few SELECT() generated lists in a data validity expression. This is what I’m trying to combine.

SELECT(table1[Name], [Name]<>[_thisrow].[Sender]),
SELECT(table1[Name], [Supervisor]=[_thisrow].[Sender]),
SELECT(table1[Manager], [Name]=[_thisrow].[Sender])

Each of these work individually, but I can’t figure out how to put them together.

Any insight would be appreciated

2

SELECT( … ) + SELECT( … ) + SELECT( … )

List Addition | AppSheet Help Center

2 Likes
3

I don’t believe this, spent 2 hours trying to figure it out and the answer was so simple! Thanks! @Joseph_Seddik

2 Likes