API & Developers
Connect with other developers using the Smartsheet API.
Discussion List
-
Chat function within DashboardsIn API & DevelopersGood afternoon, My team and I are creating dashboards for each of our clients. The format we have has been close to perfected, but when presented to our CEO he mentioned the need for a chat/comments function within a dashboard (that is not…
-
When can the update_report api become available?In API & DevelopersThere is a specific use case in my organization that I need to be able to rename a set of reports automatically. Currently I'm able to do it to sheets and sights in the same folder, however the reports remains manual because this api is n…
-
Automation emails to Microsoft Teams channel are not workingIn API & DevelopersWe are testing sending automated Smartsheet tips and tricks email to a Teams channel, however, running into a few problems which make this functionality not useable. any hyperlinks within the texts are not clickable once posted in Teams. …
-
how to delete all the rows of a sheet using python at onceIn API & DevelopersI am trying to build an automation that updates an excel file to smartsheet once I run it. I have build that program but issue i am facing is that they are getting updated below the previous one. So I want to delete the rows first .Is ther…
-
Row and Cell formatting issue via the API picking up previous row strike throughIn API & DevelopersHI. I'm creating rows in Smartsheet via the API We're are storing the Sheet and Row ID in the originating application. Later on someone might decide that they no longer want this record, but rather than delete it from Smartsheet we update…
-
Metrics: Using the metrics template and metadataIn API & DevelopersI have the following setup: An Individual Project (Individual) A Dashboard Rolling Up Projects Assigned to an Individual (Program) A Dashboard Rolling Up All Projects (Portfolio) Each of the Individual, Program, and Portfolio has a metada…
-
Updating a cell in a column formula is not supportedIn API & DevelopersIs this really the case? Is there no means of using the API to update the format of a cell that is in a column with a column formula defined? We're trying to use column formulas, but have automated mechanisms in production that format by…
-
Populating new Cell with a Contact(s)In API & DevelopersI have been reading the SDK for Smartsheet and can't find support for how to populate a cell in a Contact List type column programmatically given the name of a person in the contact list (language C#). I have line of code that builds the …
-
Transforming data from API in Power BIIn API & DevelopersHello Smart People! I need to report on some data that I have compiled from many sheets in a Smartsheet report. The reporting tool that we have is Power BI, but the connector to Smartsheet defaults to IE, which isn't supported by Smartshee…
-
Smartsheet app authorizationIn API & DevelopersGreetings, Looking for a little guidance. I would like to develop an app that sends data to a sheet through HTTP. I have used the Python SDK with a raw token in the past but now I need a more secure solution and figured creating a 3rd …