Hello can you help me with this expression? A...

expressions
(francesco cannone) #1

Hello can you help me with this expression? AND (CONTAINS (IFS ([UserSelect] = “Ramp 1”, LEFT ([RAMPA], FIND ("/", [RAMPA]) - 1), [UserSelect] = “Ramp 2”, RIGHT ([RAMPA], FIND ("/", [RAMPA]) + 1), [UserSelect] = “Both”, [Ramp]) , LOOKUP (USEREMAIL (), RAMPE, EMAIL, USERS)), ISnotBLANK ([flight]))

I would like to add a third name Ramp 3

for now it only works with 2 names thanks!!

(Suvrutt Gurjar) #2

Hi @francesco_cannone, I believe,

the expression will be something like below. May need minor adjustments.

Please note "Both"is replaced by “All”.

Not sure what is [Ramp] column as your older post thread is unavailable, when you had posted this same query for two names in [Rampa] column. Please take care of that aspect.

AND (CONTAINS (IFS ([UserSelect] = “Ramp 1”, INDEX(SPLIT([Rampa],”/”),1) , [UserSelect] = “Ramp 2”, INDEX(SPLIT([Rampa],”/”),2) , [UserSelect] = “Ramp 3”, INDEX(SPLIT([Rampa],”/”),3) , [UserSelect] = “All”, [Ramp]) , LOOKUP (USEREMAIL (), RAMPE, EMAIL, USERS)), ISnotBLANK ([flight]))

Hope this helps.

(francesco cannone) #3

@Suvrutt_Gurjar

it works great !! thanks as always