-
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…
-
Prefill Form with a Date Column
Hey Smartsheets Community! I can't find any information on this so I'm hoping y'all can help! We are making a panel application form and we're attempting to make a form that will fill with pre-arranged dates but only allow for a single selection of said dates. When someone selects a date in the smartsheets form, we would…
-
Form Default range
Hi, I would like to build forms with default minimum and maximum values and I would like the form to send me an email only for the values which are out of range. The min and max will be mainly numbers for different equipment. If the out of range items can be highlighted red, that will be great. Also, If I can display the…
-
Is there a way to add logic to a statement in a form (not at field)?
I am trying to use Form Logic to display a statement that displays only if "Yes" is selected on a form field, without it being a form field that needs to be completed. For example, if "Yes" is selected, then I want a statement to display that says "Please contact your manager to discuss further". Is there any way to do…
