Contact Formatted Cell --> Autopopulate Info into another cell.

How can I get a cell that is formatted as a Contact List to populate a cell to the right with a phone number, email, or other static attribute when a select different contacts?

Our assigned to items can change quite frequently, and it would be great to autocomplete contact info in the next cell automatically.



  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 12/20/19


    How many different people can there be in the assigned to?

    There are a few different options.

    • Add the information to a multi IF formula per each cell
    • Add the information together in one cell collected from a few so-called helper columns
    • Add a directory on the sheet or on another sheet that you can use to look up the information with the help of VLOOKUP or INDEX/MATCH.

    Which method would you prefer?

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too,

    I hope that helps!

    Have a fantastic weekend & Happy Holidays!


    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD


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

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!