\". \"HTTPError: Response code 500 (Internal Server Error)\" The project update API works correctly for those projects without any activity. I wonder if this is a bug for 10,000ft…","categoryID":320,"dateInserted":"2020-10-28T15:57:38+00:00","dateUpdated":"2021-02-17T10:36:18+00:00","dateLastComment":"2020-10-29T19:51:50+00:00","insertUserID":97466,"insertUser":{"userID":97466,"name":"G Chen","url":"https:\/\/community.smartsheet.com\/profile\/G%20Chen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hAnBYZlsJz4!pP1E6QMpocQ!7mU-m9ZIhil","dateLastActive":"2021-02-19T17:48:11+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-07-12T18:18:50+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":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72650\/10-000ft-update-project-error-using-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72650\/10-000ft-update-project-error-using-api","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-11-02T20:12:45+00:00","dateAnswered":"2020-10-29T19:51:50+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":468,"urlcode":"resource-management","name":"Resource 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":72670,"type":"question","name":"Can I auto-tab to a new field in forms when scanning barcodes","excerpt":"I am attempting to use barcode 128 with a control code to tab into the next field. When I scan the barcodes I am being pushed out into the address bar, instead of the next field. I've tried the Codes for Horizontal Tab, Vertical Tab, Line Feed and Form Feed. Is there a special code for smartsheet? I'm not super savvy, but…","categoryID":320,"dateInserted":"2020-10-28T20:23:51+00:00","dateUpdated":null,"dateLastComment":"2020-10-29T19:50:08+00:00","insertUserID":127578,"insertUser":{"userID":127578,"name":"Bethany Cotton","url":"https:\/\/community.smartsheet.com\/profile\/Bethany%20Cotton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pMDUKeyFpOY!!GKhU1nMbuM7","dateLastActive":"2022-05-21T18:43:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":115578,"lastUser":{"userID":115578,"name":"David Joyeuse","url":"https:\/\/community.smartsheet.com\/profile\/David%20Joyeuse","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2021-08-19T14:05:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":153,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72670\/can-i-auto-tab-to-a-new-field-in-forms-when-scanning-barcodes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72670\/can-i-auto-tab-to-a-new-field-in-forms-when-scanning-barcodes","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"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":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":72594,"type":"question","name":"Need help in setting SAML SSO for Transform Holding Cooperation","excerpt":"Team, We need to setup SAML SSO between THC and smartsheet. For this we need below mentioned details. Request you to please provide the same : • XML metadata for their assertion consumer service (ACS), • a list of the LDAP attributes to be sent (if any. e.g.: givenName, sn, mail, uid, etc.), • which attribute is to be used…","categoryID":320,"dateInserted":"2020-10-27T06:37:06+00:00","dateUpdated":null,"dateLastComment":"2020-10-29T16:03:44+00:00","insertUserID":128034,"insertUser":{"userID":128034,"name":"Priyanka Khandelwal","url":"https:\/\/community.smartsheet.com\/profile\/Priyanka%20Khandelwal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-29T15:17:33+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-07-12T18:18:50+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":73,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72594\/need-help-in-setting-saml-sso-for-transform-holding-cooperation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72594\/need-help-in-setting-saml-sso-for-transform-holding-cooperation","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"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":72508,"type":"question","name":"how do I get sheet size in bytes prior to download into pdf","excerpt":"I want get the sheet size in bytes. how do I get sheet size in bytes prior to download into pdf","categoryID":320,"dateInserted":"2020-10-23T09:19:58+00:00","dateUpdated":null,"dateLastComment":"2020-10-29T10:27:34+00:00","insertUserID":118726,"insertUser":{"userID":118726,"name":"mukund waghmode","url":"https:\/\/community.smartsheet.com\/profile\/mukund%20waghmode","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgyCLPDK66Zbp2sRXGXg6Ke4F53dgFz5EoAKXUV=s96-c","dateLastActive":"2020-11-04T04:52:49+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-07-12T18:18:50+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":62,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/72508\/how-do-i-get-sheet-size-in-bytes-prior-to-download-into-pdf","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72508\/how-do-i-get-sheet-size-in-bytes-prior-to-download-into-pdf","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-11-02T04:59:33+00:00","dateAnswered":"2020-10-29T10:27:34+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"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":72548,"type":"question","name":"I am trying to get access token using Oauth","excerpt":"I am trying to integrate Power Automate (Workflow service) with SmartSheet using OAuth 2.0 I have got the code successfully and when I finally try to get the token, it throws the message - 'You are not authorized to perform this action.' with error code 1004 I tried in Postman with same result. Any help would be much…","categoryID":320,"dateInserted":"2020-10-24T21:46:49+00:00","dateUpdated":"2020-10-28T15:42:52+00:00","dateLastComment":"2020-10-28T16:45:19+00:00","insertUserID":127975,"insertUser":{"userID":127975,"name":"CHANDRU D","url":"https:\/\/community.smartsheet.com\/profile\/CHANDRU%20D","photoUrl":"https:\/\/lh5.googleusercontent.com\/-GidWL8gnZOk\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuuclsoiqLw7tSkR15J7rejI1tGbR6gg\/s96-c\/photo.jpg","dateLastActive":"2020-10-26T19:56:29+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-07-12T18:18:50+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":464,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72548\/i-am-trying-to-get-access-token-using-oauth","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72548\/i-am-trying-to-get-access-token-using-oauth","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/IMZV9YB8Y0Z7\/api-information.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Api Information.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"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":72595,"type":"question","name":"Can i integrate Smartsheet with a location finder like google maps","excerpt":"I am creating a work inspection register on a large airport in Saudi arabia and I would like the contractor to provide the GPS co-ordinates of the location where the inspection will be required.","categoryID":320,"dateInserted":"2020-10-27T09:15:14+00:00","dateUpdated":null,"dateLastComment":"2020-10-27T09:26:56+00:00","insertUserID":17521,"insertUser":{"userID":17521,"name":"Ducati916","url":"https:\/\/community.smartsheet.com\/profile\/Ducati916","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zJjcc0xty5Y!mTDd3oxVMHY!CrSAVxWcUNq","dateLastActive":"2020-10-29T08:27:12+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-12T16:52:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":261,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72595\/can-i-integrate-smartsheet-with-a-location-finder-like-google-maps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72595\/can-i-integrate-smartsheet-with-a-location-finder-like-google-maps","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"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":40456,"type":"discussion","name":"Notification with Attachments","excerpt":"Hi there, I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true? If so, do you know of any good apps\/software to automate that process? I have looked into…","categoryID":320,"dateInserted":"2019-02-01T17:32:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-10-15T20:56:36+00:00","insertUserID":73806,"insertUser":{"userID":73806,"name":"katherinehall","url":"https:\/\/community.smartsheet.com\/profile\/katherinehall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-01T17:26:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":121641,"lastUser":{"userID":121641,"name":"Ross Novotny","url":"https:\/\/community.smartsheet.com\/profile\/Ross%20Novotny","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nzjV_y9PACY!!F2G1tCE_o9C","dateLastActive":"2023-07-10T13:55:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":3706,"score":null,"hot":14,"url":"https:\/\/community.smartsheet.com\/discussion\/40456\/notification-with-attachments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40456\/notification-with-attachments","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":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"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":72127,"type":"question","name":"moveRowToAnotherSheet not deleting rows from source sheet","excerpt":"Hi there, We're using the NodeJS SDK to move rows from one sheet to another on a timed job but we often find that rows landing in our destination sheet aren't removed from the source sheet. This means that over time we end up with a lot of duplicates in our destination sheets. Eventually, after some number of attempts to…","categoryID":320,"dateInserted":"2020-10-12T15:16:37+00:00","dateUpdated":"2020-10-12T15:45:44+00:00","dateLastComment":"2020-10-15T14:45:37+00:00","insertUserID":127459,"insertUser":{"userID":127459,"name":"Jamie Dixon","url":"https:\/\/community.smartsheet.com\/profile\/Jamie%20Dixon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-12T15:12:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":127459,"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-07-12T18:18:50+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72127\/moverowtoanothersheet-not-deleting-rows-from-source-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72127\/moverowtoanothersheet-not-deleting-rows-from-source-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"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":71758,"type":"question","name":"Python SDK - projectSettings - nonWorkingDays","excerpt":"So me and the Python SDK is having a bit of a disagreement about updating projectSettings of a sheet and the SDK just gives me an error (the audacity!). Reading the API docs (https:\/\/smartsheet-platform.github.io\/api-docs\/?python#projectsettings-object) my interpretation is this: nonWorkingDays: \"...The format for the…","categoryID":320,"dateInserted":"2020-10-01T06:30:43+00:00","dateUpdated":null,"dateLastComment":"2020-10-15T09:29:35+00:00","insertUserID":126888,"insertUser":{"userID":126888,"name":"Stefan Nitsche","url":"https:\/\/community.smartsheet.com\/profile\/Stefan%20Nitsche","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GjJU9TxAWaxgSx4xJsK5ceFMBVb0BFU_WXVF1s","dateLastActive":"2020-10-01T05:59:06+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-07-12T18:18:50+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":463,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/71758\/python-sdk-projectsettings-nonworkingdays","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71758\/python-sdk-projectsettings-nonworkingdays","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-15T09:30:49+00:00","dateAnswered":"2020-10-15T09:29:35+00:00","acceptedAnswers":[]}},"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":72186,"type":"question","name":"why does \"ss_client.models.ContainerDestination({\" cause an error?","excerpt":"import json import os import requests from datetime import date import warnings from SSToken import MyToken #MyToken from simple_smartsheet import smartsheet from simple_smartsheet.models import Sheet, Column, Row, Cell, ColumnType MyShtIDNo = xxx folderID = xxx new_sheet_name = xxx ss_client =…","categoryID":320,"dateInserted":"2020-10-13T18:37:00+00:00","dateUpdated":null,"dateLastComment":"2020-10-15T02:11:56+00:00","insertUserID":125411,"insertUser":{"userID":125411,"name":"Alan Meshaw","url":"https:\/\/community.smartsheet.com\/profile\/Alan%20Meshaw","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-07T18:23:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":119623,"lastUser":{"userID":119623,"name":"Tim Wells","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Wells","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-10T16:00:08+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":165,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72186\/why-does-ss-client-models-containerdestination-cause-an-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72186\/why-does-ss-client-models-containerdestination-cause-an-error","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-15T12:21:24+00:00","dateAnswered":"2020-10-15T02:11:56+00:00","acceptedAnswers":[]}},"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}]}],"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-12T17:08:03+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-12T14:30:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":40,"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-12T14:30:51+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":64,"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":[]}">
