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 ?
Vielleicht ist die Lรถsung in diesem Thread enthalten: Nur Benutzere-Mail-Adresse anzeigen mit 2 Bedingungen
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |