API & Developers

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

API & Developers

 

Discussion List

  • StephenG
    Question StephenG 7 views 0 comments Started by StephenG
    First post 01/23/20,Last post 01/23/20
    Anyone got any clever workarounds to set the width of a column object to the width value of the widest cell in the column content-wise?
    API & Developers70
    StephenG
  • sahilhq
    Answered sahilhq 9 views 1 comment Most recent by Andrée Starå
    First post 01/23/20,Last post 01/23/20
    Hi, I often receive feedbacks from my colleagues that the Smartsheets dashboards we create on the project are not very interactive and "smart". I am in the process of creating a new dashboard at the moment and would like to make …
    API & Developers91
    sahilhq
  • Neall Alcott
    Neall Alcott 12 views 3 comments Most recent by Andrée Starå
    First post 01/21/20,Last post 01/23/20
    Does anyone have an example of how to query for all sheets that were created using the project template? Thanks!
    API & Developers123
    Neall Alcott
  • Anurag T
    First post 01/21/20,Last post 01/22/20
    Hi, we are using Smartsheet's webhook API. We have the following use case. Consider user 'A' registered a webhook on a particular sheet. When some other Smartsheet user 'B' who has URL of the sheet of the user 'A' and tried to access the s…
    API & Developers221
    Anurag T
  • jamieG
    jamieG 9 views 1 comment Most recent by Andrée Starå
    First post 01/21/20,Last post 01/22/20
    Is there a way to hook into Smartsheet to load a custom CSS file? Or even bootstrap? Smartsheet has tremendous power but its visual appearance is very static. Especially in dashboards. The ability to be able to punch up the graphics, se…
    API & Developers91
    jamieG
  • L@123
    [email protected] 15 views 0 comments Started by [email protected]
    First post 01/20/20,Last post 01/20/20
    All: this is to share/record a way to push the submit button in a smartsheet webform using vba. I share this because I spent way more time trying different options posted on different websites than I would like to admit. Dim IE As Object …
    API & Developers150
    [email protected]
  • Patrick Vachon
    Accepted Answer Patrick Vachon 26 views 3 comments Most recent by Tyler McClure
    First post 01/13/20,Last post 01/13/20
    Hi, anyone else having issues this morning with the "send" function ? We use to use this function to send emails with info from the smartsheet, but this morning nothing happen (2020-01-13 @ 10h00 am E.T)
    API & Developers263
    Patrick Vachon
  • xilive 3480
    Answered xilive 3480 16 views 1 comment Most recent by Andrée Starå
    First post 01/10/20,Last post 01/10/20
    Hello, I want some details, how I want to integrate smartsheet with Confluence & JIRA. I want some specific column data from smartsheet and show in Confluence page also I want to apply some filter on column data, so I want details how …
    API & Developers161
    xilive 3480
  • ajcooper35
    Answered ajcooper35 25 views 2 comments Most recent by ajcooper35
    First post 01/06/20,Last post 01/09/20
    Is there any talk for the potential to update sights using the API (other than renaming the dashboard)? We are using the API to copy everything in a folder to a new folder, but want to be able to update the embedded map we have on the das…
    API & Developers252
    ajcooper35
  • Richard Rymill SBP
    Richard Rymill SBP 213 views 2 comments Most recent by Kyra Dragone
    First post 09/10/19,Last post 01/07/20
    We all love a Freebie?  OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsh…
    API & Developers2132
    Richard Rymill SBP
  • AllenG
    AllenG 32 views 2 comments Most recent by RKB1923
    First post 11/07/19,Last post 01/03/20
    My company is using a Smartsheet which uses custom columns fed by a request form.  The purpose of this sheet is to process and track product enhancement requests, and occasionally we will migrate JIRA tickets into the process as well, whic…
    API & Developers322
    AllenG
  • MOverholt
    MOverholt 35 views 1 comment Most recent by Andrée Starå
    First post 12/05/19,Last post 12/05/19
    Background * We will be creating / managing projects in Smartsheet * Each new project is a new sheet, based on a template * I am designing integration to other systems that need to be notified whenever a new project or task within a proje…
    API & Developers351
    MOverholt
  • Peter Kafui Doviavu
    Peter Kafui Doviavu 25 views 2 comments Most recent by Andrée Starå
    First post 11/28/19,Last post 12/03/19
    Hello, Am working with a company as an IT which needs a CMMS tool for their mining clients for the WR, WO, PMs, AMs and so forth. And I need an expert of Smartsheet to help me on contract to develop the tool for them.
    API & Developers252
    Peter Kafui Doviavu
  • Tristan Falcon
    Tristan Falcon 41 views 0 comments Started by Tristan Falcon
    First post 12/02/19,Last post 12/02/19
    I have created a python script in PyCharm, the file has been running with no issues. I converted the file to .exe using PyInstaller and auto-py-to-exe but with both methods I receive the following error after running the .exe: "Impor…
    API & Developers410
    Tristan Falcon
  • somer
    somer 22 views 1 comment Most recent by Etienne Mermillod
    First post 11/25/19,Last post 11/28/19
    hi team, I need help with removing the overheard data from the Smartsheet api call that returns a json file, I need to remove all the overhead before putting the data into the pipelines, thanks.  (Image)
    API & Developers221
    somer
  • amkumar81861
    amkumar81861 29 views 2 comments Most recent by amkumar81861
    First post 11/26/19,Last post 11/26/19
    Hi Team,  Is it possible to automatically navigate to a URL added in a cell if specific cell value changes to specific value? Please see below to understand the requirement. I have a tracker sheet for each project. Each tracker sheet ha…
    API & Developers292
    amkumar81861
  • pnc51
    pnc51 60 views 7 comments Most recent by Andrée Starå
    First post 08/23/19,Last post 11/25/19
    Hello, If I'm building a website, can I create a custom HTML form and get the data into Smartsheet somehow? Smartsheet's native forms don't have the capabilities that I need (conditional logic) and I would like to make my forms a bit pret…
    API & Developers607
    pnc51
  • hanemay
    hanemay 14 views 1 comment Most recent by timwells
    First post 11/11/19,Last post 11/13/19
    Hi. I'm trying to update a cell on a row which is a data field using the C# api.  However, I'm getting an error {"Value is not supported for this column type. Use objectValue instead."} But when I'm trying to set objectvalue i…
    API & Developers141
    hanemay
  • Dean Sund
    Dean Sund 32 views 2 comments Most recent by Andrée Starå
    First post 11/11/19,Last post 11/12/19
    For example I have sheet A that has my master list and all components within a "Kit".  On sheet B I have multiple kits and would like to reference all the included components.  I get that you can link cell to another just like an…
    API & Developers322
    Dean Sund
  • shekhar.kanade109651
    shekhar.kanade109651 23 views 2 comments Most recent by shekhar.kanade109651
    First post 11/01/19,Last post 11/11/19
    Hi All,  Raised two cases with Support but no response so starting new discussion.  We have created smartsheet webhook with  callback url  having port 443, 8008,8000 and 8080 but able to get response when callback url configured with 443…
    API & Developers232
    shekhar.kanade109651
  • HankBento
    HankBento 281 views 11 comments Most recent by Andrée Starå
    First post 05/21/18,Last post 11/07/19
    Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
    API & Developers28111
    HankBento
  • Oby
    Oby 31 views 2 comments Most recent by Oby
    First post 11/04/19,Last post 11/06/19
    Hello, Currently Smartsheet doesn't allow me to send an Alert with an attachment. The context of this is for a travel spreadsheet, when someone enters their itinerary, it will send the person an email with a standard email containing an a…
    API & Developers312
    Oby
  • bcromie
    bcromie 21 views 1 comment Most recent by [email protected]
    First post 11/02/19,Last post 11/04/19
    Hi! I'm trying to generate custom PDFs with a specific template from a smartsheet row. The workflow currently uses an automation to send an email when the row is "done". Right now, that email contains the "Row Number" …
    API & Developers211
    bcromie
  • mschwahn
    First post 10/21/19,Last post 10/29/19
    When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone. I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies a…
    API & Developers1198
    mschwahn
  • katherinehall
    katherinehall 50 views 9 comments Most recent by Andrée Starå
    First post 02/01/19,Last post 10/23/19
    Hi there,  I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true? If…
    API & Developers509
    katherinehall
  • Disackson
    Disackson 14 views 1 comment Most recent by timwells
    First post 10/17/19,Last post 10/22/19
    Hi, I am using the C# API to interface to Smartsheet.... I can see how to add attachments and images in cells but these only accept a file name as a parameter. My images are stored in a database, is there a way to upload the images binar…
    API & Developers141
    Disackson
  • Helena C
    Helena C 19 views 1 comment Most recent by timwells
    First post 10/18/19,Last post 10/22/19
    Hi Smartsheet Community! This is my first post and I hope not to scare you away. I've been finding the community amazingly helpful in everything I've been doing so far. Now I'm blocked and I hope someone can give me a hand (Image) .   …
    API & Developers191
    Helena C
  • tcalvey
    tcalvey 21 views 3 comments Most recent by Andrée Starå
    First post 10/11/19,Last post 10/14/19
    Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their …
    API & Developers213
    tcalvey
  • TomBritchford
    TomBritchford 17 views 3 comments Most recent by Andrée Starå
    First post 10/14/19,Last post 10/14/19
    Can I integrate a sheet with my bank (Lloyds) to automatically download new statement lines every 30 mins or so. I have to login to my bank and copy the data across all the time and would like to automate it if possible.
    API & Developers173
    TomBritchford
  • Summer.B
    Summer.B 15 views 1 comment Most recent by Andrée Starå
    First post 10/10/19,Last post 10/14/19
    Hello smartsheet Community, I want to track company smartsheet user metrics such as the number of users, number of sheets, user types, etc. automatically using Power BI. Currently, I am exporting the user and sheet access reports and havi…
    API & Developers151
    Summer.B