-
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…
-
Edit data in smartsheet using a form
Hi I have data entry from which is used by one group of people to punch in data. I have created the form for that which sits on a smartsheet. I want to use the same form to retrieve the data (row) in the same form, so that another group can either edit or fill in some other fields which were left blank. thanks for the…
-
Form Automation
Hi, Not sure if this can be done. I've created a form that I want to send to users. Ideally, one person would fill in the name of the project, then through automation, send the form on for other users to continue filling out (with the project name already filled out). Or have the person fill the name in the form…
