Formula ifs

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

0 2 441
  • UX
2 REPLIES 2

Steve
Platinum 4
Platinum 4

What do you need from us?

I would like a hand to modify the formula above

Top Labels in this Space