Slice to show only users sharing a project

I have an application for managing projects with a Users table and a Projects table.

Each user can be linked to different projects. The project table therefore contains a column [Users] which lists the users and a column [Owner] which contains only the email of a single user.

Now I'm trying to create a slice so the user can only see users they share projects with. I use this function:

 

OR(
 [Email]=USEREMAIL(),
 CONTAINS([Projects][Users],[Email]),
 [Projects][Owner] = [Email]
)

 

I tried this too :

 

OR(
 [Email]=USEREMAIL(),
 CONTAINS([Projects][Users],[Email]),
 CONTAINS([Projects][Owner],[Email])
)

 

The condition in line 4 does not work. The working [Users] column is of type EnumList and the [Owner] column is of type Ref.

Any Idea ?

0 1 64
1 REPLY 1

Vielleicht ist die Lösung in diesem Thread enthalten: Nur Benutzere-Mail-Adresse anzeigen mit 2 Bedingungen 

Top Labels in this Space