Multiple contacts update

Can we multi populate contact list looking into multiple values in a drop down.

Example - if there are 2 departments in a multiple drop down list, can there respective contacts get updated in the contact cell


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!