API & Developers

Connect with other developers using the Smartsheet API.

Discussion List

  • Chat function within Dashboards
    In API & Developers
    Good 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…
    Answered - Pending Review
    264 6
    Answered - Pending Review 264 views 6 comments Most recent by akim
  • When can the update_report api become available?
    In API & Developers
    There 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…
    Answered - Pending Review
    210 11
    Answered - Pending Review 210 views 11 comments Most recent by zsiegel
  • Automation emails to Microsoft Teams channel are not working
    In API & Developers
    We 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. …
    Accepted
    37 1
    Answered ✓ 37 views 1 comment Most recent by Umesh Shah
  • how to delete all the rows of a sheet using python at once
    In API & Developers
    I 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…
    Accepted
    124 3
    Answered ✓ 124 views 3 comments Most recent by Dhruv PAtel
  • Row and Cell formatting issue via the API picking up previous row strike through
    In API & Developers
    HI. 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…
    Answered - Pending Review
    30 1
    Answered - Pending Review 30 views 1 comment Most recent by Genevieve P.
  • Metrics: Using the metrics template and metadata
    In API & Developers
    I 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…
    Answered - Pending Review
    47 1
    Answered - Pending Review 47 views 1 comment Most recent by Andrée Starå
  • Updating a cell in a column formula is not supported
    In API & Developers
    Is 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…
    Answered - Pending Review
    225 4
    Answered - Pending Review 225 views 4 comments Most recent by JeanPhilippe
  • Populating new Cell with a Contact(s)
    In API & Developers
    I 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 …
    Answered - Pending Review
    122 8
    Answered - Pending Review 122 views 8 comments Most recent by Genevieve P.
  • Transforming data from API in Power BI
    In API & Developers
    Hello 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…
    Accepted
    67 3
    Answered ✓ 67 views 3 comments Most recent by Genevieve P.
  • Smartsheet app authorization
    In API & Developers
    Greetings, 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 …
    Answered - Pending Review
    31 1
    Answered - Pending Review 31 views 1 comment Most recent by Genevieve P.