Assign contact to row based on reference sheet


Hi there,

Is it possible to assign one or multiple contacts to a row based on a reference sheet?


Reference Sheet

Topic Staff in Charge

A John

B George

C Henry

Target sheet

Topic Staff in charge

A -> pulled from Reference sheet

A ...



I tried multiple formulas (Vlookup, JOIN(INDEX(COLLECT())), ...) but each time, the cell is populated as text instead of giving me a contact. I need this to build a smartview with the right permissions.

Thanks for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!