https:\/\/smartsheet.redoc.ly\/tag\/sheets#operation\/getSheet<\/a><\/p>Cheers,<\/p>
Genevieve<\/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":110440,"type":"question","name":"Smartsheet API Call","excerpt":"Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,","snippet":"Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET…","categoryID":320,"dateInserted":"2023-09-19T16:45:10+00:00","dateUpdated":null,"dateLastComment":"2023-10-10T14:03:37+00:00","insertUserID":166537,"insertUser":{"userID":166537,"name":"Emskie321","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Emskie321","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocLQ3XNhEe-vhgR7uLjCh-xFnB62fGRy-ciu3nJ2IkX6=s96-c","dateLastActive":"2023-10-25T10:30:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":120447,"lastUser":{"userID":120447,"name":"Ryan Kramer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Kramer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-20T14:55:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":250,"score":null,"hot":3392092727,"url":"https:\/\/community.smartsheet.com\/discussion\/110440\/smartsheet-api-call","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110440\/smartsheet-api-call","format":"Rich","tagIDs":[227,319],"lastPost":{"discussionID":110440,"commentID":399264,"name":"Re: Smartsheet API Call","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/399264#Comment_399264","dateInserted":"2023-10-10T14:03:37+00:00","insertUserID":120447,"insertUser":{"userID":120447,"name":"Ryan Kramer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Kramer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-20T14:55:24+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-09-21T16:36:09+00:00","dateAnswered":"2023-09-20T19:35:30+00:00","acceptedAnswers":[{"commentID":396313,"body":"
So the best way to do this is to have a script run locally or hosted somewhere outside of Smartsheet. <\/p>
You can then have this script make the \"GET\" requests to the various sources and pull that information locally and then push that data via a \"POST\" request to another source or potentially Smartsheet. <\/p>
We do these types of integrations all the time for various clients.<\/p>
Hope that helps!<\/p>
Ryan<\/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":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":319,"urlcode":"functionality","name":"functionality"}]},{"discussionID":110797,"type":"question","name":"COUNTIFS and OR","excerpt":"Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = \"Planned\", {RegSci Review Projections…","snippet":"Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted.…","categoryID":320,"dateInserted":"2023-09-26T16:51:09+00:00","dateUpdated":null,"dateLastComment":"2023-09-26T17:02:54+00:00","insertUserID":167224,"insertUser":{"userID":167224,"name":"RobynK","url":"https:\/\/community.smartsheet.com\/profile\/RobynK","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-24T15:01:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":167224,"lastUser":{"userID":167224,"name":"RobynK","url":"https:\/\/community.smartsheet.com\/profile\/RobynK","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-24T15:01:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":121,"score":null,"hot":3391496043,"url":"https:\/\/community.smartsheet.com\/discussion\/110797\/countifs-and-or","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110797\/countifs-and-or","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110797,"commentID":397010,"name":"Re: COUNTIFS and OR","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397010#Comment_397010","dateInserted":"2023-09-26T17:02:54+00:00","insertUserID":167224,"insertUser":{"userID":167224,"name":"RobynK","url":"https:\/\/community.smartsheet.com\/profile\/RobynK","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-24T15:01:26+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-09-27T11:42:22+00:00","dateAnswered":"2023-09-26T16:59:25+00:00","acceptedAnswers":[{"commentID":397008,"body":"
Try this: =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, {RegSci Review Projections Range 2}, OR(@cell = \"Planned\", @cell = \"Submitted\"<\/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":254,"urlcode":"formulas","name":"Formulas"}]}],"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":223,"limit":3},"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Trending in API & Developers
Error Code: 1036 hi I was recreating an automation flow, when i run my flow. this was the error presented. How can i fix it?
Smartsheet API Call Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,
COUNTIFS and OR Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = "Planned", {RegSci Review Projections…