Are updates allowed? Formula Issues

Im trying to set an expression to limit permission for users & admin

I set the following expression:

IFS(IN(Useremail(), MAIL[MAIL CUADRILLA]),“ADDS_AND_UPDATES”, IN(Useremail(), Supervisores[Email]),“READ_ONLY”,),
,“READ_ONLY”

3X_a_1_a1bb4e37552d2adaca252df0d8c2ad0965d8d03b.png

the problem is when i try to make an “ADD” with a [MAIL CUADRILLA] email that has “ADDS_AND_UPDATES_” allowed.

I get the following error.

idk why, maybe the expression is not compatible?

I try with a “SWITCH” expression and i receive another issue…

ie:

SWITCH(USEREMAIL(),
user1@mydomain.com”, “UPDATES_ONLY”,
user2@mydomain.com”, “ALL_CHANGES”,
“READ_ONLY”)

when i make the test the only rule applies is the “READ_ONLY” all the others permissions i set just getting ignore by the app.

Maybe im doing something wrong? I follow some post about this… but i cant find the solution.

Idk why expression is the best to set permissions in the “Updates allowed” section.

Solved Solved
0 5 312
1 ACCEPTED SOLUTION

I agree! Just got to get that expression working.

View solution in original post

5 REPLIES 5
Top Labels in this Space