-
Submitting Multiple Rows using one Smartsheet Form
We are creating a new Smartsheet to track deliverables. We have asked competing vendors to add delivery details within a ‘Smartsheet Form’ to auto-populate the sheet. Orders contain 1 to 100 shipments. Our Order Number is the same for all shipments. Ideally the vendor would like to enter the Order Number and the Order…
-
Block Dates
I have a form for requesting email sends and I wanted to know if I can "block" some specific dates so that requesters cannot make requests on those days. Is it possible?
-
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…
-
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…