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.
Multiple selections from drop-down list, enhance database function
Comments
-
I too, really need this feature. A graphic can have so many elements that need to be called out for cross referencing and it would work very well in a multi select dropdown list.
-
alanf ✭
This is exactly what we need, too.
-
alanf ✭
Kara, here's another specific Use Case for selecting multiple items from a drop -down (or even being able to select multiple check boxes): we have a list of items; some are associated with multiple stakeholders, and the ability select those stakeholders from the list would be really helpful.
-
Phil C ✭
Yes. Multi-select should have been here as soon as dropdowns were made available given the very obvious and mappable examples from web form objects.
可以从内容有人承认吗this outstanding request (3 years and counting) already?
-
Saylor ✭✭✭
I just came back from ENGAGE last week and I tracked down several staffers while I was there who confirmed that this functionality is coming. They danced around the specific time-frame of the release but I was led to believe that it will be by year-end. I was very encouraged coming away from ENGAGE and seeing their commitment to getting the users what they need.
-
I hope this is going to be implemented soon. With this function you should be able to "tag" each row. Essential for e.g. using Smartsheet as a DMS. Keep up the good work!
// David
-
Specific scenario for how I (desperately!) need to be able to select multiple options in dropdown lists: we use SmartSheet to track contact info of all the members and stakeholders of our 2 nonprofits. A number of them fall into multiple categories, like Joe S. is a board member AND a sponsor of this year's fair AND donated to last year's toy drive, etc. Currently, we keep track of this by creating a row for each member but a different column for each event and interaction we have with each member, ugh.
Since we're nearing the end of the year that was projected as being when this feature would be ready, I'm hoping it will be released very, very soon!
Thanks
-
Jamie Null ✭✭✭
One more vote for this request.
We have several use cases for multi-select. 1st is tracking our marketing content. We need to be able to multi-select from a web form all the departments that will benefit from the document, along with all our platforms, subthemes, and initiatives to categorize how the doc will be tagged.
2nd use case - We have our sponsors fill out a form to indicate what industries they are a part of. We need them to be able to choose all the various industries that apply.
3rd use case - Our sponsor grid has all the events that can be sponsored, and we'd like a multi-select for all the options they paid to sponsor (multi-select all available options). So our sales team can choose all available options and we can run reports on this with data accuracy.
-
Nicole ✭
+ 1我的投票的这个功能,我霍皮人ng it will be added soon.
-
Damor ✭
+1 - would love to have this feature.
-
Kate Hasse ✭✭✭
An example of how I'd use multi select drop downs:
We have a sheet for all the monthly reports that my team sends out to a variety of audiences. Some reports go to Managers, some reports go to Providers, some reports go to Managers AND Providers, etc., etc....
If I included in the drop down ALL the possible selections of audience combinations, it would be a very long list. I would like my team to easily to able to select more than one recipient of their monthly reports.
-
JeremyF ✭
We also require this functionality. Our use case is we use Smartsheet to track our IT Roadmap. Each row represents a high level gantt of project start and stop times. Each project has a number of 'Impacted Departments'. If I can select multiple departments, I can create a report showing IT project roadmap that affects them. The only work around now is to create a whole bunch of columns (about 20) that represent each department and put a check box in each. This is a UI nightmare.
-
This request flows right along with David Allen's "Getting Things Done" - just a simple tagging feature like Evernote's would be a step in the right direction. Please tell me this is coming with next week's big update.
-
Are there any updates when this function will be available? I really need this functionality for my Project Management.
Categories
How exactly is your Data Shuttle set up? If it is set to replace everything in the sheet when it runs, it is deleting the cell being referenced by the widget and then putting new data in new cells.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":108271,"type":"question","name":"Conditional formula - if a date is less than 30 days from today","excerpt":"I'm trying to create a conditional formula to flag if less than 30 days from today. I create a separate column to calculate but I am getting an error on the formula. =IF(AND([Event Date] > TODAY(), [Event Date] <= TODAY() + 30), \"Less than 30 days from today\", \"More than 30 days from today\") Help?","snippet":"I'm trying to create a conditional formula to flag if less than 30 days from today. I create a separate column to calculate but I am getting an error on the formula.…","categoryID":322,"dateInserted":"2023-07-28T18:21:58+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T19:22:21+00:00","insertUserID":159884,"insertUser":{"userID":159884,"name":"Connie Cochran","url":"https:\/\/community.smartsheet.com\/profile\/Connie%20Cochran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T19:21:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":159884,"lastUser":{"userID":159884,"name":"Connie Cochran","url":"https:\/\/community.smartsheet.com\/profile\/Connie%20Cochran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T19:21:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":23,"score":null,"hot":3381143059,"url":"https:\/\/community.smartsheet.com\/discussion\/108271\/conditional-formula-if-a-date-is-less-than-30-days-from-today","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108271\/conditional-formula-if-a-date-is-less-than-30-days-from-today","format":"Rich","lastPost":{"discussionID":108271,"commentID":387894,"name":"Re: Conditional formula - if a date is less than 30 days from today","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387894#Comment_387894","dateInserted":"2023-07-28T19:22:21+00:00","insertUserID":159884,"insertUser":{"userID":159884,"name":"Connie Cochran","url":"https:\/\/community.smartsheet.com\/profile\/Connie%20Cochran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T19:21:59+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-07-28T19:21:56+00:00","dateAnswered":"2023-07-28T18:55:42+00:00","acceptedAnswers":[{"commentID":387890,"body":"
Try this:<\/p>
=IF(ISDATE([Event Date]@row), IF(AND([Event Date]@row > TODAY(), [Event Date]@row <= TODAY(30)), \"Less than 30 days from today\", \"More than 30 days from today\"), \"\")<\/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":[]}">