Index and Match for Contacts

I am trying to auto populate contact information into a column (that has contact properties) on a sheet that is separate to the metadata sheet (that is using text/number properties). When I use a cross-reference formula from the metadata to the sheet that I want to auto populate, the contact information does not copy (it shows up as text); the only way I've found that the link is made correctly as a contact is if I do a direct cell link, but is there a formula to auto populate remaining cells in the column?

Here is my formula: =INDEX({Ad Hoc DQ Metadata Project Sum Data}, MATCH("Lead TE(s)", {Ad Hoc DQ Metadata Sum - Metadata}, 0)) and it populates the new sheet with text, even though the column that I am trying to copy in is a contact cell.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!