Smartsheet form submission options multiple entries. Add an auto-number column.

Smartsheet form submission options multiple entries I have submitted from an existing and a new form, both of which do not work, I have I need to track several steps in the process of creating these Assets and report on them. It would be incredibly helpful if users could save their progress as drafts before officially submitting the form. Hi @Connie Cochran. Learn more; Smartsheet events Your hub for Smartsheet events, webinars, Q&As, and user groups. To add to Adrian's excellent advice/answer. I've developed solutions for a couple of clients that create multiple rows from one form submission. =) Would be great to have an option that allows a forms user to complete a form and then begin a new submission for that same form. If desired, those answers can be visible in the form - which makes them editable. No, there currently isn't a way of restricting specific users from filling out a Smartsheet form multiple times. We utilize Web Form option to track Support Cases. I have a sheet that has orders entries from the last 6 months. Hi there, I'm creating a form that can have multiple entries, exactly what I need for future purposes within Smartsheet: each candidate will need to submit a Candidate Application (another form in another sheet same workplace) In a third sheet, To select a single row, click its row number. After reviewing, you could leverage a column (e. Hi, I have a multi select drop down that I am using in my form. The first thing to do is set up the Form Sheet. 1 - If there are multiple Assets for each Request allow that detailed info to be entered into a form without having to repeat all the Project info. Great idea! That would be a great addition to Smartsheet features. I am watching back the ENGAGE '24 "Discover advanced automations using Bridge by Smartsheet" presentation, done by Josh Jones and Chad Eiring. When user clicks "Save and continue": email including a unique link is sent; user can access the form later to finalize submission or pass over to another user to finalize Hi @User251. If they leave that box unchecked, it will still allow them to submit the form. 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. So I would suggest, disable the "email me copy of responses", as some may not tick it, and then you @tbmwater There are ways to automate sending the update request when a user wants to request one themselves. I'm trying to recreate the solution shown in the later half of the presentation that takes a form entry, gets row, and splits it out into multiple rows/tasks nested under the original submission. Hi All - I can't seem to find a good process for this: add either a document as an attachment, or an active link, to a form that will be sent out to users (sharepoint, via teams). As to your second question, you can manually Deactivate Hi @Andrée Starå - I am also seeing this, where 2 entries into the form happen closely in time. Currently after speaking to support there is no way to validate a 24 or 12 hour time format. I have them fill out a form, which in turn fills out the order log. Hi, I have refreshed the page, removed all filters and checked both the top and bottom row, despite the form being set to add at the bottom. When I delete them, they come back when I refresh. As of now, form entries can only create singular row entries on sheets. There are dropdown fields in that form with multiple choices. Business Process Analyst 3 | C5ISR Group. Google Forms (I use it) Gravity Forms (I use it) Captain Form (I'm testing it) Drupal (this Community is using it) 4. a checkbox column "Approved to progress") to trigger a Request an Update workflow to kick off. Can the data input not start from from row 1 ? or is it because those rows 1 - 355 are being used in project tracker. Once the user starts the process the data entry is very seamless. Would that work/help? I have a form that I have been using with my team for over a year now successfully and today a user submitted an entry using the form, however when reviewing the sheet, the information feeds to no line-item entry was there. This is considered the source field for your rule. If you'd like to further limit who can If so, you can turn on the web form option to required the user be logged into Smartsheet. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from Currently there is not an option to add multiple rows directly from a form. Create a form or open an existing form. I was planning to have a form that includes EDP #1-EDP #40 on it. This discussion has been merged. To add other form elements such as a header, description, divider, or attachment, select on the element in the left Please submit an Enhancement Request when you have a moment. This sheet continues to populate as more orders Form submissions are now faster on the Smartsheet mobile app. I developed a solution using two forms (but it could be structured as a chain with more 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. a new dropdown option for the form setup, selection makes the form reload with the last entiries populated - currently either blank form, or success message (not useful) or send to a link (also not useful). New column on the main sheet that uses a COUNTIFS formula and cross sheet references to count how many times a user submits a form to receive an The issue I have is that when a new form entry is received in the contributing sheet, the "daily entry total" doesnt seem to update until the sheet is accessed and saved. Thank you. Thanks! Since the Auto-numbering takes place after/as the row is created, yes the user submitting the form would have to do one of the following (3rd option is simplest, but will only work if all users submitting on the form are Smartsheet users) 1. Hope this helps. And then on your form options (the final option while editing the form, includes a require smartsheet registration to only allow registered smartsheet users. Do you know why it would make a difference if the user chooses to have a copy of their response emailed to them? If you select an incorrect column type in your sheet or forget to add an option in a dropdown Enterprise, or Premier plan, you can build more sophisticated solutions with automated actions that copy the entire form submission over to another sheet, follow up with a For more information about Smartsheet forms, visit our Learning Center @SBuhrman You could add a checkbox field called something like "New Form Submission". . For more information, see Edit or remove fields in a form. This might help. This cause both entries to be displayed in one email to the person setup in the automated alert. It will not work to filter the data off to an alt form because I have to be able to see when they select no and hound them to get the submission approve by the POC. There are other text areas in the form as well. I tested it, and it doesn't attach to the correct primary row if two different people submit it in the same time, so you I think a useful feature could be to have the capability to generate multiple grouped rows based on one form submission. This would be super useful for my team. Those test submissions then get added into the submission count. However, the random blank rows added between form submissions (I believe) comes from the user copy & pasting text into the form which contains some sort of character that is I think the login option will help prevent issues with multiple users submitting simultaneously - or I create a form for each one, though that has different issues. Use Smartsheet forms to collect key data for a variety of different projects. Please see our Help Center article on Dynamic View for more information. The data type for this Generate child rows from form and link to a specific Parent Validate Time in Smart Sheet. If you haven't already, Please submit an Enhancement Request when you have a moment As a possible workaround, I developed a Do a global search in Smartsheet for one of the values the user submitted as recorded on her confirmation email, see if it was saved on another sheet. And then I need to learn about the workflow automation that uses the info on the first sheet to create a sheet that autofills the project info (ex columns A-D) for each item installed with the item info in columns Hello! You could create a helper column that has the form name as a dropdown list. I hope you're well and safe! This might help. List of the bins, clicking a link that opens a form with the information already added so you can update the information. 0 · Share on Facebook Share on Twitter Then when submit the new information, it will update that same, original row in the sheet. What am I missing? Can't get IF formula to work, Hi Alicia, The easiest way to accomplish what you're describing would actually be through the Premium Application, Dynamic View. Also, it is possible to create multiple rows from one form, but it can get very advanced to structure a solution. Then in your sheet, you could create filters using the helper column and form name. If you don’t have Data Shuttle, another option you could try is setting up an automation to move new form submissions to a specific sheet and then using INDEX/MATCH formulas to pull updates based on a unique ID. ) Input their E-mail address. You can adjust any form-level settings using the Settings at the top of the form builder. To avoid the no more than 3 selections limitation, you can create a form in Google Forms (very simple to do) and build the validation in there. I hope this makes sense! With both of the above options, I think I can create a dashboard tab with one chart targeting whatever data I want, be able to print them, or also pull the data into an overall dashboard that has all the charts in one smartsheet dashboard. For more information, see Manage form display and submission options. All the required fields are getting auto-populated except one, let's say, XYZ field. The one work-around we use is adding a checkbox at the bottom of the form saying the user "certifies all information is accurate" but that doesn't replace an actual signature. The first one for the main information and the second one for the rest. I even looked at building my automation from scratch and that was not an option. When the form entries are coming in, its inputting data starting at row 356 all way at the bottom. Hi @Gaurav Chauhan. If a user has multiple cases, they currently have to submit their first case then go back into the URL for the Form to enter another case. This sheet continues to populate as more orders The new field appears as an option in the Fields pane and as a new column on the underlying sheet. I’ve had form submissions add blank rows, then the next form submission will appear after these blank rows. The indicator for a new row would for that 'EDP #2' is populated. Now when you submit a form you no longer need to wait for the submission, so you can get back to what you were working on. 2. All the information for form with ID #4 goes on the same row in the associated smartsheet. Have it auto populate after submission in the sheet; Using URL query to have the values prepopulated in the form; Would any of those options work/help? I hope that helps! Recently, when the agents try to submit a form, if they select the "Send me a copy of my response" checkbox, it won't allow them to submit the form. 👇 HOW I CAN HELP YOU 👇 - Is there a way to have them enter multiple parts and descriptions and have them populate on multiple lines in the smartsheet order log? If they do have to enter a form entry for every part they want under the same work order, is there a way to program the sheet to group them together via tabulation or color coding so we know all parts go together on one? Currently we use another solution but wanted to migrate it to Smart Sheet. Background: We are currently using an Excel file with a VBScript form to update records of data. Then add a condition to the workflow example above that only runs if the "New Form Submission" field is checked. This Hi @Dale Callaway. Would that work/help? I hope that helps! Have a fantastic week & Happy New Year! Best, I have created a survey and one of the question is a multiple choices question and i would like the person who answer the survey are able to select can we allow people select multiple options in Forms? Wondering if it is possible to send notifications via Smartsheet when an event is added or updated to a Calendar in Can I create multiple form using single smart sheet? If so, can I use if condition to create 2nd form? for example, if the 1st form created and auto id is generated. The data type for this Generate child rows from form and link to a specific Parent forms setup option, retain the last entry. The VBScript form allows us to select the record to update, reads the row, presents selected data to the user and allows for data manipulation by the user. And more forms setup option, retain the last entry. Hi @SupplyChain. Hi @Greg Howell,. But when the 2 nd form is created, the information should be displayed in same row as 1st form if the value matches. Would that Does Smartsheet have any template sets to create dynamic business continuity/disaster recovery STEP 1 - Set Up the Base Form Sheet. Set the Status field as a hidden field. I want it to encompass the entire month, with the option to select multiple shift times for each day, and multiple days in a week - We currently use an excel doc which looks like this We are leveraging Smartsheet for a core business process and would like to use the functionality of a form as it simplifies the process and removes some of the technical aspects to the end user. Is there a way to delete entries once they have been applied to the Smartsheet sing the form function? Aha, so you want the Department 2 people to see Department 1's data but ONLY in the email message itself, and NOT on the Update form, correct? So the Department 2 folks have to look at the email itself while filling in the online update request form. Sherry Fox. I get the option to show a success message, redirect them to a URL or reload for another entry. Join the Community; Partners Learn about the Smartsheet partner program and access our partner directory. I'm trying to avoid duplicate entries that can be transacted through the form I created. For my purposes, when a form is completed by a client and they select multiple options in a dropdown, I'd like each of those selections to populate into a new row in the grid along with all of the single select data in the other form entries (columns). Lastly, add at the end of the workflow to uncheck the "New Form Submission" field. @Hollie Green. Basically I have put together a web form that will do a site survey of hotel rooms for renovation. In this video, I walk you through the best way I have found to create multiple line entries with one form submission in Smartsheet. Ok. I need a formula to identify the oldest entry for each location, and if there are multiple entries for the earliest date, use a "score" column identify the higher score as the next candidate in line. g. 3. Here's a possible workaround or workarounds . more. Is that an option? Think of a person repetetively submitting a form throughout the day. I want my users to have a dynamic view that loads their entries. Over the past 7 months, our team of development engineers, plus ux experts, quality assurance engineers, and product, used Smartsheet to coordinate impeccable timing with almost every other internal team at Smartsheet, including mobile, automation, forms, and reporting, to deliver some long-awaited news. 0 · Share on Facebook Share on Twitter Objective: Use a Smartsheet Form to update a row (a record) of data. Some form features, like offline submission, barcode scanning, and geolocation, are only available via the Smartsheet mobile app. 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 If I create a form in smartsheet and someone were to complete the form, can I make it so that multiple people can be notified about the form submission and have access to the information submitted? Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. In this use case above, the vendor would submit Form 1. Is there a better option of the above, or something else entirely? Any direction is appreciated. I know it doesn't sound like a big deal from our perspective, but for the user's (who would After filling values in smartsheet 1 using a formula, I get an URL for a form (saved in smartsheet 2). This would be a phenomenal feature for those of us looking to use a Smartsheet for collecting things like purchase orders requests. Second option. Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment. At the moment, an individual has their own link which will auto-populate the submitter on the form but want to be able to change that value to blank if Conditionally display fields . Is it possible to delete the duplicate row based on the unique batch # or move it to a different sheet? or trigger a flag on that duplicate entry? Thanks in advance. 3 issues (1/ cable not hooked up, 2/ touchup paint They should be able to come back to form ID #4 at any time and update information in it. When I turn on CAPTCHA within the Form setting, what should I see. You’d set up a form to collect updates, then use Data Shuttle to match each entry to the correct row in your main sheet and update the information. This causes the form's responses in the email to be narrow and hard to read in the chart in the body of the email and attachments at the bottom of the email are unclear I know this option is available in Smartsheet, but when you enter a form through dynamic view there is not an option to have new items to go to the top of the sheet. This form is auto populated with data from smartsheet 1 for some fields. Add a text/number column called "Row #" and enter the following as a column formula: Is there a workaround to ensure that I can create additional forms for a single sheet, but with different options to be selected for the same fields within the form for the single sheet? Example: Training title: On the master form, the user can Making it happen gets extremely complex and bulky depending on how many different part #s you can have in a single entry. This way, they can work on the form over several sessions and ensure accuracy before final submission. So now you have 88 rows, one for each question. Some users are submitting several email addresses for this field via the form delimited by a comma. I was thinking that with this ON, a user accessing the Form would start seeing CAPTCHA type windows and questions, however, I do not see that happening. The basic setup would be: Separate sheet with a form built that collects identifying information. For example, information collected from the form will be collected in the main information sheet but also into department specific sheets based on the department they select when completing the form. I hope that helps. Your completed form will show up - you can change the answer for the one field and quickly submit a new submission. I believe a combination of form and Request an Update will work. We are surveying several sites at a time and instead of creating 20 different web forms that update 20 different sheets, I was wondering if there was a way to have If anyone from smartsheet is looking at this, I would like to see this be an added feature! I was trying to do the exact same thing on one of my submission forms. I need to create a field that has multiple entries in a form. Rather than submitting multiple forms, is there a way to submit multiple rows via one form? For instance, if you have a hotel expense and an airfare expense, can you submit those in one form or would you need to submit two forms? Each entry would be a new line in the sheet. ! Happy to hear from others in community if other options exist. No Way to capture email ID without asking a user not logged in, as that would mean sourcing an info without they explicitly providing it. Once the form is submitted and another blank form reloads, I want to have the fields default 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. You can set a form to allow a new entry as soon as the submission has gone through from the Settings tab: Feel free to contact me for help with Smartsheet, Smartsheet forms multiple entries for specific columns. The web form asks a submitter to enter the email address for Account Owner. My suggestion would be to have only a single part #/qty per form submission and have the form reload after submission so that users can quickly enter multiple forms in a short amount of time. When you’ve Hi @Jake Gustafson. Yes, Smartsheet does keep 10 blank rows at the bottom of the Sheet. This is a formula set to count the number of entries received daily in the contributing sheet date column [=COUNTIF([Date of Check]:[Date of Check], =TODAY())] Hi Theresa-- When new rows come in via web form, they're generally inserted at the bottom of the sheet. Similar to the functionality that exists within a SmartSheet Form. Would that work/help? I hope that helps! Be safe and have a fantastic week! Best, Andrée Starå | Workflow Consultant / CEO @ WORK BOLD Is it possible to use one Form to fill-in fields in different sheets depending on the option selected. Final Entries - Sheet Setup. Attempting to build a schedule based upon form submissions and for them to auto sort based upon date AND time, but currently without manually sorting the column this is not possible. Here is our business scenarios . What Smartsheet plan do you have? As mentioned, there are multiple ways to structure the solution. They would not be able to return to the form and make a correction or duplicate entry. Enabling a "Save as Draft" feature within Smartsheet forms could streamline our UAT process and enhance usability for our team. We do everything in the background - data is temporarily stored on your mobile device before being sent to the Smartsheet server. If you're still not seeing them, you may have a filter applied to the sheet which could be hiding the new rows from view. In Smartsheet the placeholders are {{ }} The column name must be entered exactly the same way as the Column Name is stored in the sheet (case sensitive) They'll get a link to update the sheet, which brings up a multi-page web form. Add "Save and continue" option into the form so the same user can finish the submission later or eventually to pass over to another user who would finish and submit the form. Select Forms > Manage Forms. Make sure to scroll all the way down to see if the web form submissions appear here. This last bit is the reason for this workflow! To include data from the form/record in the confirmation email you need to surround its column name reference with placeholders. Specifically it would be great if once you select a drop-down in the intake form, you could have it show the result of an already established formula column as a 'preview'. You can accept numerous submissions over time or all at once. 4. Hi @Christine Salmon1. David Tomc 03/24/21 in Smartsheet Basics. Change your search: Something like "smartsheet form 3rd party", "smartsheet form integration", or "smartsheet best form" may reveal things to investigate - even alternatives to Smartsheet like Wrike, Liquid Planner, or Basecamp. See all The fillable pdf is a requirement of the Generate Document functionality. ; In your rule’s condition, which always begins with When, define the operator Hi @n2stc. 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. Example of options in the Multi However, when the other option is chosen for that field on the form the data in those cells is overridden and Vlookup stops working for future entries. I need the signature to be integrated with the initial form entry so the user can officially sign at the time of entering the form, and not be prohibitively expensive. Hi there, the form entries will automatically add a date/timestamp if, in you add a system column type to your sheet. Different methods of selecting the bin and that send an update request for the bin. I would like the ability to reload the new item submission form in a dynamic view to submit another entry. Workflow Consultant / CEO @ WORK BOLD Hi Andrée Starå, Appreciate your response. 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 You can change your form settings to either hide or show fields in the form. This sheet continues to populate as more orders I need a formula to identify the oldest entry for each location, and if there are multiple entries for the earliest date, use a "score" column identify the higher score as the next candidate in line. For my Metrics summary page, I am struggling with COUNTIF when the user has selected multiple options. Is it possible to have an option at the bottom of 'Submit and Add New', eliminating the need to go in and out of the form? We have many Smartsheet forms which we use as a way to gather attendance for our Limiting the amount of rows you want a sheet to have or the number of form entries would be amazing for the medical field Please add restrictions to Form for the option to limit the number of times someone can use the link--to ensure Is there a way to auto expand a form to take multiple entries, Is there a way to auto expand a form to take multiple entries, instead of one submission per entry? Home As a workaround, you could use a third-party service like Google Forms. I'm trying to recreate the solution shown in the later half of the presentation that takes a form entry, gets row, and splits it out into multiple rows/tasks nested under the Have the form populate their previous entry everytime the they submit the request (that way they only change 1 item and all other column entry's are the same)? Have the option to populate multiple rows in the smartsheet via the form? Thank you in advance! I've created a form for an internal team to submit requests on. It also does the calculations for the entire form, which then is automatically sent to Accounts Payable. Answering to the best of my knowledge. I hope you're well and safe! Yes, and my method below might be helpful. Using that id, I want to create 2nd form. Use a URL query string to prefill default values on a form If you need multiple people to fill out the same form but want to specify different default values in certain fields, or automatically select the Send me a copy of my form submission checkbox, create a URL that includes unique query string I've developed solutions for a couple of clients that create multiple rows from one form submission. Feel free to contact me for help with Smartsheet, Hi @User251. Here's what I want Smartsheet to do, if possible. If they have more than request (the average is 10-40 at a time) I'd like the Smartsheet to create a new row for each request. It will contain one additional column called "UniqueEmpID". I'm not sure I worded that my question correctly, but I am trying to create a form at the moment that, in addition to several other questions/fields, asks the user to submit any income/deduction items not already set up and for each entry to give the EE Name, EE #, EE Type, Income/Deduction Name & Amount. We have done this too with automation. 1. Is there a way to set it up that multiple items can be entered in at the same time and grouped together to keep work orders together, or will they have to go through and enter everything manually? Another option. Here's more information: Manage Form Display and Submission Options 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. Add an active link or document to a form. If you have the time, I'd appreciate a little more hand holding on how "Form Logic and Helper Columns / Form Fields with set default values" will help me implement Field 3 populating a specific value based on what's entered in Is there any way on a Form to add a checkbox that would allow the user to copy their information over to a new form entry I developed a solution using two forms that can be used to submit the main information and then the other information on a new row for Can the Smartsheet Calendar App send a notification when an event Separating the email addresses with a semicolon (like in MS Outlook or any other email client) does not do the trick, Smartsheet seems to handle the whole list of emails like a large string of characters, it does not capture each individual contact, so the emails are not being delivered to the emails listed in the Smartsheet cells of a particular column when it contains I created a new form in the existing project tracker it created new columns on the right. This will require they are logged into a Smartsheet account to view the web form and will automatically capture their email address in the sheet's Created (By) system column. They might have multiple expenses they need to break out. Thank you for your help. Is there a way to reset or zero out the submission count? I'd like to create a form in which an employee can only submit their response one time. We do an audit checklist every quarter for nearly 200 locations. Thanks -Peggy Hi @Abhiraj Joshi. When the first is submitted it would open the second and then that one would reload after each submission. Depending on the security settings of the form, anyone can fill out a form, and your form submitters don't need a Smartsheet account or login. Checklist has many questions which cannot be filled in one short because all of them need evidence. The Form Entries sheet will look the same as the above example, except for the addition of these two columns: RowID: a With the out of the box Smartsheet Form fields, I can easily create a form that requires the customer enter the required information, and it will of course add a new row entry for that single form submission. (We do not use Google Forms which I have heard can do this) Again, no data validation within the form to limit it to three. Double-check the Form URL she used to be sure it's the correct one for that sheet. Add form elements. Is there a way I can create as many rows as items selected from the drop down while keeping the other text areas common? Hello, I need help figuring out how to have a web form update multiple sheets based upon location information. For example, if a user selects Sheet1 then data would be populated in Sheet1, and when user selects Sheet2 data would be populated in Sheet2. This is the same as providing a link to a form. The Final Entries sheet will contain the first seven columns from the above example, up to the "Name" column. You can then very easily link it to your You could set up a solution with two forms. CAPTCHA within a Form. For instance, if utilizing 'allow multiple selections' in a form, to have a toggle for 'create new row for each selection' rather than having multiple selections grouped in one cell after the form is submitted. the example is a punchlist , where e. ) I'd like to create one form that will populate the information in two or more different sheets. Merged: Multiple line entry on a form. I've thought about that, but then the users would have to select their options again. This sheet is the one that has the form attached to it and is also used to shift each form submission from horizontal to vertical. 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 We often create forms and have test submissions. Regarding the dates, It's possible. (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. This option is at the bottom of the Form Options menu when editing a web form. Thank you for your response. Requesting Smartsheet to find a solution for saving form as draft and keep the option to submit later. Use the toggles to set your field as Required or Hidden in the Field Settingspane on t 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. Currently, our users have to submit a form for each item requested, which is highly tedious when a request needs to be made for several items with the same vendor, project code, requestor name and department, end use, etc. I'm doing a test sheet for this, currently, with the Primary column as "Name" and a multi-select dropdown called "Options. Is there a way to be able to insert multiple lines through Form? For example If I have a field Car on the form, and I want to submit (staff feedback form) I'm trying to give form submitters the option to anonymise their submissions. Select an element from the center form preview to edit its settings, which is displayed in the right panel. This IT person doesn't have to be shared to the sheet in order to fill out the Update Request form and fill in the rest of the fields that were missing from the first form submission. However, you can use a formula in the underlying source sheet to flag a row if it's a duplicate (there are a number of Community posts with this formula solution, such as this one). To check a box for the most recent entry for each person, here is what I suggest Add an auto-number column. 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. Clear browser cache and reload the sheet, or access the sheet through a different browser. Would that work? I hope that helps! Have a fantastic week! Best, Andrée Starå. Form Entry - Sheet Setup. Example Week Over Week Change. You can submit an Enhancement Request, asking to add the ability to select columns in the custom message field instead of Dear Community Member, Dear Community Member, I received a question from one of my clients about creating multi rows contains the basic data that he input and he don't want to re input the same data using his intake form many time, and i like to share this exercise with you if you are facing the same issue to save your time to avoid repeating basic data input Hi Community, I'm attempting to find the average downtime of an asset between dates from a form submission for the month. In my case, I made the sheet available to anyone by publishing this sheet and providing the published-page-link to my organization. Example of when it works: =IF([Request Type]14 = "Prior Resource - See Outside Resources Sheet", (VLOOKUP([Full Name]14, {Resources Database (Demo) Range 1}, 9, false))) After filling values in smartsheet 1 using a formula, I get an URL for a form (saved in smartsheet 2). You can include a certain value in a specific column without the form submitter completing that question. Automatically through a Workflow with an alert to send a copy of each form submission ; Would any of those options work Is there a way to automatically duplicate a row once it is added from a form submission based on a cell value in that row? Duplicating multiple entries of the same Row based on a cell value. Submitters need to create a Smartsheet login in order to use the app. 3 issues (1/ cable not hooked up, 2/ touchup paint Paul, I have a form I'm using as a maintenance work order log. They would open the document or link, then respond to the questions/etc in the form. To do this, use the Hidden and Default Value features together. Hello, I would like to create a form submission for our team of ~45 to input requests for shift times, and days off requests. It would be great feature if one form could be used to fill in multiple lines/rows on a sheet. If Dynamic I have used something similar to allow what appears to be multiple form inputs on a single line, It allows you to manage the approval process for PDFs with multiple approvers submitting their responses Wondering if it is Another option (or use with the option above), once the web form is submitted, send an update request to the manager asking them to check a box in the row to approve the request. " My data input sheet has several columns that are Multi-select dropdowns. Each question comes up in order on successive pages of the update request; they go from page to page with the arrow button, and at the end, submit all the updates at once. A simple workaround is to use your browser backspace after submittal. ; Select the Logic tab in the Field Settings on the right, and then select Add Logic. Hello! I apologize if there's already an idea open for this-But what would be a great addition to forms is by expanding the logic options. This is a Contact column but there are so many in the company, I have not pre-defined values that could appear in a drop-down list. Multiple row entries through Form entry. 3 issues (1/ cable not hooked up, 2/ touchup paint Hidden and Default value features. If we have an added setting to allow them to edit their responses, maybe they could re-open the same form submission and add 5 more responses while retaining all the logic for the entire form. Andrée’s solution is good, but it doesn't work with you have different people submitting the forms at the same time. Basically I am asking is there a way to save information in the form then submit the form when ready. ; Select the field that determines which other fields and form elements appear based on its value. When you are in the Form, switch to Settings Tab and under Form Submission, under 'What should happen after form is submitted' pull down you should see a 'reload the same form for another entry' is available. Add that to the form as a hidden field and checked by default. (Do not have the form set to reload). Formatting doesn't matter. So if the first 3 questions are answered and they submit, they'll receive an email confirmation with a copy of their form. To select multiple rows, click one row number, and then hold down the Ctrl key (Command on Mac) and click the row numbers for any additional rows you'd like to include in the PDF. Then in each form, add that column but hide it from view with the default option being the name of the form. I have several columns but a batch number is a unique identifier for the entire row. Select the field you need to check once you’re in the form builder. One must use a software outside of smartsheet to generate a Fillable pdf - that is a pdf form that allows data entry into fields, then upload that pdf form template to be used as by Generate Document to produce the pdf that contains the row data. For example below, I need to find the number of days between the "OOS Tag Removal Date" and "Date OOS Tag Applied", based only on all entries for "Asset ID" FD-001201 where the "Reason for OOS" is Failure, then average that number for Hi there, I'm reaching out to see if in the last two years Smartsheet has enabled this feature. Copy a row the row to a throw out sheet 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 With conditional logic in forms, you can ensure that people using the form only answer relevant questions to their submission by showing specific fields based on their answers to other questions. I entered some test entries through the "Forms" function and now want to go live with the sheet. However, we need a single form to forms setup option, retain the last entry. Multiple Line Entries with one Form Submission. It is not allowing me to delete the test entries. Smartsheet University; Knowledge base; Training options; Support; Community Explore user-generated content and stay updated on our latest product features. The user did get an email notification with their submission confirming that the entry was successfully received. For example, you want Open to be the default value in the Status field, and you don't want the user to see that field. In the Formsdialog, select the form you need to edit. crhems xseqmj zhjllw uysbdeh sxqgbfo qdtvwcdix smvkzh izqwmk oedul fdlqcc