If there are multiple batch numbers, how can I make that go to different rows instead of columns?


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.


  • Austin Smith
    Austin Smith ✭✭✭✭✭

    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?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    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!


    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!


    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.

  • tchav
    tchav ✭✭✭✭

    @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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!