讨论ssions
> has submitted a new request. The request…","categoryID":321,"dateInserted":"2023-06-16T18:25:31+00:00","dateUpdated":"2023-06-19T08:27:13+00:00","dateLastComment":"2023-06-16T18:54:24+00:00","insertUserID":156053,"insertUser":{"userID":156053,"name":"jl.furstenberg","url":"https:\/\/community.smartsheet.com\/profile\/jl.furstenberg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T19:39:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"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-22T19:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":73,"score":1,"hot":3373883695,"url":"https:\/\/community.smartsheet.com\/discussion\/106563\/embed-smartsheet-fields-into-automation-emails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106563\/embed-smartsheet-fields-into-automation-emails","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T08:27:32+00:00","dateAnswered":"2023-06-16T18:49:50+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":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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":105186,"type":"question","name":"DocuSign Integration Help","excerpt":"Hello, New to DocuSign integration. Have gone through the mapping wizard, but when it comes time to actually drag and drop the Smartsheet fields to the PDF, I cannot do so. I read through the Smartsheet instructions and noted that you have to update the Manage PDF form fill data option to assign to placeholder (see…","categoryID":343,"dateInserted":"2023-05-12T16:54:24+00:00","dateUpdated":null,"dateLastComment":"2023-06-05T23:03:14+00:00","insertUserID":156053,"insertUser":{"userID":156053,"name":"jl.furstenberg","url":"https:\/\/community.smartsheet.com\/profile\/jl.furstenberg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T19:39:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":143059,"lastUser":{"userID":143059,"name":"Lesa Weaver","url":"https:\/\/community.smartsheet.com\/profile\/Lesa%20Weaver","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-18T15:44:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":240,"score":null,"hot":3369920258,"url":"https:\/\/community.smartsheet.com\/discussion\/105186\/docusign-integration-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105186\/docusign-integration-help","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-15T09:19:06+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":370,"urlcode":"document-builder","name":"Document Builder"},{"tagID":500,"urlcode":"docusign","name":"DocuSign"}],"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":105286,"type":"question","name":"Calculating Time Duration with In\/Out","excerpt":"Hello, I have reviewed several posts on calculating time worked from in\/out time entries. I tried to use one of the formulas previously presented (see screenshot), but I keep getting an Invalid Operation error. If it helps, I am trying to calculate time worked using the 12 hour format.","categoryID":322,"dateInserted":"2023-05-16T13:49:53+00:00","dateUpdated":null,"dateLastComment":"2023-05-17T12:39:40+00:00","insertUserID":156053,"insertUser":{"userID":156053,"name":"jl.furstenberg","url":"https:\/\/community.smartsheet.com\/profile\/jl.furstenberg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T19:39:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":156053,"lastUser":{"userID":156053,"name":"jl.furstenberg","url":"https:\/\/community.smartsheet.com\/profile\/jl.furstenberg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T19:39:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":82,"score":null,"hot":3368573973,"url":"https:\/\/community.smartsheet.com\/discussion\/105286\/calculating-time-duration-with-in-out","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105286\/calculating-time-duration-with-in-out","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XFI6SS1ZI35S\/screenshot-05-16.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 05-16.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-16T21:50:25+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":499,"urlcode":"time-calculation","name":"Time Calculation"}],"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":104402,"type":"idea","name":"Enhancement Request - Automations","excerpt":"Hello, Would love to see enhancements to the automated workflows. Please make the dialog boxes bigger\/expandable! Additionally, if there could be an option to create a workflow and multi-select date fields from your spreadsheet, that would be amazing. Otherwise, I have to set-up a ton of the exact same automations for…","categoryID":349,"dateInserted":"2023-04-24T20:03:23+00:00","dateUpdated":"2023-04-27T19:45:59+00:00","dateLastComment":"2023-04-25T18:54:43+00:00","insertUserID":156053,"insertUser":{"userID":156053,"name":"jl.furstenberg","url":"https:\/\/community.smartsheet.com\/profile\/jl.furstenberg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T19:39:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":107276,"lastUserID":145232,"lastUser":{"userID":145232,"name":"Arsineh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Arsineh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDsrqb_Bq8s!xPC1MQ0l5vQ!cZTCNClbVWr","dateLastActive":"2023-08-16T17:37:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":35,"score":2,"hot":3364992562,"url":"https:\/\/community.smartsheet.com\/discussion\/104402\/enhancement-request-automations","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104402\/enhancement-request-automations","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":104252,"type":"question","name":"Data Shuttle or other solution?","excerpt":"Hello, I am trying to figure out the best solution to a project. Basically, we have a system outside of Smartsheet that will not connect to Smartsheet (old system) and we do not want to pay to integrate them. I want to manually upload exports from the legacy system (.CSV files) into a preformatted Smartsheet sheet on a…","categoryID":343,"dateInserted":"2023-04-20T13:15:57+00:00","dateUpdated":null,"dateLastComment":"2023-04-24T12:42:09+00:00","insertUserID":156053,"insertUser":{"userID":156053,"name":"jl.furstenberg","url":"https:\/\/community.smartsheet.com\/profile\/jl.furstenberg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T19:39:45+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-22T19:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":85,"score":null,"hot":3364339086,"url":"https:\/\/community.smartsheet.com\/discussion\/104252\/data-shuttle-or-other-solution","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104252\/data-shuttle-or-other-solution","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-20T16:12:15+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":381,"urlcode":"DataMesh","name":"DataMesh"},{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}],"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":103141,"type":"question","name":"Reports- HELP","excerpt":"Hello, I am trying to set-up a weekly report, by coordinator, and am having trouble. Essentially, I want the report to include any row information with dates in the current week. The trouble is, each row has multiple dates and I only want to search for most recent date column by row and have only that information included…","categoryID":322,"dateInserted":"2023-03-24T17:54:07+00:00","dateUpdated":null,"dateLastComment":"2023-03-29T14:27:26+00:00","insertUserID":156053,"insertUser":{"userID":156053,"name":"jl.furstenberg","url":"https:\/\/community.smartsheet.com\/profile\/jl.furstenberg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T19:39:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":156053,"lastUser":{"userID":156053,"name":"jl.furstenberg","url":"https:\/\/community.smartsheet.com\/profile\/jl.furstenberg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T19:39:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":93,"score":null,"hot":3359785893,"url":"https:\/\/community.smartsheet.com\/discussion\/103141\/reports-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103141\/reports-help","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-27T13:16:09+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":[],"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":false,"noCheckboxes":true}">