Opposite of Intersect()

BGD
Bronze 5
Bronze 5

Hello Everyone,

Below expression I am using in my Filter table column to select the Location from the table for filter purpose "sort(select(Ticket[Location],USEREMAIL()=[Entered By]))"

BGD_0-1688535435923.png

But i need to select those location too if the ticket was shared by others. This value is stored in column [Shared with others], this fields is a list of other user id to whom ticket was shared. So I want to use the union of all the location field if USEREMAIL() is equal to [Entered By] and USEREMAIL is in the list [Shared with Others]. Please help me with the expression to achieve the end result.

 

Thank You 

Bhawna Gupta

Solved Solved
0 1 669
1 ACCEPTED SOLUTION

You may want to try

UNIQUE( LIST([Entered By] )+  [Shared with Others])

Combine lists - AppSheet Help

Then expression could be

sort(select(Ticket[Location], IN(USEREMAIL(), UNIQUE( LIST([Entered By] )+  [Shared with Others]))))

 

 

View solution in original post

1 REPLY 1

You may want to try

UNIQUE( LIST([Entered By] )+  [Shared with Others])

Combine lists - AppSheet Help

Then expression could be

sort(select(Ticket[Location], IN(USEREMAIL(), UNIQUE( LIST([Entered By] )+  [Shared with Others]))))

 

 

Top Labels in this Space