Index collect formula question

Enoch Mak

Hello I need some assistance with my index collect function,

In one cell i'd have

=IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event], [Column23]:[Column23], [Week #]@row, Email:Email, "Person 1"), 1), "")

In another cell i'd have

=IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event], [Column23]:[Column23], [Week #]@row, Email:Email, "Person 2"), 1), "")

Currently the function's 1st criteria is working fine, however the 2nd criteria checking the "email:email" column isn't pull back the all the data i need. Whenever there are multiple emails it seems to ignore the cell all together.

Any way around this with other functions i could add?

Kelly Moore

Hey @Enoch Maki

Evaluating multiselect cells require the specific functions of HAS, CONTAIN or FIND. With a multiselect- Contact field use the HAS function.

=IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event], [Column23]:[Column23], [Week #]@row, Email:Email, HAS(@cell, "Person 2")), 1), "")

Will this work for you?
Kelly