API/Developers

Discussion List

  • Insert approvers name and date/ time of approval
    In Formulas and Functions
    Hi all, I have created a form and a workflow for approval. In short: Somone submits a form Details email to an approver Approver either approves or declines (would also be good to have more than 2 options i.e. defer) The smartsheet updates…
    Accepted
    123 5
    Accepted Answer 123 views 5 comments Most recent by Justin Reed Formulas and Functions
  • Is there a way to create a search box?
    In Formulas and Functions
    We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and th…
    501 11
    501 views 11 comments Most recent by Reni Viessmann Formulas and Functions
  • File Attachment to Row
    In API & Developers
    Hi Team , I am trying to attach file to smartsheet row with the following details, https://api.smartsheet.com/2.0/sheets/{Sheet ID }/rows/{ Row ID }/attachments Header : Authorization:Bearer {ACCESS TOKEN} Content-Type:image/jpeg Content-…
    Answered - Pending Review
    17 3
    Answered - Pending Review 17 views 3 comments Most recent by evaluation API & Developers
  • Days Lapsed/Column Formula
    In Formulas and Functions
    How do I create a Column Formula that will calculate how many days have lapsed since the "Issue Start Date"? I currently have the formula: =SUM(TODAY() - [Issue Start Date]1) but when I try to convert it to a Column Formula, it s…
    Accepted
    12 1
    Accepted Answer 12 views 1 comment Most recent by Mike Wilday Formulas and Functions
  • ODBC Connection with Visio
    In Premium Apps and Integrations
    Hi All,  I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to c…
    105 3
    105 views 3 comments Most recent by Andrée Starå Premium Apps and Integrations
  • Remove User API
    In API & Developers
    Hello, I am attempting to remove a user and transfer their files to another user. Although the API documentation is clear, I am not getting the desired results. User gets deleted, but the sheets never get transferred: const options = …
    Accepted
    36 3
    Accepted Answer 36 views 3 comments Most recent by Genevieve P API & Developers
  • Sharing a sheet | specific columns for access
    In Premium Apps and Integrations
    We are using the API feature and have shared a sheet with one of our vendors. They have asked if I can share the sheet that has been created with more members of their team, but they only want the new members to be able to access and updat…
    Accepted
    17 3
    Accepted Answer 17 views 3 comments Most recent by Andrée Starå Premium Apps and Integrations
  • Custom Development Possible?
    In API & Developers
    Is it possible to have a developer build a custom button in smartsheets that can for example pull data from it ..into a document..  Is smartsheets open to being developed on? I have the business package. 
    53 5
    53 views 5 comments Most recent by Jibran Ahmed Sheikh API & Developers
  • Create/Update/Delete APIs for Sight Widgets
    In API & Developers
    I don't see any Create/Update/Delete APIs for Sight Widgets (Read is handled via getting a sight given it's id). In the docs, the sight update command can only be used to rename the site. I've tried to pass in the complete JSON for the sig…
    48 views 3 comments Most recent by Florian Zschetzsche API & Developers
  • Is it possible to populate fields in Smartsheet from a 3rd Party application?
    In API & Developers
    I've got a situation where we'd like to pull in some real-time data from our ERP system into a Smartsheet where we are doing some further tracking as things progress from month to month. From some light research, it seems as though an API …
    Accepted
    13 5
    Accepted Answer 13 views 5 comments Most recent by Andrée Starå API & Developers