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!!
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.
it works great !! thanks as always
User | Count |
---|---|
39 | |
29 | |
23 | |
23 | |
13 |