-
Smartsheet FORM Dropdown List - Cells in Column "have values that aren't dropdown values" Error
Hello All, Specifically for the Form's Dropdown List - what does it mean when I get this error message for a list that has 87 (manual, ugh) entries? —> (14 cells in (form) column) "have values that aren't dropdown values." Are there any special characters that aren't allowed, maybe? What are the rules for text to be valid…
-
Customise the message that appears when you open a deactivated form
Hi All, There are instances where we have to temporarily suspend the use of a form so we need a method to inform the users why the form has been deactivated. Thus, it would be useful if we can customise the message that appears when you open a deactivated form (Current message is "the form you are attempting to access is…
-
How to assign points to answers selected thru drop down on form
Hello, I created a form to be used during a training exam. Each cell has a drop with 3 options, Proficient, Needs Improvement, Not covered. Is it possible to assign each option a point value ( 3 - proficient, 2 Needs Improvement, 1 not covered) and have a total calculated once completed? Thank you
-
Merged: Create Character Limits for Form Fields
This discussion has been merged.
-
Control Center - append project site name to Forms
I love that forms can now be added to dashboard templates and Control Center will link them to the new project dashboard when standing up the site. Yea! But Control Center does not append the project site name to the form as it does to the other assets it stands up. Why is this an issue? When one clicks on the form link…
-
Can I attach a form to a Gantt chart to be sent out automatically when milestone is met?
I want to attach a form to a Gannt Chart, so that when a specific milestone is met, the form will automatically be sent to be filled out. I am using the Gantt chart to track multiple jobs, and I want it to send out checklists at certain times during the job process. I created one of the checklists as a form in another…
-
Validate Email Domains
In a form, it would be great to be able to set up a validation that would not allow certain email domains (such as @gmail.com or @yahoo.com).
-
How does the form submitter receive a confirmation email without getting copy of the submission.
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
-
Duplicate Columns in Smartsheet Forms
I am using Smartsheet Forms to create a survey. The survey will repeat the same three questions over and over (about 10 times total), just applied to slightly different topics each time. I don't want to have to type out the three questions and associated dropdown menu selections over and over manually. Is there a way to…
-
Auto sum in form?
Is it possible to have a field in a Smartsheet form auto calculate a sum of previous fields in the same form? For example: On an invoice form: If $500 was spent on supplies, $400 was spent on travel, $150 was spent on other allowable, can we have that auto-calculate into the Total field? Right now, submitters have to…