Form Data

VKT555

Hello totally new user to Smartsheet and need help on creating a form. I have looked at the posts but haven't found the answer, please help.

1) I need to create a form that will be filled by users to sign-up for different games. On the form my first drop down is Venue and that's the easy part, however when they select the Venue I need to show only the games that are happening at the specific Venue. Please guide me.

2) If the user selects more than one game then I want to create two different rows in the smartsheet, is that possible?

TIA

Andrée Starå

Hi @VKT555

I hope you're well and safe!

1. You could use the form logic feature combined with so-called helper columns to select the venue, and then a column with the different games would show.
2. I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.

Make sense?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @VKT555

I hope you're well and safe!

1. You could use the form logic feature combined with so-called helper columns to select the venue, and then a column with the different games would show.
2. I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.

Make sense?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

VKT555

Thanks for your advise, I am trying with the helper columns and so it seems to be working.

Andrée Starå

@VKT555

Excellent!

You're more than welcome!