If there are multiple batch numbers, how can I make that go to different rows instead of columns?
Hello,
I am trying to create a form that allows you to enter in when you receive different batches. Sometimes we receive multiple batch numbers at once. Is there a way to make it so that if multiple batch numbers are chosen that all the data will copy to another row instead of another column within the same row?
Right now I am having them fill out the form multiple times for every single batch number, it is a little mundane and taking up too much time.
Answers
-
The simple answer to your question is no, one form = one row, and automations aren't robust enough to segregate data like that.
Would it be possible to just have multiple batch numbers per row (separate cells for each) and have whatever you're using to sort the data on the back-end use nested if, vlookup formulae to find things based on batch numbers.
Are the batch numbers part of a series, or random? How many characters?
If not, can you submit a screenshot that shows how much data you're working with?
-
Hi @tchav
I hope you're well and safe!
I've developed similar solutions for clients, and it's pretty advanced, but it's possible.
Can there be multiple submissions at the same time?
Be safe, and have a fantastic weekend!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå yes there can be multiple submissions at the same time. Normally there will be 5-10 people using the form at once.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!