Sign in to submit new ideas and vote
Get Started

Multiple Line Entries with one Form Submission

13»

Comments

  • I also need this for creating a Mileage Reimbursement form that allows users to enter a month's worth of trips. Currently we use another solution but wanted to migrate it to Smart Sheet. The other solution uses arrays so you can fill out the trip information, then add a new row for each trip until the end then Submit. It also does the calculations for the entire form, which then is automatically sent to Accounts Payable.

    The same thing for Petty Cash, with rows for each expense item.

  • nbers
    nbers ✭✭

    I have needed a feature like this many times. I want sites to be able to report fieldtrips and I don't want them to have to submit multiple forms in which they will have to enter their contact info and site many times.

  • nbers
    nbers ✭✭

    We need a form feature in which multiple lines can be created by one form. For example, I work for a large school district and we need to collect fieldtrip information from 150+ schools. Some schools might have 1 trip and some might have a dozen. I want an admin to be able to enter all trips on one form - entering a form 10 times means entering contact info and site info 10x.

    In the above example it would ideal for single form entry to translate into 10 line items on a smartsheet grid.

    Thanks!

  • This would be very useful in a number of use cases for my organization, some of which include:

    • Submitting a request for a new contract where we would list the main contract details (vendor, term, etc) and several lines indicating funding amounts and coding for each year
    • Submitting requests for new coding to be added to our financial system (we currently use a Smartsheet form to capture the submission, but have to attach an Excel sheet listing all the coding requests, then process those outside Smartsheet)
  • JSKemp
    JSKemp ✭✭

    Here we are in February 2025, and I am reading through all of the above comments and want to add my request for such a form. Currently we are using EXCEL. The client completes the form and submits via email. Ideally, if SS developed an application where we could have one form that has the ability to populate multiple lines of data would be fantastic. Like the other posts, it is too cumbersome to have clients submit multiple forms, or have to hit a back button, or have the form reopen after submission.

    Is there any update on when SS may have a solution to this request (from what I have read as far back as Jan 2021).

    SS please do your magic and help with a solution!

  • maineL
    maineL ✭✭✭

    I have this question as well. Had to revert to Excel.

    I have a form for occupants that utilize a room in a specific building (6 different buildings). Each occupant needs to have a percentage entered of time spent in the room (many, many rooms) and into 1 of 7 categories, which then need to total up to 100% for the room.

    Right now, I have it set up with an option to "add another user" checkbox and then it will load the same previous information for input. Using this form, all additional users end up on the same line when it imports into the Worksheet. I need to have each occupant on their own line.

    I wonder if there's a more efficient way.

    Thank you! Lori

  • This feature has huge potential and massive application across specialties. I would love to use this as a lab inventory entry form. But the application could be universal. The user would enter the form for the lab item (kit name), kit details, and then the quantity of the kit. For example, lets say they had a quantity of 10 kits in this use case they would be able to use this feature to enter the form ONCE and have ten rows entered for the kit. The reason it is needed to have 10 rows is that each kit will need their own "status" line of available, expired, and used. Once the status changes from available they will be removed from the available inventory environment via an automation. Please create this feature! :)

  • Andrée Starå
    Andrée Starå Community Champion
    edited 05/08/25

    Hi,

    I hope you're well and safe!

    Having that feature in the form would be fantastic.

    In the meantime, developing a solution using the Conditional Logic and a clever formula structure or a helper sheet would be possible.

    I hope that helps!

    Be safe, and have a fantastic day!

    Best,

    Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

    Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!

    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.