Automations

Send to Microsoft Teams | How to not include other rows","excerpt":"When we sent the alert to MS Teams, all rows are being included + the custom message. Is there an option not to include those, just the custom message?","categoryID":321,"dateInserted":"2021-11-10T14:17:04+00:00","dateUpdated":null,"dateLastComment":"2021-11-11T18:02:32+00:00","insertUserID":139461,"insertUser":{"userID":139461,"name":"heyjay","url":"https:\/\/community.smartsheet.com\/profile\/heyjay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-08T13:18:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":120297,"lastUser":{"userID":120297,"name":"Brett Wyrick","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brett%20Wyrick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G0J454DHMOIP\/n57O99FWK2XDE.png","dateLastActive":"2022-11-29T23:05:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":315,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/84841\/alert-someone-send-to-microsoft-teams-how-to-not-include-other-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84841\/alert-someone-send-to-microsoft-teams-how-to-not-include-other-rows","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-11-11T14:02:59+00:00","dateAnswered":"2021-11-10T22:55:27+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":83935,"type":"question","name":"Automated Workflow Condition was not met but workflow executed","excerpt":"I created an automated workflow with the trigger to request a status from contacts in a cell on a bi-weekly basis if the following conditions are met. There were multiple requests sent to the contacts whose applications didn't have the Disposition listed below. Is there a limit on the number of conditions in an automated…","categoryID":321,"dateInserted":"2021-10-12T14:21:20+00:00","dateUpdated":null,"dateLastComment":"2021-11-10T20:51:42+00:00","insertUserID":125064,"insertUser":{"userID":125064,"name":"Lisa Blair","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Blair","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mlDB327VWeQ!bYjAWyroUqY!VlWgX32LGKA","dateLastActive":"2021-11-10T20:46:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":125064,"lastUser":{"userID":125064,"name":"Lisa Blair","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Blair","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mlDB327VWeQ!bYjAWyroUqY!VlWgX32LGKA","dateLastActive":"2021-11-10T20:46:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":200,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/83935\/automated-workflow-condition-was-not-met-but-workflow-executed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/83935\/automated-workflow-condition-was-not-met-but-workflow-executed","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/A5I4ZPV34FSI\/ss-condition.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SS-Condition.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-10-13T11:55:57+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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}]},{"discussionID":84857,"type":"question","name":"Can you have hidden fields on a form become visible depending on value in another field?","excerpt":"So on the user end of the form, I have, for example, a Yes\/No question about a meal. Question: Will you be attending the luncheon If answer is Yes, then additional fields will appear asking about meal choices, accommodations, etc. If the computer says No, then the fields regarding the luncheon will stay hidden. Is this…","categoryID":321,"dateInserted":"2021-11-10T19:29:16+00:00","dateUpdated":null,"dateLastComment":"2021-11-10T20:06:34+00:00","insertUserID":134189,"insertUser":{"userID":134189,"name":"AKunce","title":"","url":"https:\/\/community.smartsheet.com\/profile\/AKunce","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-22T17:56:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":134189,"lastUser":{"userID":134189,"name":"AKunce","title":"","url":"https:\/\/community.smartsheet.com\/profile\/AKunce","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-22T17:56:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":346,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/84857\/can-you-have-hidden-fields-on-a-form-become-visible-depending-on-value-in-another-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84857\/can-you-have-hidden-fields-on-a-form-become-visible-depending-on-value-in-another-field","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-11-10T20:05:46+00:00","dateAnswered":"2021-11-10T19:53:34+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":84820,"type":"question","name":"Having trouble with one of my Move Row Workflows","excerpt":"Hi gang, I'm having difficulty with one of my workflows to trigger......I have no trouble with other sheets using the Move a Row, except this one sheet. Below is the actual workflow. The \"Status\" field is a dropdown and manually updated on the sheet. The Archive sheet is a duplicate of the active sheet. I have other #1 -…","categoryID":322,"dateInserted":"2021-11-09T19:37:10+00:00","dateUpdated":null,"dateLastComment":"2021-11-09T19:50:07+00:00","insertUserID":73006,"insertUser":{"userID":73006,"name":"Don Wilcox","url":"https:\/\/community.smartsheet.com\/profile\/Don%20Wilcox","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-15T22:54:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":73006,"lastUser":{"userID":73006,"name":"Don Wilcox","url":"https:\/\/community.smartsheet.com\/profile\/Don%20Wilcox","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-15T22:54:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":54,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/84820\/having-trouble-with-one-of-my-move-row-workflows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84820\/having-trouble-with-one-of-my-move-row-workflows","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/QCRCBB4BYBQW\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-11-09T19:50:14+00:00","dateAnswered":"2021-11-09T19:50:07+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":84779,"type":"question","name":"Automated Workflow to Assign People Not Working Consistently","excerpt":"Hi! I just created a workflow to assign contact to 'Responsible Designee' column when 'Risk' column changes to AR, HR or SURVIVOR. So, the automation works on some rows, but not all. Screenshots below (only showing one of the automated workflows). Any ideas?? Thank you!!","categoryID":321,"dateInserted":"2021-11-08T23:19:34+00:00","dateUpdated":null,"dateLastComment":"2021-11-09T18:53:14+00:00","insertUserID":123105,"insertUser":{"userID":123105,"name":"Thu Nghiem","url":"https:\/\/community.smartsheet.com\/profile\/Thu%20Nghiem","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T22:37:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":123105,"lastUser":{"userID":123105,"name":"Thu Nghiem","url":"https:\/\/community.smartsheet.com\/profile\/Thu%20Nghiem","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T22:37:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":258,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/84779\/automated-workflow-to-assign-people-not-working-consistently","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84779\/automated-workflow-to-assign-people-not-working-consistently","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/M17TFA3BO5TM\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-11-09T18:53:16+00:00","dateAnswered":"2021-11-09T10:49:10+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":84766,"type":"question","name":"Approval workflow - How to delegate approvals and capture who approved?","excerpt":"Hi, I am building an approval workflow in Smartsheet to track PTO requests. The workflow is built to send approvals to the employee's manager. What I am trying to do is build a process to delegate approval when managers are on PTO for example and track who approved. I was initially thinking of updating the \"Reports to\"…","categoryID":321,"dateInserted":"2021-11-08T18:53:47+00:00","dateUpdated":null,"dateLastComment":"2021-11-09T14:43:25+00:00","insertUserID":128146,"insertUser":{"userID":128146,"name":"Anne-Solene Monrouzeau","url":"https:\/\/community.smartsheet.com\/profile\/Anne-Solene%20Monrouzeau","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-26T22:48:41+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-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":529,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/84766\/approval-workflow-how-to-delegate-approvals-and-capture-who-approved","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84766\/approval-workflow-how-to-delegate-approvals-and-capture-who-approved","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/YDG93VR2M5Q7\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-11-09T14:43:25+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":84362,"type":"question","name":"Request for Update - Set Expire Date\/Days","excerpt":"We are using Smartsheet to manage a weekly work schedule. There is a workflow that sends \"Request an update\" to employees the ability to pickup an open shift. Do to volume of calculations and space limitations, the schedule is managed in a a master sheet: Master sheet is a two-week (14days) schedule Planning for new…","categoryID":322,"dateInserted":"2021-10-25T18:42:50+00:00","dateUpdated":null,"dateLastComment":"2021-11-09T13:47:53+00:00","insertUserID":13761,"insertUser":{"userID":13761,"name":"Gladys Liley","url":"https:\/\/community.smartsheet.com\/profile\/Gladys%20Liley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-24T16:18:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":13761,"lastUser":{"userID":13761,"name":"Gladys Liley","url":"https:\/\/community.smartsheet.com\/profile\/Gladys%20Liley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-24T16:18:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":227,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/84362\/request-for-update-set-expire-date-days","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84362\/request-for-update-set-expire-date-days","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-10-29T15:29:49+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">