-
Trying to add form submissions onto a Spreadsheet that has a column of unique randomized numbers
Hello all, I was wondering if someone can let me know if there is an easy way or even a workaround to my issue. I have a list of randomized coupon codes in a column, and I need the form submission to populate the next available row with a coupon code. The issue I have right now is that, I have the column of 500 coupon…
-
Enhancement Request: TODAY() as default value in forms
Hi team, I find that it would be very useful to the user just to implement a way to set up the date of "today" into data fields of Smartsheet Forms and new entries in Dynamic view. In essence it would take today's date as default value. Upvote if you find this useful so it could be implemented
-
Forms: Create the ability to manage (show/hide) the picklist values presented on the form
We use forms in several ways and they all tie back to a master tracking list. I would really like to see more features to manage the picklist options presented in the forms. For example in one of my forms, I do not need to see all the available options for a field, just a subset. As of now it appears to be all or nothing -…
-
Is it possible to build a system where a single form submission can dynamically create many tasks?
Typically, one submission of a form results in one row on the sheet the form belogs to. Is there a way to have one submission resulting in multiple rows (6-8) that assign work to different team members? Our customers purchase multiple ad products on a single insertion order. Ideally, Sales would complete one form, select…
-
Will moving Smartsheet with form break link to form?
If I created a Smartsheet with a form in an IT workspace, will it break the link to the form if I move it to another department's workspace?
-
How to Automate Email to the Submitter?
I'm trying to set up an automation that will email the submitter once their request has been set to a status called "Approved". I made a Contact list column for the submitter to enter their own email, but when testing this automation, the submitter never got an email. Any help with this would be greatly appreciated!
-
Form dropdown options pulled from another sheet
Hi! I would like to make a form with the options pulled from another sheet. This is to prevent an incorrect project code being entered. The column drop-down options would need to be a the list of project codes from another sheet. The drop-down options would need to update continually as new project codes are added to the…
-
Validation Phone prefix countries missing
When adding a Field in a Form and adding a Validation Phone, there are several missing countries: Croatia, Indonesia, Mauritius, Morocco, Nigeria, Philippines, Serbia, Taiwan, Thailand, Turkey, Vietnam, Uruguay and others. Would it be possible to check and update?
-
Is there a way to make a field in a form auto populate street address as its being entered?
I have a shipping management Smartsheet that has a intake form with a address field. When users fill in the address field sometimes they do not provide the entire address. I want the address to auto populate as they type in their address.
-
Form URLs should automatically update on newly saved dashboards when copying a workspace template
As a user, I would like form URLs to automatically update on newly saved dashboards when copying a workspace, So that I do not have to manually update the Form URLs and prevent the risk of forms accidentally pointing to the original sheet or workspace. Please refer to case # 05972330, as this had been previously assumed to…