Index Match issue on Contact column

Jennifer Mahoney · 07/09/21

My index match fx (in the left destination sheet) is populating with names found in the match but they're not functioning as contacts when linked in- how would I do this properly?

Andrée Starå · 07/09/21

Hi @Jennifer Mahoney

I hope you're well and safe!

Make sure that the Contact Columns match as well to if it's a single or multi-select column.

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bassam Khalil · 07/09/21

Hi @Jennifer Mahoney

Hope you are fine, in the left destination sheet please check the column type if it's "Contact List"

Jennifer Mahoney · 07/09/21

@Bassam Khalil yes it is a Contact List type column

Andrée Starå · 07/09/21

Hi @Jennifer Mahoney

I hope you're well and safe!

Make sure that the Contact Columns match as well to if it's a single or multi-select column.

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jennifer Mahoney · 07/09/21

That was the issue, one column was multi and the other was not !! Thank you

Andrée Starå · 07/10/21

@Jennifer Mahoney

Excellent!

You're more than welcome!

Paul Willman · 08/04/22

I am running into a similar issue. The INDEX range and MATCH values are both contact list types with single select only, which appears to have resolved this issue for everyone else. The problem that I can see is that Smartsheet has converted (displays) the INDEX range for most of the contacts to a name, and a few others have been left as the email address, whereas the MATCH range is all email addresses. I would suspect that is the problem, but the issue then becomes how do I get Smartsheet to successfully match them?

Hoping to find an answer to this one.

Rebecca Ortinez · 05/25/23

https://community.smartsheet.com/discussion/comment/338723#Comment_338723

I also have this same issue. Has anyone found a solution?

Genevieve P. · 05/26/23

Hi @Rebecca Ortinez

Can you post screen captures that show your set-up and explain your intended outcome, along with your formula copy/pasted? (But please block out sensitive data)

Rebecca Ortinez · 05/26/23

Hi @Genevieve P.

I actually found a YouTube video that helped solve my problem. Smartsheet Name and Email Columns to Contact List Column - YouTube

Hopefully this can help others!

Index Match issue on Contact column

Best Answer

Answers

Help Article Resources

Categories