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.

Subgroup within Drop Down List

Shannon Green
Shannon Green ✭
edited 12/09/19 inArchived 2016 Posts

Good Afternoon Everyone,

Hoping someone has some tips for me. I am creating a smartsheet with a webform for our marketing department to help obtain and organize work order requests. On this web form, I have a dropdown list for the client to specify where the request is for (we have numerous hotels, retaurants, attractions, etc) so I was hoping that within the dropdown list, I could include some type of subgroup or headers instead of having that 25+ choices in one list.

Example of what I was hoping to have it look like:

酒店:

Hotel 1

Hotel 2

Hotel 3

Restaurants:

Restaurant 1

Restaurant 2

Restaurant 3

Restaurant 4

Attractions:

Attraction 1

and so on......

Any ideas?

Thank you,

Shannon Green

Tags:
· Share on Facebook Share on Twitter

Comments

  • Kennedy Stomps
    Kennedy Stomps Employee

    Hi Shannon-- We don't currently offer the ability to group dropdown list options. If you wanted to arrange the choices in your Dropdown pick list like this, you would need to manually arrange them in your desired order. If you wanted, you could include values like "Attractions:" to separate the list, but there isn't a way to create a true hierarchy in the list at this time.

    · Share on Facebook Share on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 08/07/16

    Have you considered several columns for the data collection / WebForm and one column that is the one they choose?

    Craig

    · Share on Facebook Share on Twitter
This discussion has been closed.

Categories

@RossG<\/a> <\/p>

This formula will check if the Invoiced Date isblank and leave the cell blank if true. IF false it will check the Month and Date formulas to be less then 2 characters long and add the leading 0 if needed.<\/p>

=IF(ISBLANK([Invoiced Date]@row), \"//www.santa-greenland.com/community/discussion/5576/\", YEAR([Invoiced Date]@row) + IF(LEN(MONTH([Invoiced Date]@row)) < 2, \"-0\", \"-\") + MONTH([Invoiced Date]@row) + IF(LEN(DAY([Invoiced Date]@row)) < 2, \"-0\", \"-\") + DAY([Invoiced Date]@row))<\/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":[]},{"discussionID":108931,"type":"question","name":"Attachments and Deleted Users","excerpt":"My company uses onedrive to upload attachments to sheets. If a user uploads attachments via onedrive and the employee is deleted or deactivated, will the files still be accessible?","snippet":"My company uses onedrive to upload attachments to sheets. If a user uploads attachments via onedrive and the employee is deleted or deactivated, will the files still be accessible?","categoryID":343,"dateInserted":"2023-08-14T18:13:59+00:00","dateUpdated":null,"dateLastComment":"2023-08-14T19:29:57+00:00","insertUserID":165068,"insertUser":{"userID":165068,"name":"imayes","url":"https:\/\/community.smartsheet.com\/profile\/imayes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-14T20:04:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-14T21:17:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3384078836,"url":"https:\/\/community.smartsheet.com\/discussion\/108931\/attachments-and-deleted-users","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108931\/attachments-and-deleted-users","format":"Rich","tagIDs":[268,549],"lastPost":{"discussionID":108931,"commentID":390560,"name":"Re: Attachments and Deleted Users","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390560#Comment_390560","dateInserted":"2023-08-14T19:29:57+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-14T21:17:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-14T19:37:58+00:00","dateAnswered":"2023-08-14T19:29:57+00:00","acceptedAnswers":[{"commentID":390560,"body":"

As long as the document is still available in OneDrive, the document should still be available in Smartsheet. Think of it as a URL to a website. As long as the website is still up, it doesn't matter who the owner is.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User Management"}]},{"discussionID":108909,"type":"question","name":"Calculate # of Incidents Within A Month","excerpt":"I have a sheet that is recording data, we have a field for the date of an incident. I have a Roll Up sheet that is counting the data from the main one, with a number of different items. Is there a way to have a formula that counts the # of rows that have a date in a specific month? I want to be able to pull the number of…","snippet":"I have a sheet that is recording data, we have a field for the date of an incident. I have a Roll Up sheet that is counting the data from the main one, with a number of different…","categoryID":322,"dateInserted":"2023-08-14T14:25:06+00:00","dateUpdated":null,"dateLastComment":"2023-08-14T15:59:59+00:00","insertUserID":154851,"insertUser":{"userID":154851,"name":"Jodi C","url":"https:\/\/community.smartsheet.com\/profile\/Jodi%20C","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5qlOufSjfDo!xBtOMYTHJno!KTQ5OLC8XX5","dateLastActive":"2023-08-14T16:01:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-14T21:17:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":53,"score":null,"hot":3384054905,"url":"https:\/\/community.smartsheet.com\/discussion\/108909\/calculate-of-incidents-within-a-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108909\/calculate-of-incidents-within-a-month","format":"Rich","lastPost":{"discussionID":108909,"commentID":390495,"name":"Re: Calculate # of Incidents Within A Month","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390495#Comment_390495","dateInserted":"2023-08-14T15:59:59+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-14T21:17:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-14T15:10:17+00:00","dateAnswered":"2023-08-14T14:44:35+00:00","acceptedAnswers":[{"commentID":390460,"body":"

You would use something along the lines of (Jan 2023):<\/p>

=COUNTIFS({Date Column}, AND(IFERROR(MONTH(@cell), 0) = 1<\/strong>, IFERROR(YEAR(@cell), 0) = 2023<\/strong>))<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Changing MMDDYYYY date type column to YYYYMMDD format when referenced in another cell

    The formula I currently have works to an extent, however, it omits the leading 0 on months and days. For instance, I get 2023-8-14 instead of 2023-08-14. Is there any way to add the zero? Here's what I have right now: =IFERROR(YEAR([Invoiced Date]@row) + "-" + MONTH([Invoiced Date]@row) + "-" + DAY([Invoiced Date]@row) + "…

  • Attachments and Deleted Users

    My company uses onedrive to upload attachments to sheets. If a user uploads attachments via onedrive and the employee is deleted or deactivated, will the files still be accessible?

  • Calculate # of Incidents Within A Month

    I have a sheet that is recording data, we have a field for the date of an incident. I have a Roll Up sheet that is counting the data from the main one, with a number of different items. Is there a way to have a formula that counts the # of rows that have a date in a specific month? I want to be able to pull the number of…