Index/Match not pulling in Contact field. . . Read so many threads, none apply

Options

Hello all,


I am just trying to pull in contact fields for small Roster Files for events tied to an Event Master Tracker. There are columns on the event tracker that have the owner of the project/event as a contact field. I am attempting to index this field by matching the unique event identifier present in both sheets. The formula works fine except it only pulls in the party's name and not the email.

Both columns are Contact Columns, single entry, not restricted. Anyone know what's going on??

Attaching screenshots for reference:

First, what the Index/Match is pulling in... it's accurate, but missing the email address.

Second, a snip of the column settings where I want the contact pulled into.

Last, the column settings in the source sheet.

Does it have something to do with the conditional formatting on the source sheet? I can't see how that would matter but it's the only thing different between the two...

I double checked the reference and Pam Fisher is a contact with an email on the source sheet.

Thanks!

Josh

Answers

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Options

    Greetings @Josh Reed

    INDEX/Match will work for multiple contact cells, but the Column properties the formula is in must be a Contact column AND Allow Multiple contacts per cell checked. If the Multiple contacts is not checked, it will display only the name.

    From the example above, it looks like the Multiple contacts is not checked.

    I hope this helps, and let me know if you have additional questions.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • Josh Reed
    Josh Reed ✭✭✭✭✭
    Options

    @Frank S.

    huh... I guess I should have tried that. Worked immediately, changing them both to multi-select.


    I was under the impression the two columns needed to match, not that it needed to be multi-select. Any idea why that's the case? The fields I want to pull in will always be only one contact... Changing these columns, and therefore the corresponding fields on intake forms, could potentially lead to user error and not ideal. I think it's a worthy sacrifice for the direction we are going but it would be better if it did not need to be multi-select.


    Another alternative is to have another column that pulls only the email (these contact fields are for notification/approval purposes, so the email is all that is needed) out of the contact card to be used for INDEX/MATCH, but I'd rather not add additional columns as the Event Tracker is already a massive sheet needing regular archiving.


    I appreciate your time and thank you for the solve!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!