How can I split info from cells to rows?
I have a sheet set up that is populated by a form. The form will have 2 questions where the user can select multiple options. When that info is captured on a sheet, how can I set the sheet up to parse the multiple pieces of info in each cell to an individual row?
The information comes in from the form like this.
And I want it to be split like this.
Best Answer
-
I would suggest setting up the form to reload after submission and then have your people enter each person and all of their sessions for a single form submission.
Answers
-
Hello @MarthaP,
I was only reading about this topic last night and found this post by @Paul Newcome which explains a way to do this really well with lots of detail and with core product features.
I have yet to practice this myself and so I sadly have nothing else to offer except the link to this great post and maybe Paul Newcome can help you out next time he is online.
@Paul Newcome - I hope you are ok with me sharing the link on your behalf 😊
-
@Protonspounge No worries. Always happy to help when I can.
@MarthaP The above link is a good starting point, but it will definitely require some modification to work for your case. The second field being a multi-select dropdown makes this process much easier because of consistent formatting, but what about that first field. Can you guarantee that it will always be a semi-colon and a space between the names? What is the greatest number of rows that would need to be created from a single entry? For example, your screenshot shows two names and three sessions for a total of 6 rows. What is the maximum number of names and the maximum number of sessions?
-
Thank you @Paul Newcome ! Let me ask this, is there a better way to set up a form in Smartsheet that will allow me to receive info regarding multiple people that will need to be added to a variety of sessions?
-
How many different sessions do you have and how many different people do you have?
-
We'll have 30 sessions, and roughly 200 people.
-
I would suggest setting up the form to reload after submission and then have your people enter each person and all of their sessions for a single form submission.
-
@Paul Newcome Can you provide some assistance in how to format this with multi-select drop down? I'm having a similar situation and I'm thinking of having people enter into a multi-select field with numbers and separate each with "enter" as they enter multiple numbers so it'll drop into the intake sheet the same way each time.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives