How to make specific person from a department a contact automatically

Hello all! I have a question where I am not understanding the total scope of formulas and functions and would like help to see what could assist me. I am a Customer Success Manager and I create projects for my customers that are onboarding. What im trying to do is somehow label certain people who are the CSM, Sales, Hardware, etc and be able to add them as the internal contact for every cell that has that department on it. Attached is an example if I didnt explain it well.

You can see above that under internal owner, I am labeled at the top as the CSM but im wanting that to also populate in the cells below if possible.

Best Answer


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Jonathan,

    You’d use a VLOOKUP or an INDEX/MATCH combination for that.

    You can keep it in the same sheet or have it in another sheet.

    More info:




    Would that work?

    I hope that helps!

    Have a fantastic weekend!


    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!


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

    W: | E:[email protected] | 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!