Integrations

is not a valid user for the given JIRA project' sync error when using the Jira Connector tool for Smartsheet? This error just started appearing and no project permissions have been changed in our Jira account. We have all projects set to allow issue field read\/write…","categoryID":343,"dateInserted":"2019-06-06T22:51:39+00:00","dateUpdated":"2022-06-22T09:56:09+00:00","dateLastComment":"2022-08-16T13:42:51+00:00","insertUserID":91226,"insertUser":{"userID":91226,"name":"KML","url":"https:\/\/community.smartsheet.com\/profile\/KML","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-06T22:40:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":151427,"lastUser":{"userID":151427,"name":"Frederik V","url":"https:\/\/community.smartsheet.com\/profile\/Frederik%20V","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bbsvWxY5VTs!pCsvKRZkqrs!AquQ5ttwsIi","dateLastActive":"2022-08-16T14:01:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":17,"countViews":1395,"score":null,"hot":3220529070,"url":"https:\/\/community.smartsheet.com\/discussion\/50021\/getting-is-not-a-valid-user-for-the-given-jira-project-sync-error-with-jira-connector","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/50021\/getting-is-not-a-valid-user-for-the-given-jira-project-sync-error-with-jira-connector","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":82099,"type":"question","name":"DataShuttle Error: Access Token is Invalid","excerpt":"Hi, I have a datashuttle that's been working for several weeks but today gave the error: Workflow Execute: Your Access Token is Invalid. I didn't use any API to create this datashuttle, and we don't have JIRA connected.","categoryID":343,"dateInserted":"2021-08-12T17:48:12+00:00","dateUpdated":"2022-06-14T14:38:25+00:00","dateLastComment":"2022-08-15T14:14:27+00:00","insertUserID":125124,"insertUser":{"userID":125124,"name":"Ryan P Anderson","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20P%20Anderson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uiDRJ0iim9Q!u6Fep2aQpHo!5ocrb0EsT8E","dateLastActive":"2023-04-05T18:23:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":133037,"lastUser":{"userID":133037,"name":"ygoldgrab","url":"https:\/\/community.smartsheet.com\/profile\/ygoldgrab","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T15:20:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":225,"score":null,"hot":3289364559,"url":"https:\/\/community.smartsheet.com\/discussion\/82099\/datashuttle-error-access-token-is-invalid","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/82099\/datashuttle-error-access-token-is-invalid","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-08-13T09:18:44+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":[]},"tags":[{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"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":93782,"type":"question","name":"SharePoint document link attachment option","excerpt":"It would be great if as well as all the Dropbox, Google Drive, oneDrive and other file attachment options, we could also have a direct 'Link' option for SharePoint document libraries, document sets\/folders. Leading practice for document management suggests not to store documents in proprietary databases (such as Smartsheet…","categoryID":321,"dateInserted":"2022-08-01T06:55:49+00:00","dateUpdated":null,"dateLastComment":"2022-08-15T06:42:26+00:00","insertUserID":137089,"insertUser":{"userID":137089,"name":"Adrian @ Chess","title":"Managing Director","url":"https:\/\/community.smartsheet.com\/profile\/Adrian%20%40%20Chess","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/Q3AKFSIMT4LI\/n46GTRXZF0SQ2.png","dateLastActive":"2023-06-06T04:04:16+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-06-08T09:56:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":216,"score":null,"hot":3319884495,"url":"https:\/\/community.smartsheet.com\/discussion\/93782\/sharepoint-document-link-attachment-option","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93782\/sharepoint-document-link-attachment-option","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/F798T050587U\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-01T08:27:37+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":268,"urlcode":"Attachments","name":"Attachments"},{"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}">

The Power of Velocity
Share your Process Power and consider answering the following questions: Is your power something you intuited or something you learned? My power is intuitive. I have always been about working smart and automation to get a process completed as quickly as can be but most importantly, correct. Describe a time when you…
Pivot App Zero Values
Hi All, I'm using Pivot App to summarize the number of records from a variety of reports. It works great, but if there are no records in a report, the pivot table will report blank. I was hoping for a "0" value, as I'm pushing the data in these fields as number summary in the Dashboards/Portals. Other than creating new…
SharePoint document link as an option under Attachments
It would be great if as well as all the Dropbox, Google Drive, oneDrive and other file attachment options, we could also have a direct 'Link' option for SharePoint document libraries, document sets/folders. Leading practice for document management suggests not to store documents in proprietary databases (such as Smartsheet…
Linking an Excel cell to Smartsheet a cell
亲爱的,我想收集状态更新test scripts created and used in Excel and present it in Smartsheet. All test scripts in Excel have one cell indicating the percentage completion level of the test script. Objective is to link that one cell to Smartsheet sheet where I present the list of all test scripts…
Does anyone have experience with handling JWT data with Bridge?
We're using Google PubSub service to receive updates notifications and they come with JWT encoding in the web hook endpoint. Does anyone have managed to decode JWT payload in Bridge since we cannot run libraries in Bridge and there's no working Javascript to decode it. Thanks!
What is best way to move SmartSheet column data to D365?
It does not appear that Data Shuttle can move data from SmartSheet to D365 tables. I imagine that we could build a custom flow using Power Automate assuming Power Automate has a connector to SmartSheet. But just wondering what other solutions or ideas are out there that someone has successfully implemented. I see there is…
Sending form attachments to their own smartsheet or google drive folder
Hi everyone, We're currently trying to create a system that accepts form entries with attachments and stores those attachments in their own folder as soon as they are submitted. Preferrably, we would like this folder to update in real time and remove any attachments that are replaced when the same user uploads a different…
Getting '...is not a valid user for the given JIRA project' sync error with Jira Connector
Does anyone know how to correct the ' is not a valid user for the given JIRA project' sync error when using the Jira Connector tool for Smartsheet? This error just started appearing and no project permissions have been changed in our Jira account. We have all projects set to allow issue field read/write…
DataShuttle Error: Access Token is Invalid
Hi, I have a datashuttle that's been working for several weeks but today gave the error: Workflow Execute: Your Access Token is Invalid. I didn't use any API to create this datashuttle, and we don't have JIRA connected.
SharePoint document link attachment option
It would be great if as well as all the Dropbox, Google Drive, oneDrive and other file attachment options, we could also have a direct 'Link' option for SharePoint document libraries, document sets/folders. Leading practice for document management suggests not to store documents in proprietary databases (such as Smartsheet…

Integrations

Discussion List