Salesforce Connector

Smartsheet Connector Error (Notifications could not be reset)","excerpt":"Reporting an issue that has become a total blocker for our team. The Smartsheet Salesforce connector was working without issue for years and recently became completely stuck due to the following errors: \"We've detected a problem receiving notifications from SALESFORCE. Please press the “Reset” button to try to reset the…","categoryID":343,"dateInserted":"2023-05-30T16:17:32+00:00","dateUpdated":null,"dateLastComment":"2023-05-31T08:50:08+00:00","insertUserID":138025,"insertUser":{"userID":138025,"name":"Andrew Cotter","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Cotter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T17:28:59+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-08-24T19:12:48+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":148,"score":null,"hot":3370987060,"url":"https:\/\/community.smartsheet.com\/discussion\/105790\/salesforce-smartsheet-connector-error-notifications-could-not-be-reset","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105790\/salesforce-smartsheet-connector-error-notifications-could-not-be-reset","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/7959JSCVA70P\/error2-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"error2.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-31T08:50:08+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":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":105765,"type":"question","name":"How do I extract full URL from Hyperlink cell?","excerpt":"Hi all I have this Opportunity ID column in my sheet that's connected to Salesforce. All cells are hyperlinked with the opportunity in Salesforce. This column is created like this by the Salesforce-Smartsheet connector and it's handy because of the hyperlink. I need to send the Salesforce URL to another sheet, but if I…","categoryID":322,"dateInserted":"2023-05-29T06:43:37+00:00","dateUpdated":null,"dateLastComment":"2023-05-29T13:58:08+00:00","insertUserID":137899,"insertUser":{"userID":137899,"name":"Bruno Menezes","url":"https:\/\/community.smartsheet.com\/profile\/Bruno%20Menezes","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTteHzSlZOnlEvmOhPH7voCL6Az0vkP6ZlBbmSKQqofw6CQ=s96-c","dateLastActive":"2023-07-19T23:39:15+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-08-24T20:19:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":120,"score":null,"hot":3370711905,"url":"https:\/\/community.smartsheet.com\/discussion\/105765\/how-do-i-extract-full-url-from-hyperlink-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105765\/how-do-i-extract-full-url-from-hyperlink-cell","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/67G6C9LFPMGZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-29T22:13:31+00:00","dateAnswered":"2023-05-29T13:58:08+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":331,"urlcode":"hyperlink","name":"hyperlink"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":475,"urlcode":"salesforce-connector","name":"Salesforce Connector"},{"tagID":530,"urlcode":"url","name":"URL"},{"tagID":531,"urlcode":"links","name":"Links"}],"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":104441,"type":"question","name":"Salesforce Connector Sync - Don't send automation if not synced?","excerpt":"We use SF connector as our go between. We send a lot of automations out from Smartsheet for various reasons. Is there a way for an automation to not send if a row is no longer synced with the connector? IE a customer cancels and therefore is no longer synced and is filtered out by connector. We don't want the daily…","categoryID":343,"dateInserted":"2023-04-25T15:42:25+00:00","dateUpdated":null,"dateLastComment":"2023-05-01T21:22:28+00:00","insertUserID":144154,"insertUser":{"userID":144154,"name":"Travis Ryan","url":"https:\/\/community.smartsheet.com\/profile\/Travis%20Ryan","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbmmorskPWfniQbqu9gQ45m0h0ZCkqG4wwb2I4i=s96-c","dateLastActive":"2023-05-02T23:14:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":148800,"lastUser":{"userID":148800,"name":"HeatherD.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/HeatherD.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!n0lGP-EXATs!bB9HG8ENRvs!xyI8qfE88hc","dateLastActive":"2023-08-23T18:54:16+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":86,"score":null,"hot":3365414093,"url":"https:\/\/community.smartsheet.com\/discussion\/104441\/salesforce-connector-sync-dont-send-automation-if-not-synced","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104441\/salesforce-connector-sync-dont-send-automation-if-not-synced","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-01T21:22:28+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"},{"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":104452,"type":"idea","name":"Smartsheet Connector \"Recycle Bin,\" to recover deleted\/disabled Connector workflows","excerpt":"Please add a \"Recycle bin\" type feature to Smartsheet's Connector to allow for deleted and disabled connectors to be easily recovered! Received an emailed alert on Saturday that a connector workflow (in the Smartsheet + Salesforce Connector) had been disabled due to a Salesforce user credential expiring. Despite…","categoryID":349,"dateInserted":"2023-04-25T18:54:05+00:00","dateUpdated":null,"dateLastComment":"2023-04-26T15:45:45+00:00","insertUserID":160872,"insertUser":{"userID":160872,"name":"CBroderick","title":"Project & Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/CBroderick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-26T20:43:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":160872,"lastUser":{"userID":160872,"name":"CBroderick","title":"Project & Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/CBroderick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-26T20:43:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":47,"score":5,"hot":3364975490,"url":"https:\/\/community.smartsheet.com\/discussion\/104452\/smartsheet-connector-recycle-bin-to-recover-deleted-disabled-connector-workflows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104452\/smartsheet-connector-recycle-bin-to-recover-deleted-disabled-connector-workflows","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":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":450,"urlcode":"jira-connector","name":"Jira Connector"},{"tagID":475,"urlcode":"salesforce-connector","name":"Salesforce Connector"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":103880,"type":"discussion","name":"Return of the Connectors Navigation Button on the Sheet!","excerpt":"Hi Community, This release adds back in the “Smartsheet Connectors” button (now as a single button) to the sheet Feature Bar (previously known as the right rail), improving the ease of connecting sheets to Salesforce, Jira, or Microsoft Dynamics 365 and viewing the status of connector workflows. If a workflow exists on a…","categoryID":335,"dateInserted":"2023-04-11T18:29:53+00:00","dateUpdated":null,"dateLastComment":"2023-04-11T18:29:53+00:00","insertUserID":152988,"insertUser":{"userID":152988,"name":"Danielle Wilson","url":"https:\/\/community.smartsheet.com\/profile\/Danielle%20Wilson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZZDXWctIdZQ!BrDQwSiqPOQ!J3oBfQ3Wq2i","dateLastActive":"2023-08-23T12:42:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":152988,"lastUser":{"userID":152988,"name":"Danielle Wilson","url":"https:\/\/community.smartsheet.com\/profile\/Danielle%20Wilson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZZDXWctIdZQ!BrDQwSiqPOQ!J3oBfQ3Wq2i","dateLastActive":"2023-08-23T12:42:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":true,"pinLocation":"category","closed":false,"sink":false,"countComments":0,"countViews":66,"score":1,"hot":1681238093,"url":"https:\/\/community.smartsheet.com\/discussion\/103880\/return-of-the-connectors-navigation-button-on-the-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103880\/return-of-the-connectors-navigation-button-on-the-sheet","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/W1E0Q98WCCLS\/workflow-not-created-282-29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Workflow not created (2).png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","allowedDiscussionTypes":[]},"tags":[{"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":103066,"type":"idea","name":"Salesforce Connector API version Update","excerpt":"Need to have SF Connector be able to interact and use data from API Version 38 or newer. See response from support below. Without this ability to interact with the newer API the connector cannot be used for all the reasons we spend money to use it for. Scheduling and Field service data is not able to be interacted with…","categoryID":349,"dateInserted":"2023-03-23T14:10:18+00:00","dateUpdated":null,"dateLastComment":"2023-03-23T14:10:18+00:00","insertUserID":144154,"insertUser":{"userID":144154,"name":"Travis Ryan","url":"https:\/\/community.smartsheet.com\/profile\/Travis%20Ryan","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbmmorskPWfniQbqu9gQ45m0h0ZCkqG4wwb2I4i=s96-c","dateLastActive":"2023-05-02T23:14:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":144154,"lastUser":{"userID":144154,"name":"Travis Ryan","url":"https:\/\/community.smartsheet.com\/profile\/Travis%20Ryan","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbmmorskPWfniQbqu9gQ45m0h0ZCkqG4wwb2I4i=s96-c","dateLastActive":"2023-05-02T23:14:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":74,"score":1,"hot":1679580918,"url":"https:\/\/community.smartsheet.com\/discussion\/103066\/salesforce-connector-api-version-update","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103066\/salesforce-connector-api-version-update","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":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":475,"urlcode":"salesforce-connector","name":"Salesforce Connector"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">