was not found\"","excerpt":"Working on implementing a basic webhook based smartsheet connector to fetch usage data for users under one organization. During the Oauth2.0 flow, requested for following scopes \"READ_USERS, ADMIN_USERS, ADMIN_WEBHOOKS\". I am making the following javascript-sdk api calls : - - smartsheetClient.users.listAllUsers…","categoryID":320,"dateInserted":"2019-09-10T16:17:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-11T18:43:57+00:00","insertUserID":92871,"insertUser":{"userID":92871,"name":"amitk-productiv","url":"https:\/\/community.smartsheet.com\/profile\/amitk-productiv","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-16T19:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":99141,"lastUser":{"userID":99141,"name":"dave-inden","url":"https:\/\/community.smartsheet.com\/profile\/dave-inden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-13T16:05:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":287,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/57416\/webhook-error-code-1151-scope-sheet-object-id-was-not-found","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/57416\/webhook-error-code-1151-scope-sheet-object-id-was-not-found","format":"Html","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":391,"urlcode":"product-development","name":"Product Development"}],"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":56496,"type":"discussion","name":"Python Script For Refresh Sheet","excerpt":"Hello Smartsheet Community, I need to write a script in Python to refresh a sheet. In my sheet I am using the Today function to calculate the total net days from one specific date. I take that data and use it as a widget on my dashboard. Problem is, the widget doesn't update unless the I physically open the sheet. Is there…","categoryID":320,"dateInserted":"2019-08-28T13:25:09+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-28T17:35:46+00:00","insertUserID":96856,"insertUser":{"userID":96856,"name":"vnjeffery96856","url":"https:\/\/community.smartsheet.com\/profile\/vnjeffery96856","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-07\/32\/3c\/n323cc445fe6b613a3132f9ad94c01563.jpg","dateLastActive":"2019-09-24T11:35:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":99141,"lastUser":{"userID":99141,"name":"dave-inden","url":"https:\/\/community.smartsheet.com\/profile\/dave-inden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-13T16:05:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1126,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/56496\/python-script-for-refresh-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56496\/python-script-for-refresh-sheet","format":"Html","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":227,"urlcode":"api-and-developers","name":"API and Developers"}],"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":56361,"type":"discussion","name":"Integration with ServiceNow, the ITSM tool","excerpt":"We use Servicenow for technical incident management. Some incidents evolve into work packages for specific tech teams. These teams use SmartSheet for task management. So migrating an incident in ServiceNow to an action item in SmartSheet would be handy. Anyone done that? ","categoryID":320,"dateInserted":"2019-08-27T13:24:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-27T15:04:39+00:00","insertUserID":28096,"insertUser":{"userID":28096,"name":"Dale Murphy","url":"https:\/\/community.smartsheet.com\/profile\/Dale%20Murphy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/09\/85\/n09854db3c85d2fcac04eb0a42036548e.jpg","dateLastActive":"2023-05-17T20:43: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-07-14T00:59:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":304,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/56361\/integration-with-servicenow-the-itsm-tool","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56361\/integration-with-servicenow-the-itsm-tool","format":"Html","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":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":56081,"type":"discussion","name":"smartsheet dashboard is not auto updating","excerpt":"Hi Team, Im leveraging the API to publish data to a smartsheet. Then i have a smart dashboard set up to graph that data. But when i push new data to the sheet, the dashboard charts don’t auto-update.[It says the source is modified but it’s not ...it is the same] I need this to be automatic, so when someone goes to the…","categoryID":320,"dateInserted":"2019-08-23T15:04:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-25T13:40:38+00:00","insertUserID":101386,"insertUser":{"userID":101386,"name":"sandeep","url":"https:\/\/community.smartsheet.com\/profile\/sandeep","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-23T15:02:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":99141,"lastUser":{"userID":99141,"name":"dave-inden","url":"https:\/\/community.smartsheet.com\/profile\/dave-inden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-13T16:05:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":917,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/56081\/smartsheet-dashboard-is-not-auto-updating","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56081\/smartsheet-dashboard-is-not-auto-updating","format":"Html","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}],"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":54981,"type":"discussion","name":"How to delete a column with conditional formatting rule using smartsheet C# SDK?","excerpt":"How to delete a column with conditional formatting rule using smartsheet C# SDK? We are getting error - \"The column specified is used in a conditional formatting rule, so the column cannot be deleted and its type cannot be changed.\".","categoryID":320,"dateInserted":"2019-08-13T03:52:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-20T11:11:36+00:00","insertUserID":99646,"insertUser":{"userID":99646,"name":"Buddhadev.Karmakar99646","url":"https:\/\/community.smartsheet.com\/profile\/Buddhadev.Karmakar99646","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-20T05:49:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45236,"lastUser":{"userID":45236,"name":"Alejandra","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Alejandra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-04\/8a\/fe\/n8afeceb592ad5845f46c7d931defba07.JPG","dateLastActive":"2020-05-15T18:56:51+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":124,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/54981\/how-to-delete-a-column-with-conditional-formatting-rule-using-smartsheet-c-sdk","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54981\/how-to-delete-a-column-with-conditional-formatting-rule-using-smartsheet-c-sdk","format":"Html","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":227,"urlcode":"api-and-developers","name":"API and Developers"}],"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":55096,"type":"discussion","name":"How to un-hide all columns in a smartsheet using smartsheet C# SDK?","excerpt":"How to un-hide all columns in a smartsheet using smartsheet C# SDK?","categoryID":320,"dateInserted":"2019-08-14T06:45:30+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-14T12:14:23+00:00","insertUserID":99646,"insertUser":{"userID":99646,"name":"Buddhadev.Karmakar99646","url":"https:\/\/community.smartsheet.com\/profile\/Buddhadev.Karmakar99646","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-20T05:49:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":81231,"lastUser":{"userID":81231,"name":"lmarchisio","url":"https:\/\/community.smartsheet.com\/profile\/lmarchisio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-03-11T19:23:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":188,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/55096\/how-to-un-hide-all-columns-in-a-smartsheet-using-smartsheet-c-sdk","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/55096\/how-to-un-hide-all-columns-in-a-smartsheet-using-smartsheet-c-sdk","format":"Html","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":227,"urlcode":"api-and-developers","name":"API and Developers"}],"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":55081,"type":"discussion","name":"Is there any way to delete a column with conditional formatting in smartsheet using smartsheet C# SD","excerpt":"Is there any way to delete a column with conditional formatting in smartsheet using smartsheet C# SDK?","categoryID":320,"dateInserted":"2019-08-14T00:52:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-14T11:00:18+00:00","insertUserID":99646,"insertUser":{"userID":99646,"name":"Buddhadev.Karmakar99646","url":"https:\/\/community.smartsheet.com\/profile\/Buddhadev.Karmakar99646","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-20T05:49:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":99141,"lastUser":{"userID":99141,"name":"dave-inden","url":"https:\/\/community.smartsheet.com\/profile\/dave-inden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-13T16:05:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":223,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/55081\/is-there-any-way-to-delete-a-column-with-conditional-formatting-in-smartsheet-using-smartsheet-c-sd","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/55081\/is-there-any-way-to-delete-a-column-with-conditional-formatting-in-smartsheet-using-smartsheet-c-sd","format":"Html","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":227,"urlcode":"api-and-developers","name":"API and Developers"}],"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":54871,"type":"discussion","name":"Delete all conditional formatting in a smartsheet using smartsheet C# SDK","excerpt":"How we can delete all conditional formatting in a smartsheet using smartsheet C# SDK?","categoryID":320,"dateInserted":"2019-08-12T06:56:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-13T04:22:51+00:00","insertUserID":99646,"insertUser":{"userID":99646,"name":"Buddhadev.Karmakar99646","url":"https:\/\/community.smartsheet.com\/profile\/Buddhadev.Karmakar99646","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-20T05:49:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":99646,"lastUser":{"userID":99646,"name":"Buddhadev.Karmakar99646","url":"https:\/\/community.smartsheet.com\/profile\/Buddhadev.Karmakar99646","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-20T05:49:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":102,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/54871\/delete-all-conditional-formatting-in-a-smartsheet-using-smartsheet-c-sdk","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54871\/delete-all-conditional-formatting-in-a-smartsheet-using-smartsheet-c-sdk","format":"Html","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":227,"urlcode":"api-and-developers","name":"API and Developers"}],"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":54801,"type":"discussion","name":"using external data in a form and sheet and for validation","excerpt":"Our company has an internal application. I would like to reference this application's data in a form and in a sheet: * When a user is submitting a form, it lets them select a value from a drop down that is populated from data in this external application * When a user is submitting a form, it lets them enter free-form text…","categoryID":320,"dateInserted":"2019-08-09T14:03:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-09T14:59:01+00:00","insertUserID":99546,"insertUser":{"userID":99546,"name":"nacho","url":"https:\/\/community.smartsheet.com\/profile\/nacho","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-09T12:11:07+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-07-14T00:59:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":354,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/54801\/using-external-data-in-a-form-and-sheet-and-for-validation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54801\/using-external-data-in-a-form-and-sheet-and-for-validation","format":"Html","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":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"}],"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}">
If the column names are similar<\/em> but not exactly the same as the ones on the sheet, it is possible that some rows have been moved from another sheet with a similar purpose. <\/p>
You should be able to see this in the Activity Log (if you have access), but the other giveaway will be that will data in the similarly named columns but not the original ones.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":107283,"type":"question","name":"Determine all of the workflows a user is assigned to\/included in","excerpt":"Prior to deactivating a Smartsheet user, is there a way to see what workflows they were assigned to across all Smartsheet items? Oftentimes, the employee replacing that user will need to replace them in the workflows. Is there an easy way to do this? Even just knowing what workflows someone is involved in would be VERY…","snippet":"Prior to deactivating a Smartsheet user, is there a way to see what workflows they were assigned to across all Smartsheet items? Oftentimes, the employee replacing that user will…","categoryID":320,"dateInserted":"2023-07-06T15:31:33+00:00","dateUpdated":null,"dateLastComment":"2023-07-07T12:57:30+00:00","insertUserID":163180,"insertUser":{"userID":163180,"name":"mgainey","url":"https:\/\/community.smartsheet.com\/profile\/mgainey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-13T12:46:30+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-07-13T20:48:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":41,"score":null,"hot":3377393943,"url":"https:\/\/community.smartsheet.com\/discussion\/107283\/determine-all-of-the-workflows-a-user-is-assigned-to-included-in","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107283\/determine-all-of-the-workflows-a-user-is-assigned-to-included-in","format":"Rich","lastPost":{"discussionID":107283,"commentID":384139,"name":"Re: Determine all of the workflows a user is assigned to\/included in","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384139#Comment_384139","dateInserted":"2023-07-07T12:57:30+00:00","insertUserID":45516,"insertUser":{"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-07-13T20:48:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-06T21:09:46+00:00","dateAnswered":"2023-07-06T17:23:30+00:00","acceptedAnswers":[{"commentID":383983,"body":"
Unfortunately there is no way to pull\/generate a report for this. It is a very manual process.<\/p>
<\/p>
Feel free to browse through the Product Ideas tab at the top of this page to see if someone has submitted the enhancement request. If they have, you can add your vote. If they have not, then you can submit it yourself and allow others to add their votes.<\/p>
<\/p>
Either way, it would be great if you could post a link to the enhancement request here so that others searching for the same thing can easily add their votes.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":107096,"type":"question","name":"Get a sheet URL with the Sheet ID [API]","excerpt":"I'm using Python and I want to get the URL of a sheet if I know its sheet ID. I try to create a list of hyperlink thru the API. I already have access to the sheet and I could copy the url by hand, but that is not the point.","snippet":"I'm using Python and I want to get the URL of a sheet if I know its sheet ID. I try to create a list of hyperlink thru the API. I already have access to the sheet and I could copy…","categoryID":320,"dateInserted":"2023-06-29T17:31:17+00:00","dateUpdated":null,"dateLastComment":"2023-07-03T12:14:17+00:00","insertUserID":152316,"insertUser":{"userID":152316,"name":"Christian G.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/8ZFKAYNV3BAL\/n8XVTBY1DO7FK.png","dateLastActive":"2023-07-12T18:15:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":152316,"lastUser":{"userID":152316,"name":"Christian G.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/8ZFKAYNV3BAL\/n8XVTBY1DO7FK.png","dateLastActive":"2023-07-12T18:15:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":66,"score":null,"hot":3376447534,"url":"https:\/\/community.smartsheet.com\/discussion\/107096\/get-a-sheet-url-with-the-sheet-id-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107096\/get-a-sheet-url-with-the-sheet-id-api","format":"Rich","tagIDs":[563],"lastPost":{"discussionID":107096,"commentID":383485,"name":"Re: Get a sheet URL with the Sheet ID [API]","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383485#Comment_383485","dateInserted":"2023-07-03T12:14:17+00:00","insertUserID":152316,"insertUser":{"userID":152316,"name":"Christian G.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/8ZFKAYNV3BAL\/n8XVTBY1DO7FK.png","dateLastActive":"2023-07-12T18:15:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-03T12:14:33+00:00","dateAnswered":"2023-06-29T23:14:11+00:00","acceptedAnswers":[{"commentID":383235,"body":"
Try this: <\/p>
import smartsheet<\/p>
# Set your Smartsheet API access token<\/p>
access_token = 'YOUR_ACCESS_TOKEN'<\/p>
# Set the sheet ID for which you want to retrieve the URL<\/p>
sheet_id = 'YOUR_SHEET_ID'<\/p>
# Initialize the Smartsheet client<\/p>
client = smartsheet.Smartsheet(access_token)<\/p>
# Get the sheet details using the sheet ID<\/p>
sheet = client.Sheets.get_sheet(sheet_id)<\/p>
# Retrieve the URL from the sheet details<\/p>
sheet_url = sheet.permalink<\/p>
print(f'The URL of the sheet is: {sheet_url}')<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":563,"urlcode":"api","name":"API"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=320&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":204,"limit":3},"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
