Automations

Discussion List

fail => send \"thank you\" email Thank you very much, hope you guys have great day","categoryID":322,"dateInserted":"2021-10-25T11:39:54+00:00","dateUpdated":null,"dateLastComment":"2021-10-25T14:38:10+00:00","insertUserID":141189,"insertUser":{"userID":141189,"name":"Hoang Le","url":"https:\/\/community.smartsheet.com\/profile\/Hoang%20Le","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-12-03T03:54:47+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-07-12T21:24:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":228,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/84340\/auto-send-email-template","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84340\/auto-send-email-template","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-10-25T14:38:10+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":215,"urlcode":"Templates","name":"Templates"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"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":84147,"type":"question","name":"Workflow Triggered Unexpectedly","excerpt":"I created individual workflows to trigger weekly on Thursdays if the following conditions were not met: ● Created \"is not today\" AND ● Center \"is one of\"
At the specified time an email was sent to the designated recipients to remind them to submit an update. In most cases, the center submitted its update the same…","categoryID":321,"dateInserted":"2021-10-19T16:58:57+00:00","dateUpdated":"2021-10-20T12:30:00+00:00","dateLastComment":"2021-10-21T16:47:25+00:00","insertUserID":119518,"insertUser":{"userID":119518,"name":"Amy Arnold","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Arnold","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!GpdD39UP27w!B_9DgcE2Wfo!f-wVNvq4uBf","dateLastActive":"2023-01-29T09:06:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-12T21:05:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":144,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/84147\/workflow-triggered-unexpectedly","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84147\/workflow-triggered-unexpectedly","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HASAFL8W7YTF\/smartsheet-2c-vaccination-reminder.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet, Vaccination Reminder.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-10-21T16:47: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":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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":84262,"type":"question","name":"Setting up Update Requests for a monthly\/quarterly basis","excerpt":"I'm trying to create an Update Request notification for certain rows in my sheet, but to be sent out on either a quarterly or monthly basis. More specifics--I am in a legal dept at a mortgage company, and trying to track common questions our regulators ask commonly. There are items where our responses may change on a…","categoryID":321,"dateInserted":"2021-10-21T14:42:29+00:00","dateUpdated":"2021-10-21T14:42:50+00:00","dateLastComment":"2021-10-21T14:56:35+00:00","insertUserID":125557,"insertUser":{"userID":125557,"name":"Sam Clapp","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Sam%20Clapp","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5ONb-ZAfabw!HDdan1QniLo!iPDpoghm1Ji","dateLastActive":"2023-06-20T13:30:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":125557,"lastUserID":125557,"lastUser":{"userID":125557,"name":"Sam Clapp","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Sam%20Clapp","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5ONb-ZAfabw!HDdan1QniLo!iPDpoghm1Ji","dateLastActive":"2023-06-20T13:30:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":337,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/84262\/setting-up-update-requests-for-a-monthly-quarterly-basis","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84262\/setting-up-update-requests-for-a-monthly-quarterly-basis","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-10-21T14:56:12+00:00","dateAnswered":"2021-10-21T14:52:01+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":274,"urlcode":"Legal","name":"Legal"},{"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":84244,"type":"question","name":"How to calcualate time difference","excerpt":"Hi Team, How to calculate time difference 10:00:30 AM Start Time - 11:12:00 AM Regards,","categoryID":322,"dateInserted":"2021-10-21T09:58:25+00:00","dateUpdated":null,"dateLastComment":"2021-10-21T12:38:55+00:00","insertUserID":134534,"insertUser":{"userID":134534,"name":"Finops C'ship","url":"https:\/\/community.smartsheet.com\/profile\/Finops%20C%27ship","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-11-10T14:23:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":130356,"lastUser":{"userID":130356,"name":"Parker Oxford","url":"https:\/\/community.smartsheet.com\/profile\/Parker%20Oxford","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZBHf2V6JZ_4!mwDcf2rfX2Q!HQPLAAJvjas","dateLastActive":"2023-04-27T14:19:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":273,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/84244\/how-to-calcualate-time-difference","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84244\/how-to-calcualate-time-difference","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-10-21T12:38:55+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"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":83462,"type":"question","name":"Assign Workflow issue","excerpt":"I think I've been looking at this for too long and I need help! I received this message \"We had additional conditions set up that didn't show disabled, but wouldn't assign on this workflow so we changed them to be OR and apparently it still isn't assigning but isn't showing as broken either\" In the attached picture, is…","categoryID":321,"dateInserted":"2021-09-24T20:58:02+00:00","dateUpdated":null,"dateLastComment":"2021-10-20T15:59:20+00:00","insertUserID":101536,"insertUser":{"userID":101536,"name":"adegeus101536","url":"https:\/\/community.smartsheet.com\/profile\/adegeus101536","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-24T12:57:11+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-07-12T20:38:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":101,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/83462\/assign-workflow-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/83462\/assign-workflow-issue","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-10-08T07:55:35+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"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}]},{"discussionID":84126,"type":"question","name":"Automated Workflows with multiple actions are not working","excerpt":"I have an automated workflow set to trigger anytime the value of a cell in a specific column changed. The workflow has 2 actions: Notify a Specific Person (me) and Change the Value of a Cell (In this case, it is a the cell is a checkbox and I want to set the value to checked. The workflow is sending me notifications when…","categoryID":321,"dateInserted":"2021-10-18T23:19:45+00:00","dateUpdated":"2021-10-18T23:26:10+00:00","dateLastComment":"2021-10-19T19:34:34+00:00","insertUserID":140934,"insertUser":{"userID":140934,"name":"RevTechWC","url":"https:\/\/community.smartsheet.com\/profile\/RevTechWC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-10-21T14:35:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":140934,"lastUserID":748,"lastUser":{"userID":748,"name":"Paul H","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20H","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4B2ZHK6WTG0P\/nCNUXTFBXTV5W.jpg","dateLastActive":"2023-07-06T01:58:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":634,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/84126\/automated-workflows-with-multiple-actions-are-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84126\/automated-workflows-with-multiple-actions-are-not-working","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-10-19T06:37:52+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":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":84065,"type":"question","name":"What’s the best method to add new automated workflows to existing projects?","excerpt":"Is there a way to use Global Updates to add automation rules to active projects? We are under an enterprise plan with control center I want to add several new automation rules to all active projects (200+) I do not want to do this manually for every active project. Any recommended options would be appreciated. Example Use…","categoryID":321,"dateInserted":"2021-10-15T14:55:09+00:00","dateUpdated":null,"dateLastComment":"2021-10-18T12:18:51+00:00","insertUserID":110436,"insertUser":{"userID":110436,"name":"BO'Neil","url":"https:\/\/community.smartsheet.com\/profile\/BO%27Neil","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cuHAR9le-f4!u2jCJ-1AmiQ!8VxeMVO7GD-","dateLastActive":"2022-06-21T20:29:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":110436,"lastUser":{"userID":110436,"name":"BO'Neil","url":"https:\/\/community.smartsheet.com\/profile\/BO%27Neil","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cuHAR9le-f4!u2jCJ-1AmiQ!8VxeMVO7GD-","dateLastActive":"2022-06-21T20:29:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":81,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/84065\/what-s-the-best-method-to-add-new-automated-workflows-to-existing-projects","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84065\/what-s-the-best-method-to-add-new-automated-workflows-to-existing-projects","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-10-18T12:18:57+00:00","dateAnswered":"2021-10-18T12:18:51+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":83991,"type":"question","name":"How can I convert text names to existing contacts in my account?","excerpt":"I manually imported an Excel file into Smartsheet that has hundreds of names as text (no e-mail addresses) which I'd like to use to pull existing contacts in my account. The first and last names match to what's in my account. I've changed the column on my sheet to 'Contacts' thinking I'd be able to leverage contacts in my…","categoryID":321,"dateInserted":"2021-10-13T18:44:40+00:00","dateUpdated":null,"dateLastComment":"2021-10-17T07:42:46+00:00","insertUserID":140785,"insertUser":{"userID":140785,"name":"Rpotashnik","url":"https:\/\/community.smartsheet.com\/profile\/Rpotashnik","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-11-09T18:54:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":127340,"lastUser":{"userID":127340,"name":"Bassam Khalil","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Bassam%20Khalil","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf7UK_uIEyXZAONqmsQXBPSfVi5-GCzNLZawKE6bV9IIEk=s96-c","dateLastActive":"2023-07-12T06:35:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":530,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/83991\/how-can-i-convert-text-names-to-existing-contacts-in-my-account","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/83991\/how-can-i-convert-text-names-to-existing-contacts-in-my-account","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-10-17T07:42:46+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":219,"urlcode":"Sheets","name":"Sheets"},{"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":71666,"type":"question","name":"Automated Copy a parent level row without the children","excerpt":"We have a desire to generate metrics from our multiple project backlogs (grids with parent\/child hierarchy). The parent level indicates a deliverable product and that is what will drive our metric. In order to populate a grid from which to derive the metrics, I'd like to automate copying the parent row without its child…","categoryID":321,"dateInserted":"2020-09-28T20:05:55+00:00","dateUpdated":"2020-09-28T20:24:05+00:00","dateLastComment":"2021-10-16T21:41:47+00:00","insertUserID":126746,"insertUser":{"userID":126746,"name":"Andy Vohs","url":"https:\/\/community.smartsheet.com\/profile\/Andy%20Vohs","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!hgHVId8oNv4!hmjUoStU9aQ!qoRyRrIKuup","dateLastActive":"2021-12-14T18:10:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":126746,"lastUserID":125212,"lastUser":{"userID":125212,"name":"Neil Watson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Neil%20Watson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pglbKXXltro!HIFbX6W_ivo!Lnqe5-nvNY5","dateLastActive":"2023-07-13T00:51:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":414,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/71666\/automated-copy-a-parent-level-row-without-the-children","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71666\/automated-copy-a-parent-level-row-without-the-children","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-10-01T15:22:21+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":83895,"type":"question","name":"Regarding Data Shuttle offloading","excerpt":"Good morning\/afternoon All, I am attempting to creating an auto offload of a sheet using Data Shuttle, but keep running into this error each time I attempt to run the automation: \"Workflow Execute: A required header was missing or invalid: Content-Length\" The sheet has 47 columns and about 200 rows. I am trying to back up…","categoryID":343,"dateInserted":"2021-10-11T14:43:49+00:00","dateUpdated":"2022-06-14T14:38:35+00:00","dateLastComment":"2021-10-15T19:26:24+00:00","insertUserID":136825,"insertUser":{"userID":136825,"name":"Yogesh Patel, MBA","url":"https:\/\/community.smartsheet.com\/profile\/Yogesh%20Patel%2C%20MBA","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!319c_1IsgPw!xrDqsToX_Ps!EVy33Wjo8lp","dateLastActive":"2021-10-15T19:25:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":136825,"lastUser":{"userID":136825,"name":"Yogesh Patel, MBA","url":"https:\/\/community.smartsheet.com\/profile\/Yogesh%20Patel%2C%20MBA","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!319c_1IsgPw!xrDqsToX_Ps!EVy33Wjo8lp","dateLastActive":"2021-10-15T19:25:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":251,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/83895\/regarding-data-shuttle-offloading","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/83895\/regarding-data-shuttle-offloading","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-10-15T19:26:35+00:00","dateAnswered":"2021-10-13T22:46:48+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">