Creating a Customer Form with multiple selections without having to create 70 columns.


I'm creating a form that will be sent to our customer base, which allows them to select their franchise, which will auto populate their list of stores to select from. I am trying to do so without having to create 70 different columns. I've previously created items similar to this with the vlookup tool and another grid, however as there is 300+ options, I didn't want to do it from a bottom-up perspective. Secondly, when the customer fills out their form, is there a way to populate the selections in separate rows, or will I be stuck having to format after the fact?

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!