Add Ons and Integrations

Smartsheet integration active and in use. We are finding that many of the Workflows that are syncing Sheets to Jira are disabling at an unpredictable volume and frequency. When reviewing the run logs for these disabled Workflows, I see the error \"Your Access Token is invalid\". Despite re-enabling the…","categoryID":343,"dateInserted":"2020-08-20T20:05:21+00:00","dateUpdated":"2022-06-14T14:37:12+00:00","dateLastComment":"2020-08-22T12:10:11+00:00","insertUserID":123952,"insertUser":{"userID":123952,"name":"Lawrence Blanco","url":"https:\/\/community.smartsheet.com\/profile\/Lawrence%20Blanco","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-09T18:05:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":125444,"lastUser":{"userID":125444,"name":"Krunal Lathiya","url":"https:\/\/community.smartsheet.com\/profile\/Krunal%20Lathiya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/1ULLLWOP8INT\/nPP9M03MA1IPL.jpg","dateLastActive":"2020-08-26T08:47:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1177,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/70755\/receiving-error-your-access-token-is-invalid","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70755\/receiving-error-your-access-token-is-invalid","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":[],"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":70544,"type":"question","name":"Parsing out a multi select cell into different rows for Tableau connection","excerpt":"Hi! Has anyone had experience with trying to connect SS multi select cells into Tableau so Tableau can read each item in the multi select cell? If there isn't a way to do it in Tableau I'm thinking I need to find a way to copy the row in SS down and have one item from the multi select cell in each row. So, if the multi…","categoryID":343,"dateInserted":"2020-08-12T14:20:03+00:00","dateUpdated":"2022-06-14T14:37:10+00:00","dateLastComment":"2020-08-21T13:17:00+00:00","insertUserID":89371,"insertUser":{"userID":89371,"name":"alexis.ray89371","url":"https:\/\/community.smartsheet.com\/profile\/alexis.ray89371","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-21T15:20:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"lastUserID":89371,"lastUser":{"userID":89371,"name":"alexis.ray89371","url":"https:\/\/community.smartsheet.com\/profile\/alexis.ray89371","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-21T15:20:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":386,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/70544\/parsing-out-a-multi-select-cell-into-different-rows-for-tableau-connection","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70544\/parsing-out-a-multi-select-cell-into-different-rows-for-tableau-connection","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/UUCNI4KAFYYZ\/data-in-ss-image-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Data in SS Image.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":[],"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":70594,"type":"question","name":"Pivot App - Dynamic Updating","excerpt":"Hi, I'm trying to create a Pivot Chart using the pivot app based on a number of sheets in a workspace. As it doesn't allow me to pivot on data from a workspace i have created a report, this works and i'm able to pivot on that data. The problem i have is when i pivot on the pivot sheet it has created a row called grand…","categoryID":343,"dateInserted":"2020-08-13T21:57:57+00:00","dateUpdated":"2022-06-14T14:37:11+00:00","dateLastComment":"2020-08-19T18:26:35+00:00","insertUserID":119333,"insertUser":{"userID":119333,"name":"Michael Foster","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Foster","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-03T21:35:08+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-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":719,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70594\/pivot-app-dynamic-updating","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70594\/pivot-app-dynamic-updating","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":[],"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":70550,"type":"question","name":"Auto Project Provisioning with Control Center","excerpt":"We have Control Center setup in our solution for managing IT Projects. Currently, we can manually provision a project through Control Center. How do we setup Control Center to automatically provision projects based on specific criteria?","categoryID":343,"dateInserted":"2020-08-12T16:51:53+00:00","dateUpdated":"2022-06-14T14:37:11+00:00","dateLastComment":"2020-08-13T22:53:26+00:00","insertUserID":115749,"insertUser":{"userID":115749,"name":"Jason Duryea","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20Duryea","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucoN485Er-68imH5a6nIxiSUecQ96Py8krC4N2-LQQ=s96-c","dateLastActive":"2022-09-21T11:15:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":115749,"lastUser":{"userID":115749,"name":"Jason Duryea","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20Duryea","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucoN485Er-68imH5a6nIxiSUecQ96Py8krC4N2-LQQ=s96-c","dateLastActive":"2022-09-21T11:15:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":440,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/70550\/auto-project-provisioning-with-control-center","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70550\/auto-project-provisioning-with-control-center","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-13T22:53:48+00:00","dateAnswered":"2020-08-13T22:53:26+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":[],"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":70412,"type":"question","name":"Migrate power bi collection to power bi embeded","excerpt":"I tried to follow the article to migrate power bi collection to power bi embedded (msdn article here). However, I got stuck very quickly. For example, in our app, we use these nuget packages (Microsoft.PowerBI.Api and powerbi.core), and these are some of our usages: client.Reports.GetReportsAsync(this.workspaceCollection,…","categoryID":343,"dateInserted":"2020-08-06T13:44:38+00:00","dateUpdated":"2022-06-14T14:37:10+00:00","dateLastComment":"2020-08-10T09:05:11+00:00","insertUserID":124896,"insertUser":{"userID":124896,"name":"Maxwell Gren","url":"https:\/\/community.smartsheet.com\/profile\/Maxwell%20Gren","photoUrl":"https:\/\/lh5.googleusercontent.com\/-Qk8-qIzXtrI\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuucl9cAytKz0wRaMODXOzz-uWL2WSTQ\/photo.jpg","dateLastActive":"2020-09-21T14:24:02+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-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":68,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/70412\/migrate-power-bi-collection-to-power-bi-embeded","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70412\/migrate-power-bi-collection-to-power-bi-embeded","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":[],"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}">