自动化

Changes to Any Value Run Workflow When Triggered So, everything pulled into the sheet…","categoryID":322,"dateInserted":"2020-10-10T13:46:46+00:00","dateUpdated":null,"dateLastComment":"2020-10-10T15:38:48+00:00","insertUserID":116755,"insertUser":{"userID":116755,"name":"Mike Rini","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Rini","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7qFD-6EKX_o!7KdAe1VbTDw!eGBY2moMFCj","dateLastActive":"2022-11-18T19:56:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":121890,"lastUser":{"userID":121890,"name":"Ramzi K","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ramzi%20K","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/SANQ6N8O1FSK\/n1MST7KW5A43V.png","dateLastActive":"2020-11-03T16:33:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":49,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72105\/row-copying-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72105\/row-copying-issue","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"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":68442,"type":"discussion","name":"Automations - Enable field and status updates in Card Templates","excerpt":"It would be wonderful if Automations could make specific updates to field and status values when using a Card Template. For example, let's use assume I am using the following template structure: Status(s): Backlog, Current, Complete Field(s): Description, Due Date, Done (check field) Now let's assume I want to make sure…","categoryID":321,"dateInserted":"2020-05-19T16:31:51+00:00","dateUpdated":null,"dateLastComment":"2020-10-09T21:38:24+00:00","insertUserID":121690,"insertUser":{"userID":121690,"name":"Christina Wu","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20Wu","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DQ_Qw3y-zn4!7N1Xe8NOTOQ!CDDmw0DLECI","dateLastActive":"2020-06-01T23:24:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-12-06T11:27:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":42,"score":1,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/68442\/automations-enable-field-and-status-updates-in-card-templates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68442\/automations-enable-field-and-status-updates-in-card-templates","format":"rich","groupID":null,"statusID":0,"attributes":{},"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":72036,"type":"question","name":"Copy rows in automation leave original sheet but don't appear on new sheet","excerpt":"Hi- I set up an automation to copy rows with any value added in a specific column to a new sheet. When a value is added, the rows have disappeared from my original sheet however they have not moved\/appeared in the sheet they were meant to be move to. Help!","categoryID":321,"dateInserted":"2020-10-08T15:53:48+00:00","dateUpdated":null,"dateLastComment":"2020-10-08T17:44:49+00:00","insertUserID":127360,"insertUser":{"userID":127360,"name":"Katelyn Kazan","url":"https:\/\/community.smartsheet.com\/profile\/Katelyn%20Kazan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-08T16:35:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":120260,"lastUser":{"userID":120260,"name":"David Tutwiler","title":"","url":"https:\/\/community.smartsheet.com\/profile\/David%20Tutwiler","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GiIpuCpV7Zvo9nduJmLt8ULNYObTVazzemdnIiy6w=s96-c","dateLastActive":"2022-12-01T21:16:31+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72036\/copy-rows-in-automation-leave-original-sheet-but-dont-appear-on-new-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72036\/copy-rows-in-automation-leave-original-sheet-but-dont-appear-on-new-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":72037,"type":"question","name":"Multi-Select & Automated Notifications","excerpt":"I'm trying to create an Automated Workflow for Requesting Budget Updates. We some times have to send out Update Requests for Monthly Budgets - obviously the number of months will vary client to client. My question is - is there a way (using Conditions, Formulas, etc.) that I can setup one Automated Notification that would…","categoryID":322,"dateInserted":"2020-10-08T15:56:45+00:00","dateUpdated":null,"dateLastComment":"2020-10-08T16:35:04+00:00","insertUserID":116755,"insertUser":{"userID":116755,"name":"Mike Rini","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Rini","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7qFD-6EKX_o!7KdAe1VbTDw!eGBY2moMFCj","dateLastActive":"2022-11-18T19:56:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":116755,"lastUser":{"userID":116755,"name":"Mike Rini","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Rini","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7qFD-6EKX_o!7KdAe1VbTDw!eGBY2moMFCj","dateLastActive":"2022-11-18T19:56:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":38,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72037\/multi-select-automated-notifications","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72037\/multi-select-automated-notifications","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"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":71949,"type":"question","name":"Automation Workflow - Exclude Hidden Fields","excerpt":"I have a SmartSheet that has several hidden columns that drive other visible column values, conditional formatting, etc. I set up an Automation Workflow to send an update via email when rows are added or changed. The email that is sent from the workflow includes ALL the hidden columns, whether those values changed or not.…","categoryID":321,"dateInserted":"2020-10-06T17:45:20+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T16:13:44+00:00","insertUserID":127252,"insertUser":{"userID":127252,"name":"Rick Moerloos","url":"https:\/\/community.smartsheet.com\/profile\/Rick%20Moerloos","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hFjd4exAI6Y!83jed2gf-iQ!Ijw0bg4G_06","dateLastActive":"2020-10-15T15:56:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":127252,"lastUser":{"userID":127252,"name":"Rick Moerloos","url":"https:\/\/community.smartsheet.com\/profile\/Rick%20Moerloos","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hFjd4exAI6Y!83jed2gf-iQ!Ijw0bg4G_06","dateLastActive":"2020-10-15T15:56:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":311,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/71949\/automation-workflow-exclude-hidden-fields","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71949\/automation-workflow-exclude-hidden-fields","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-06T18:23:01+00:00","dateAnswered":"2020-10-06T18:22:19+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":333,"urlcode":"Workflows in Smartsheet","name":"Workflows in Smartsheet"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">