It would be great feature if one form could be used to fill in multiple lines/rows on a sheet. This would be super useful for my team.
As of now, form entries can only create singular row entries on sheets.
This seems to be a common discussion from the past but maybe there's a workaround now. I would like to be able to create a request form that allows the user to request multiple items in one form and have it translate over to sheets in separate rows while maintaining the main details.
Example: Part #1 of the form includes the requestor name, email, cost centers, project codes, ship to, etc. Part #2 of the form includes requested items - description, part numbers, quantity. Can vary from one item to multiple.
It would be great to be able to have it transfer to sheets as separate rows maintaining the info from part #1 with each requested item from part #2 as separate rows. The user currently has to submit a form for each item they request which is very time consuming. Surprised this is not an option.
Forms need to be able to generate multiple rows based on the information inputed.
For example: I work in a laboratory and I create a number of "plates" for each project. Each plate has identical information except for a few columns which can be altered manually. If I'm going to create eight plates, there needs to be an optional section on the form that causes it to generate eight entries rather than submitting eight forms. I can do this with a few lines of code in excel, it will take very little effort to implement.
It would be just as helpful if a user could choose after submission to "Submit another response" that way they don't have to go back to the original link, they could stay in smartsheet and submit over and over again?
This is currently possible! 🙂
In the Form Settings, you can have the form "reload" after it's been submitted so they can stay on the same page and submit the form multiple times.
Here's more information: Manage Form Display and Submission Options
@Genevieve P. Thank you! I'm on it!
We use Smartsheet to create class schedules - some courses have 20 classes that need to be scheduled - it would be great if all 20 classes could be created with the same form submission, thereby creating 20 rows in the collecting sheet. Right now, we have to use sheets for data entry so that we can see the entire schedule for one "course block". It makes for much more work on the back end.
Hi Carrie, can you provide more context on this issue so that someone can suggest a solution?
Do you want the form to be used by the teacher or the student? Are the classes already scheduled and then just need to be chosen?
Hi @Carrie Barnett
I hope you're well and safe!
I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.
Would that help/work?
I hope that helps!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Hi @AEForrest - sorry for the delay in my response, and thanks for giving it some thought! We work with a few outside partners that schedule our classes using their "instructors" (teachers) and locations. The form would be used by our partners' schedulers to tell us the date, time, location, and instructor for each session within a course block. One course block has 20 sessions, each of which results in its own row in the collective "main class schedule" which is then published (connected to another system) for learners to enroll in the course block or individual sessions. Where I'm trying to get to is that our partners submit one form that creates 20 rows in the receiving sheet. Let me know if that doesn't make sense.
Hi @Andrée Starå , sorry for my delayed response - I appreciate your thoughts on this. I am trying to get the schedule for all 20 classes on one form submission, so that it creates 20 rows in the receiving sheet that can then be ushered through the approval process.
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
It would be great to be able to select a workspace as the template source folder while setting up a blueprint in Control Center. Currently you have to select a folder in a specific workspace. This change would eliminate the initial folder created at the workspace level, and would allow the end user to have all the template…
Currently, when cell links are created, the updates have to originate from the source cell, and then propagate through the subsequent links. Particularly in a Control Center setup, you can have 3 or more sheets that link (from the intake sheet, to a metadata sheet and then to the project plan, is one example). As an…
Currently, if you set up a sync between Smartsheet and Resource Management, you can only detach the integration from the Smartsheet side. I have an instance whereby the Smartsheet project has been deleted and can no longer be restored. In Resource Management, the corresponding project still shows a link to Smartsheet (if…
©2023. All Rights Reserved Smartsheet Inc.