-
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…
-
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…