Can i configure a workflow to alert someone when a specific entry is put in on a multi-select column

StephT
StephT ✭
inSmartsheet Basics

I have a form we are using to collect information on team activities. One of the form fields is a multi-select column where entrants can select all of the partner teams they will need to conduct the work outlined on the form. I'd like to send an alert to a "point of contact" for each team that is selected as a partner. The workflow wizard does not allow me to select a specific entry from the multi-select list - it only offers an option for when the field "changes". This does not work for what i need. In contrast, in a single-select field i am able to select from the drop-down list of eligible options. Please advise!

smartsheet-alert for multi-select.png


Tags:
· Share on Facebook Share on Twitter

Answers

Categories

We don't have this issue with our documents. I think this may be a setting on the text field in your PDF template. (In the software we use, it's called \"Multi-Line\")<\/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":370,"urlcode":"document-builder","name":"Document Builder"}]},{"discussionID":102437,"type":"question","name":"//www.santa-greenland.com/community/discussion/90896/\"Rename column\" option grayed out for Editor access on smartsheet","excerpt":"I have someone on my team who is Editor access, I am the Owner of the Smartsheet. She is unable to click on or use the \"rename column\" option in the drop down, it is grayed out. But I am able to see it and do it. Is there a way to address this for her? She is able to make edits and such.","categoryID":321,"dateInserted":"2023-03-10T16:26:27+00:00","dateUpdated":null,"dateLastComment":"2023-03-10T16:29:43+00:00","insertUserID":159265,"insertUser":{"userID":159265,"name":"thesabster","url":"https:\/\/community.smartsheet.com\/profile\/thesabster","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-10T16:41:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":86866,"lastUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2023-03-13T17:38:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":26,"score":null,"hot":3356931970,"url":"https:\/\/community.smartsheet.com\/discussion\/102437\/rename-column-option-grayed-out-for-editor-access-on-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102437\/rename-column-option-grayed-out-for-editor-access-on-smartsheet","format":"Rich","lastPost":{"discussionID":102437,"commentID":366750,"name":"Re: \"Rename column\" option grayed out for Editor access on smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/366750#Comment_366750","dateInserted":"2023-03-10T16:29:43+00:00","insertUserID":86866,"insertUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2023-03-13T17:38:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-10T16:42:06+00:00","dateAnswered":"2023-03-10T16:29:43+00:00","acceptedAnswers":[{"commentID":366750,"body":"

@thesabster<\/a> <\/p>

Only Licensed<\/em> Owners and Admins on a sheet can make structural changes (such as adding\/removing\/changing\/renaming columns) to a sheet.<\/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":[]},{"discussionID":102432,"type":"question","name":"Forms updating original sheet sporadically when Save As New... Project","excerpt":"Created a \"main project\" with, Forms, Reports, Dashboards, Workflows etc... when used for another project and complete a Save As New... say, Project#2 and when I use the forms etc..., the data is being updated in the \"main project', not Project#2. This is happening when I use it for many projects. When I Save as New, I…","categoryID":321,"dateInserted":"2023-03-10T16:02:14+00:00","dateUpdated":null,"dateLastComment":"2023-03-10T16:17:48+00:00","insertUserID":156452,"insertUser":{"userID":156452,"name":"Glen O","url":"https:\/\/community.smartsheet.com\/profile\/Glen%20O","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-10T17:29:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":156452,"lastUser":{"userID":156452,"name":"Glen O","url":"https:\/\/community.smartsheet.com\/profile\/Glen%20O","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-10T17:29:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3356930402,"url":"https:\/\/community.smartsheet.com\/discussion\/102432\/forms-updating-original-sheet-sporadically-when-save-as-new-project","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102432\/forms-updating-original-sheet-sporadically-when-save-as-new-project","format":"Rich","lastPost":{"discussionID":102432,"commentID":366746,"name":"Re: Forms updating original sheet sporadically when Save As New... Project","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/366746#Comment_366746","dateInserted":"2023-03-10T16:17:48+00:00","insertUserID":156452,"insertUser":{"userID":156452,"name":"Glen O","url":"https:\/\/community.smartsheet.com\/profile\/Glen%20O","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-10T17:29:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/1BMN8BOLQ1E9\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-10T16:17:29+00:00","dateAnswered":"2023-03-10T16:10:34+00:00","acceptedAnswers":[{"commentID":366743,"body":"

The new form will have a new URL, so you need to ensure you are using the new form. If you have the form on a dashboard through a Web Content widget, you will need to update this widget with the new form URL as well.<\/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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">