Forms
Discussion List
-
Block Dates on Forms
I have a form that my colleagues request emails to send to my marketing team and it would be nice if I could prevent requests from specific dates in the form
-
Collecting time range in form
I'm creating a form to collect the days and times that employees will be out of the office so that I can get the info onto a dashboard for the team to refer back to. Since Smartsheet doesn't have time fields for forms the best workaround I could find was using dropdown fields with half hour time segments and have one field…
-
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…
-
Merged: Create Character Limits for Form Fields
This discussion has been merged.
-
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).
-
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…
-
Help setting up a daily tracker
Hello! My team is attempting to create a sheet and form that counts the amount of inventory of a product we are overselling per day. We essentially would have the inventory start with 15 units per day, we are going to request the number they sold for each entry. The goal is to have the number they enter in the form will be…
-
Form deactivated and deleted still available to users
I have an old version of a portfolio with an intake form. I've deactivated and deleted the form, however, users across my organization who may have saved or bookmarked the link are still able to access the form and submit answers…. only the answers don't go anywhere any longer. This is causing confusion and frustration…
-
Trouble with understanding Workflow
I work for a company that runs clinical trials; I want to create a way to send out vendor performance surveys to Clinical Trial Managers (CTMs) who work with the vendors on different studies. Each CTM is responsible for one or more studies, and some vendors are repeated in different studies. The CTM needs to take a survey…