I have the following databases:
What I aim to achieve is that a user, with different companies assigned, can only see tasks and [projects/events] from the companies they are assigned to. (In the tasks section, the corresponding [project/events] is specified and takes the data from [Companies], and automatically (Lookup), the companies assigned to the [project/events] are populated.)
In the "slice," I am using the following formula: IN( LOOKUP( USEREMAIL(), "03. Users and roles", "Email", "Companies" ), [Companies] ) )
The issue is that when searching for the company (USEREMAIL-->Email-->Company), it results in the ID of the assigned companies, and in [Companies], it provides the names. So it always result in "False".
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |