Auto-Populating Field Based On Multiple Selections

Benjamin O'Leary
Benjamin O'Leary โœญโœญโœญ

Hello,

I currently have a Smartsheet form that allows users to select multiple options:

image.png

Each option corresponds to a specific contact name:

image.png

I need to come up with a formula that auto-populates every contact name in one row based on the choices the user selects on the form. I figured out a way to do so when they only select one option, but we need to have users select multiple options (there are over fifty options to choose from).

Tags:
ยซ1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!