-
Is there a way to customize the submission confirmation page?
I have built an audit for the operations folks to fill out and submit via Forms. They are wanting to have their score automatically appear on the submission confirmation page so a few questions: Is that possible? If it is possible, how do I build that feature in and what sheets, formulas, etc. are required?
-
Form with logic - not capturing a default value on submission
Hello! I am working on a form that contains one piece of logic, and cannot seem to get it to operate the way I want. I have logic for when the 'Approved distributed item' box is checked, additional fields appear. Approved Item Number & Status - Pitch || Go-Live When i select the box, it works as expected. But when the form…
-
Are you able to associate answers with number values?
I am attempting to create a form similar to the one attached below: Is there a way to associate the answers a user inputs on the form to a number value and then add them up to a total? Thank you for the help in advance!
-
Issue submitting a form
Hi all, Anybody having issue submitting data through a form recently? One of the sheet that our team is using is experiencing failure of data submission for the past few days and the problem seems not to go away. Any time new entries is submitted, the forms will show a waiting message for a while, and then return an error…
-
How can I identify which form was used to submit data
I'm using 2 different forms to create new rows on a sheet. I would like to know which form was used to enter the data. Is there a way to do this? I have tried using a URL query string to specify default values, but I don't know how to hide it form view.
-
Vlookup range not updating with form submissions
I have a sheet with a list of employees that references form responses on a different sheet, and via vlookup function pulls in the date a form was submitted (to track who has submitted the form, and who as not yet done so). The problem I'm having is the vlookup range automatically limits itself to the forms already…
-
Can we pause when filling out a Form?
I am creating a Smart Sheet with a lot of data that will be populated via a form. The concern with my team is that if they get interrupted when filling out the form that they will not be able to continue. We have lots of fires to put out so it is highly possible that once started someone may have to step away urgently and…
-
How to get checkbox responses to show in notifications?
I have a sheet that has several columns which are formatted as checkboxes and a form for users to submit info. The users check boxes on the form to select fields. I have set it up to send a response back to the submitter with their responses. The notice that goes back to the submitter shows the field names but does not…
-
Required Fields in Forms and Default Value
Hi all, I've run into somekind of strange behaviour on the Form I've developed and was wondering if anyone had any insight into this. Can I make a field required with a default value? It seems that by inputting a default value on the form field, the user is able to submit the form without having to change that value. It's…
-
Automation: Send to contacts in a cell
Hi, I'm having an issue where an automation won't send an email. My personal settings are correct. It will send the email if I input an email address, but it will not dynamically pull that email from the submission. I.e, it's a mutliple form, and the form gets filled out by X person, who inputs into one of the contact…