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

acullums

Hi,

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!

Andrée Starå

Hi @acullums

I hope you're well and safe!

Here's a possible workaround or workarounds

• Using a sheet instead and maybe cross-sheet formulas to populate the stores and similar.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

acullums

Hi Andree ,

I hope you are also well!

Would I be creating a separate sheet with a VLOOKUP for each 'Franchise', or one sheet with all listed?

The issue I'm running into when using the Vlookup tool is that some Franchises have several stores, when I use the cross sheet reference, it only populates the first store for that franchise. I'm not sure what other Formula I could use so when you select a Franchise it only populates their stores, and can be added to a form.

Paul H

@acullums

Sounds like you are looking for a Join/Collect formula

https://help.smartsheet.com/articles/2482647-cross-sheet-formula-combinations