-
Conditioning logic to be AND not OR in form
Hi there, I am needing to build in logic to a form whereby a question shows if a specific answer to 1 AND 2 is selected and not OR. Question 1 : A, B or C Question 2: X, Y or Z Question 3: Appears if answer to Q1 is C and answer to Q2 is Y. Currently this is showing if answer to Q1 is C or if answer to Q2 is Y. I need it…
-
Autopopulating Dates on a Sign-up Sheet
Hello, Does anyone know if there is an option to auto populate dates for a sign-up sheeting on SmartSheet? For example, I have sessions that individuals are allowed to select from October to December. However, I do not want those dates to show up after they have passed. So, if today is 10/4, then I do not want my sessions…
-
Requestor carry over: Form pointing to another form
I have set up an initial intake form which gives the choice to go to another form: one form or the other depends what they want, e.g. request a report or request access to a file. With either form, the filled out request goes to the same smartsheet that captures the request regardless which form they use under the column…
-
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…
