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!!
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |