Auto populating Rows based on the number in the Qty box


Hi. Is it possible to auto populate rows based on the number I have in my QTY cell?

I want when I enter a 3 in the QTY cell it automatically copies and adds those three lines. I need each of the in this case branding # to have their own lines and I do not want to have to put in all this data. Sometimes we have up to 100 or more branding plates. I only need the branding plate # to be copied on the lines though if that makes it easier. I hope this makes sense. I have taken a screen shot of what I am meaning below. Or could this be possible by using one of those integration apps like ZAP? I have tried to make this work with ZAP but I couldn't get it to. I think I just don't know how to phase what I am needing to their AI properly. Maybe someone could help with that as well? All help is greatly appreciated!


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 04/24/24

    Hi @Sarah Laing

    I hope you're well and safe!

    I recently developed something similar for a client to have rows created depending on the number of days.

    It's a pretty advanced solution.

    Do you have a budget for hiring a consultant to help?

    I hope that helps!

    Be safe, and have a fantastic week!


    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: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Sarah Laing

    Hi @Andrée Starå Unfortunately, I do not believe I would have a budget to hire a consultant. I wish! Thanks for you feedback though. I feel like this will end up not being something I can complete as a full automation on my own. I have a system now that is a function I have to copy and paste every time. SO I guess that will have to do.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!