Hi everyone
I have this formula in a security filter,
AND(CONTAINS(IFS( [UserSelect]=โRampa 1โ , LEFT([RAMPA],FIND("/",[RAMPA])-1), [UserSelect]=โRampa 2โ ,RIGHT([RAMPA],FIND("/",[RAMPA])+1), [UserSelect]=โBothโ , [Rampa])
, LOOKUP(USEREMAIL(),RAMPE,EMAIL,UTENTI)), OR([status]=โopenโ, [status]=โclosedโ,[status]=""))
everything works but I would like to change it:
I would like to remove โbothโ so I donโt need it and I can add more RAMP 1.2, even RAMP 3.
thank you
What do you need from us?
I would like a hand to modify the formula above
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |