Auto-Populating Field Based On Multiple Selections
I currently have a Smartsheet form that allows users to select multiple options:
Each option corresponds to a specific contact name:
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).
Help Article Resources
Check out the Formula Handbook template!