Multiple Line Entries with one Form Submission

Joann Pendleton

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

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

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!

J. Morrish

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

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

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