-
Ability to dynamically link sheets
Hello, I am guessing that this question will require coding and the API but I'll ask anyway... Is it possible to look up the name of another sheet on a row and then identify cells in that sheet by name or position and then link to the data? Please note that I do not want a =vlookup in the receiving cell, I want to end up…
-
need help on Comments API
I want to pull recently added comments to row in smartsheet from servicenow using API. But existing api to fetch comments need comment id , as third party system i dont comment id to pull . I would like to know how to get recently added comments to row using api without using comments id
-
What permission should a user have to add members to a group using API?
Hello, I try to add a user to a group using API. I do it under account with Group Admin role. But unfortunately I get 403 Forbidden response with json { "errorCode": 1004, "message": "You are not authorized to perform this action." } What permissions are enough to perform such operation? Thanks, Michael
-
Maps & Hyperlinks
I know that the smartsheet charts app is still in production, but is it possible to have sheet containing North American states and hyperlinks, then using the 'map' chart, click on a particular state and then it will take you to that hyperlink?
-
Any plans on allowing binary uploads to the import and attachment functions?
It seems like the API is geared towards a desktop application with constant user interaction. In my case, I am using it to generate some reports for my company and pushing them out to a specified folder. Currently, to generate the report, I am aggregating the majority of the data into a DataSheet, and converting it to a…
-
Internal Server Error Please contact Smartsheet
Hi, I received the following error message when running the API: {"response": {"statusCode": 500, "reason": "Internal Server Error", "content": {"errorCode": 4000, "message": "An unexpected error has occurred. Please contact the Support team at https://help.smartsheet.com/contact for assistance.", "refId":…
-
Getting a Template's columns and rows using the API
Is there a method for retrieving a Template's columns and rows using the API? Trying to use the "Get Sheet" API method (e.g., /sheets/{sheetId}) with a Template ID returns a "Not Found". For now, I'm working around this by doing a "Create Sheet from Template", inspecting that temporary sheet as I need to, then deleting the…
-
Event Reporting User Events total fetch
Hi, Can you please let us know if there is any way We can check how many total user events have been fetched from my Account till today vis Event Report API(https://api.smartsheet.com/2.0/events)? Thank you
-
Creating a new smartsheet Project-type-sheet from scratch with the API
Hello. Trying to create a new Project-type-sheet with the API, and would like to designate everything about it the way I want in code, so NOT from a template. It appears there is no way to do this with the API, that it simply has no syntax for creating a gantt-enabled project sheet. Is this true? But next question - if you…
-
Is there a way to attach an URL to a proof?
Hello, I am able to create a proof with a link instead of file from UI. But I cannot see such functionality in API. I tried to do a POST request to /sheets/{sheetId}/proofs/{proofId}/attachments with the same JSON body like for adding URL to a row but with no luck - "errorCode" : 1011, "message" : "A required header was…
