Unique list from many lists for data validity

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

Solved Solved
0 2 99
1 ACCEPTED SOLUTION

SELECT( ... ) + SELECT( ... ) + SELECT( ... )

List Addition | AppSheet Help Center 

View solution in original post

2 REPLIES 2

SELECT( ... ) + SELECT( ... ) + SELECT( ... )

List Addition | AppSheet Help Center 

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

 

 

Top Labels in this Space