Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Drop downs issues in form
Trying to build a customer feedback form.
No idea why but the form does not save the dropdowns as I have entered them.
I enter and save it like this
5 - Very Satisfied
4 - Satisfied
3 - Neutral
2 - Unsatisfied
1 - Very Unsatisfied
When I open the form it looks like this
1 - Very Unsatisfied
5 - Very Satisfied
4 - Satisfied
3 - Neutral
2 - Unsatisfied
I have closed and reopened and redone this multipole times with the same result....
Any help appareciated, what am I doing wrong?
Comments
-
J. Craig Williams ✭✭✭✭✭✭Mike,
The wording of your post seems slightly off and I may be misreading.
When you say "I enter and save it like this", it sounds like you are typing in the WebForm.
A Dropdown List in the WebForm is pulling its choices from the column's list.
It is only entered once. The column needs to be a Dropdown List type.
I've tried several combinations and have not reproduced the problem otherwise - using either the Display Type as a Dropdown list or as Radio buttons (vertical).
If you are using a column with Dropdown List type, then I would contact[email protected]
Craig
-
Darrin Eisenbarth ✭✭✭✭Just confirming as well - I created a dropdown field (called feedback) in a form and added the criteria you provided. The order remains both in the form and in the sheet as entered.
I am using Chrome, but I think Craig's comment may point to the actual problem.
-
Thanks Craig and Darrin, yes I am using a dropdown list in the sheet to produce the form (not enetering in the form) so I have no idea why it would do this if yours works fine. The first screenshots show
-
J. Craig Williams ✭✭✭✭✭✭
You have several screen shots of [Our Delivery Performance] dropdowns in the sheet, but none of the [Our People's Performance] which is the one that is shown as incorrect in the column properties (and therefore, I would guess, in the WebForm).
Check [Our People's Performance] in the sheet.
Craig
-
yes I did that
-
J. Craig Williams ✭✭✭✭✭✭
Then I am stumped.
When you are creating the second dropdown list,
1. create new column
2. give it a name
3. change type to Dropdown List
the selectable values will auto-populate with any values already in the column.
For a new column, that is blank, but when changing an existing column from a different type (ie Text/Number), it will auto-populatein alpha-numeric order.
Yours does not appear to be doing that.
I suggest contacting[email protected]for help.
Craig
Categories
=(NETDAYS([Requested Start Date]@row, DATE(2022, 12, 1)<\/strong>) \/ 365) * 12<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":107082,"type":"question","name":"Automatic Update of Dropdown List?","excerpt":"I saw several discussions on this and I'm wondering if there is a formula or an easy way without a 3rd party to automatically update a dropdown list based on a cell in one sheet? I can create a helper sheet if that would help. Any ideas? I don't believe I have the premium Smartsheets plan. Thank you! Lori","snippet":"I saw several discussions on this and I'm wondering if there is a formula or an easy way without a 3rd party to automatically update a dropdown list based on a cell in one sheet?…","categoryID":322,"dateInserted":"2023-06-29T14:16:13+00:00","dateUpdated":null,"dateLastComment":"2023-06-29T18:02:59+00:00","insertUserID":162337,"insertUser":{"userID":162337,"name":"maineL","title":"Admin. & Course Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/maineL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!plNXqQdBs_o!2kvQ_7y42f4!PTHvB33mICN","dateLastActive":"2023-06-29T18:08:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-29T19:23:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":49,"score":null,"hot":3376116552,"url":"https:\/\/community.smartsheet.com\/discussion\/107082\/automatic-update-of-dropdown-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107082\/automatic-update-of-dropdown-list","format":"Rich","lastPost":{"discussionID":107082,"commentID":383175,"name":"Re: Automatic Update of Dropdown List?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383175#Comment_383175","dateInserted":"2023-06-29T18:02:59+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-29T19:23:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-29T14:52:00+00:00","dateAnswered":"2023-06-29T14:50:26+00:00","acceptedAnswers":[{"commentID":383100,"body":"
