Integrations

Issue or Request --> Request type select --> Subtype1 --> Subtype 2 --? etc... --> Issue type select etc... all the way down... As the user makes selections, more options are presented. The…","categoryID":321,"dateInserted":"2023-08-21T22:07:42+00:00","dateUpdated":null,"dateLastComment":"2023-08-21T22:41:22+00:00","insertUserID":137695,"insertUser":{"userID":137695,"name":"Tim Starkey","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Starkey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uolS96T7mzo!84NRtwSFw3o!n5WODiM4TKP","dateLastActive":"2023-09-27T23:24:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":137695,"lastUser":{"userID":137695,"name":"Tim Starkey","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Starkey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uolS96T7mzo!84NRtwSFw3o!n5WODiM4TKP","dateLastActive":"2023-09-27T23:24:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":71,"score":null,"hot":3385314544,"url":"https:\/\/community.smartsheet.com\/discussion\/109243\/forms-best-practice-to-reduce-columns-when-using-forms-with-logic","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109243\/forms-best-practice-to-reduce-columns-when-using-forms-with-logic","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-21T17:36:10+00:00","dateAnswered":"2023-08-21T22:29: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":204,"urlcode":"forms","name":"Forms"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"tagID":390,"urlcode":"best-practice","name":"Best Practice"}],"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":109207,"type":"discussion","name":"Workaround for PowerBI Navigator record limit","excerpt":"Problem statement: When looking to utilise PowerBI via the Live Data Connector I was unable to find the sheets I wanted to connect. Cause: The PowerBI Navigator will return a maximum of 10,000 records from a given source. Workaround: I've managed to work around this by setting up a second DSN connection for the Live Data…","categoryID":320,"dateInserted":"2023-08-21T16:36:42+00:00","dateUpdated":"2023-08-21T16:39:06+00:00","dateLastComment":"2023-08-21T16:36:42+00:00","insertUserID":155488,"insertUser":{"userID":155488,"name":"Philip Robbins","url":"https:\/\/community.smartsheet.com\/profile\/Philip%20Robbins","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-4no90-uIrI!xNtmsTeX5jo!5WoIURH70Ke","dateLastActive":"2023-09-29T09:44:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":155488,"lastUserID":155488,"lastUser":{"userID":155488,"name":"Philip Robbins","url":"https:\/\/community.smartsheet.com\/profile\/Philip%20Robbins","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-4no90-uIrI!xNtmsTeX5jo!5WoIURH70Ke","dateLastActive":"2023-09-29T09:44:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":95,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/109207\/workaround-for-powerbi-navigator-record-limit","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109207\/workaround-for-powerbi-navigator-record-limit","format":"Rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":277,"urlcode":"integrations","name":"Integrations"}],"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":84853,"type":"question","name":"Document Builder - Adobe Calculated Fields","excerpt":"Hello community, I am currently loading a PDF that was made using adobe acrobat pro into the Document Builder as a template. There is a date field that always needs to default to today's date. I currently have the field calculating off the following script: var today = new Date(); event.value = util.printd(\"m\/d\/yyyy\",…","categoryID":343,"dateInserted":"2021-11-10T17:48:18+00:00","dateUpdated":"2022-06-14T14:38:41+00:00","dateLastComment":"2023-08-18T06:45:19+00:00","insertUserID":140412,"insertUser":{"userID":140412,"name":"Hannah E.","url":"https:\/\/community.smartsheet.com\/profile\/Hannah%20E.","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gg7RVgPRXoucSnBsTOAqoC5Uhks0HaYS07eugo0=s96-c","dateLastActive":"2021-11-10T22:50:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":165319,"lastUser":{"userID":165319,"name":"oranester","url":"https:\/\/community.smartsheet.com\/profile\/oranester","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtflNUXbHaoJnNn5rRrHYgt4HKT1h9wWPdZc7aLTToIBsA=s96-c","dateLastActive":"2023-08-18T08:33:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":361,"score":null,"hot":3328909417,"url":"https:\/\/community.smartsheet.com\/discussion\/84853\/document-builder-adobe-calculated-fields","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84853\/document-builder-adobe-calculated-fields","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-11-11T18:11:00+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":268,"urlcode":"attachments","name":"Attachments"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":370,"urlcode":"document-builder","name":"Document Builder"}],"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":108961,"type":"question","name":"Transfer ownership of integrations\/connectors","excerpt":"I have a few integrations I have created using the Microsoft Dynamics, Salesforce and Jira connectors and I wish to transfer them to another user. We are centralizing the support of Smartsheet support and I need another user to take over the support and ownership of the connectors. Is there any way to do it or do they need…","categoryID":343,"dateInserted":"2023-08-15T13:47:30+00:00","dateUpdated":null,"dateLastComment":"2023-08-17T13:58:46+00:00","insertUserID":161013,"insertUser":{"userID":161013,"name":"Warren B","title":"Client Director","url":"https:\/\/community.smartsheet.com\/profile\/Warren%20B","photoUrl":"https:\/\/lh3.googleusercontent.com\/-Sp3wrfB38N0\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuucm7xDoWs4OLroSR2uI3bE2R24ozCQ\/s96-c\/photo.jpg","dateLastActive":"2023-08-15T13:58:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-09-29T14:43:14+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":142,"score":null,"hot":3384388576,"url":"https:\/\/community.smartsheet.com\/discussion\/108961\/transfer-ownership-of-integrations-connectors","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108961\/transfer-ownership-of-integrations-connectors","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-08-17T13:58:46+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":277,"urlcode":"integrations","name":"Integrations"},{"tagID":450,"urlcode":"jira-connector","name":"Jira Connector"},{"tagID":475,"urlcode":"salesforce-connector","name":"Salesforce Connector"}],"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":108907,"type":"question","name":"Dynamic View Detail Panel not displaying selected fields","excerpt":"I have a Dynamic View built from a report with 59 columns. The original sheet has 130 columns. I set up the Detail Panel to display 19 of those columns. I do not have any conditional formatting set up and none of the fields are hidden or required. When I click into the Detail Panel, it is not displaying some of the columns…","categoryID":343,"dateInserted":"2023-08-14T14:13:31+00:00","dateUpdated":null,"dateLastComment":"2023-08-16T18:50:24+00:00","insertUserID":162821,"insertUser":{"userID":162821,"name":"egardner","title":"IT Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/egardner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4VRPFNVQ0MWG\/n8WTXSBZQZI0N.JPG","dateLastActive":"2023-09-08T13:46:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"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-09-29T14:43:14+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":168,"score":null,"hot":3384237235,"url":"https:\/\/community.smartsheet.com\/discussion\/108907\/dynamic-view-detail-panel-not-displaying-selected-fields","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108907\/dynamic-view-detail-panel-not-displaying-selected-fields","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/3OVUGQCB2VEM\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-08-16T18:50:24+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":277,"urlcode":"integrations","name":"Integrations"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}],"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":74464,"type":"question","name":"Dynamic View: Un-editable Fields","excerpt":"I am having an issue with Dynamic View treating (random) editable fields as \"Read Only.\" In this instance, Dynamic View is treating a Date Field as if it were a \"Read Only.\" In the first screen shot, you will see that the \"Date Resolved\" field is not marked as \"Read Only\" in the design mode, however, when you open the View…","categoryID":343,"dateInserted":"2021-01-05T00:42:38+00:00","dateUpdated":"2022-06-14T14:37:35+00:00","dateLastComment":"2023-08-16T11:18:51+00:00","insertUserID":35501,"insertUser":{"userID":35501,"name":"Michael Wilkesen","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Wilkesen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DzPdwzxewv4!mSlcvvBnMDw!-8USDYJeXkG","dateLastActive":"2023-08-15T18:29:37+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-09-29T14:43:14+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":19,"countViews":1182,"score":null,"hot":3302003489,"url":"https:\/\/community.smartsheet.com\/discussion\/74464\/dynamic-view-un-editable-fields","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74464\/dynamic-view-un-editable-fields","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/FBDYA7WK07KX\/annotation-2021-01-04-01.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Annotation 2021-01-04 01.jpg"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-01-05T00:44: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":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"}],"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":106841,"type":"question","name":"Has anyone integrated smartsheets and Microsoft Powerapps?","excerpt":"I am attempting to use smartsheets as a data source in powerapps and then transfer the data from powerapps into a new row in smartsheets and was wondering if anyone has been able to extract data from smartsheets into powerapps and also transfer data back to smartsheets. There is little documentation on the formatting of…","categoryID":343,"dateInserted":"2023-06-23T17:22:50+00:00","dateUpdated":null,"dateLastComment":"2023-08-15T20:12:13+00:00","insertUserID":162708,"insertUser":{"userID":162708,"name":"JackTaylor","url":"https:\/\/community.smartsheet.com\/profile\/JackTaylor","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtekV-z6YwweJbQ7PXneLAp0pY3vx8VYo77oM5lN=s96-c","dateLastActive":"2023-07-14T18:54:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164591,"lastUser":{"userID":164591,"name":"echopogi","title":"Sr Analyst","url":"https:\/\/community.smartsheet.com\/profile\/echopogi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BylpAafyICI!25Eov2PkY_o!Na4vM8GpyCI","dateLastActive":"2023-08-29T15:55:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":280,"score":null,"hot":3379673103,"url":"https:\/\/community.smartsheet.com\/discussion\/106841\/has-anyone-integrated-smartsheets-and-microsoft-powerapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106841\/has-anyone-integrated-smartsheets-and-microsoft-powerapps","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-26T19:08:32+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":277,"urlcode":"integrations","name":"Integrations"}],"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}">