-
Forms/Formulas
Hi, I have a Form/Dashboard on Smartsheet to book site induction on the project I am currently working on (see attached image). Just like every other Smartsheet forms, once the form is filled in it feeds into the sheet. Is it possible that once someone books an induction late (48 hours prior to the induction date) they get…
-
'Receive Copy of Form via Email' Checkbox: Default to Checked?
Good morning and hoping for help on a quick question, re: the feature to include a 'Receive a Copy of Your Submission via Email' checkbox at the end of a form. My team and I are designing forms to gather information from our end users, and would like to use a 'Receive a Copy' checkbox at the end of each form, to enable…
-
HELP - Enabling CAPTCHA on a Form
I have a business critical form that's getting spoofed (500+ entries in ~3hrs) and am trying to enable CAPTCHA but I can't seem to get it on the form. Here's what I've done using Edge and Firefox: Edit form > Form Options > Checked 'Enable challenge/response for additional security'
-
Web form not refreshing into sheet
I created a worksheet to track issues. I then created a Webform to gather this data from end users. I ran a test entry. I received email with URL to webform. I entered the data and submitted. I received a confirmation message and email. A notice appeared on the worksheet that an entry was made. I click refresh and the…
-
Enhancement Request: Improvements for Contact List columns in Forms
When adding a Contact List column to a Form, if no contacts are listed in the column properties, the field shows up as a simple text entry. If contacts are added in the column properties, the entry changes to a drop down. However, the drop down acts as if the "Restrict values to list only" check box is checked, whether it…
-
using a form to input new data means my formula no longer works.
hi, I am using a lookup formula to find prices for specific things. once a form is used and new information is inputted into the top row the formula says unparseable and the [column name]1 changes to [column name]2. I would like to stay as [column name]1 even when new information is put onto the sheet. Please can someone…
-
How do I reset a webforms entry count?
I built a new webform and during testing I generated a few test rows into the underlying spreadsheet. I am able to delete these test rows but how do I reset the entry count that appears when the form is opened from the sheet. Setting it back to zero would be ok. Thanks for any guidance that you can provide.
-
VLOOKUP from Form Input
Hey guys, I've been unable to find a solution for this one. I have a sheet from which I "VLOOKUP" values from another sheet. This another sheet gets its values from a FORM input. When I reference another sheet as a lookup_table, I select the whole sheet in which the FORM data input ends up, the new line is never included…
-
Automation from a form submission
Hi I have created a form that is working perfectly in that once completed it is populating the sheet data. I have also created a number of automation work flows that work if you directly input into the sheet but do not appear to work if the data is entered via the form - please can anyone advise if I have missed a step or…
-
Question on showing text (comments) from cells in dashboard
Hello Community, I have a form which people fill out and the numerical data from which is analyzed and then put up on charts in a dashboard. However, part of the form is a text box where they can type in comments about the material. Is there a way (possibly through a report?) to have a widget that shows comments people…
