Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

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 87
1 REPLY 1
Top Labels in this Space