-
Using forms and multiple rows
Hello, I have created a form for my team to enter data to populate on a master sheet. We will have multiple part#'s and QTY's per request, however, I cannot find a way to have forms split those into separate rows. Is there a way to have a form submission separate by line in the form to a separate row in the sheet?
-
How to subtract quantities from one sheet via forms to another sheet with total quantities
My issue is this: I have a master sheet with material types (A1,A2,A3 etc..) and total material quantities (#'s). The other sheet I am using is updated via forms. The form is used for distributing materials and requires a material type, and material quantity before submission. Once submitted I would like the quantity to be…
-
How to cascade the same grouping of rows multiple times for device management in a form
If I have a row that says "how many devices do you have?" And a user inputs 6 (for example). I would want the form to present the same grouping of three rows (serial number, location, owner), six times. That way each device has a unique place to document these discrete items and they file back to the same column in the…
-
Allow form users to create individual templates of the form for repeat use
We use an intake form for users to provide order instructions. We offer the user the opportunity to get a copy of their responses. Please provide a way for them to save the form with their standard information so that when they need to submit a new order, they do not need to re-enter all the standard data. It could be an…
-
Form Entry Mystery! Validation Failure...
I am trying to figure out how a form user was able to enter alpha characters into a form field restricted to numbers only. The form settings were last updated on 9/14. When I checked the form settings after the text entry was made, the field was set to "Number only" validation. I have tried to replicate this, but I cannot.…
-
Symbols 6-state Star in Forms
When creating a form, is there a way to not allow the 0-star ("empty") be an option? I only want them to rate 1 through 5, not 0 through 5. If there isn't a way to remove the 0-star choice, can I set up logic that they can't submit the form with a 0-star selected? Either will work, but the former is preferred. Thanks all!
-
How does a record in a sheet from a form submission just disappear?
Hello, I designed a request form for a team that included a copy of the submission to be sent to the submitter's email once the request was submitted. The submitter submitted a request, received a copy of the submission, but there was no record of the submission in the backend sheet that is connected to the form. I looked…
-
Using App to Schedule Resource
I am using Smartsheet to create a calendar system for reservation of a shared resource. So far, I have not been able to find a way to add TIMES to Smartsheet so more than one person can schedule the same resource on the same day, during different time slots. Can you help? Furthermore, these resources are occasionally…
-
Ability to edit Javascript for embedded form
Hello, Does anybody know if there's a way to edit the Javascript if we embedded a smartsheet form on a site? We'd like to match the look and feel of the form to the website design.
-
How to create a link on a sheet in the row created by a form submission
Form --> Sheet --> DynamicView We use a form to collect some basic information from new staff regarding remote work. The contents of this form are made available to the managers for review and approval of the remote work conditions. We use DynamicView to display the submissions because it is easy to show each manager only…