API & Developers

Archives for March 2022

Discussion List

  • Date format issue
    In API & Developers
    Hello, Currently we get format like  ",,,,,,,,,,,,,,,,1" for date column type. How can we get actual date format like "yyyy-mm-dd"? Or if there is any way to convert format string ",,,,,,,,,,,,,,,,1" to dateti…
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Paul Newcome API & Developers
  • Used in formula on: <unknown sheet>
    In API & Developers
    Is there a way to see who the owner of the <unknown sheet> is? I'm have multiple sheets with data that is used for various metrics. I am currently looking at revamping those sheets but I have several columns that show: Used in formul…
    Accepted
    23 2
    Answered ✓ 23 views 2 comments Most recent by Peggy Parchert API & Developers
  • Remove ' character
    In API & Developers
    Hi, I'm using make.com to make an API call to update some of our sheets, everything is working fine except for updating the Progress. I'm trying to mark it as 100% but when I send 100% via the API it goes into Smartsheet as '100% How can I…
    Answered - Pending Review
    38 4
    Answered - Pending Review 38 views 4 comments Most recent by @Lee API & Developers
  • How to import an MS EXcel sheet, with embedded links in cells?
    In API & Developers
    How to import an MS EXcel sheet, with embedded links in cells?
    Answered - Pending Review
    25 2
    Answered - Pending Review 25 views 2 comments Most recent by Gia Thinh API & Developers
  • directly script the Code and run in SmartSheet
    In API & Developers
    This discussion was created from comments split from: Loading data from excel into Smartsheet API to an existing sheet.
    Answered - Pending Review
    25 2
    Answered - Pending Review 25 views 2 comments Most recent by Genevieve P. API & Developers
  • ScriptIncl:SmartsheetIntegrationHelper-Failed
    In API & Developers
    We are using ServiceNow to Smartsheet Integration and for one record is throw out an error and error code is : " ScriptIncl:SmartsheetIntegrationHelper-Failed to insert issue table record to the smartsheet sheet " What could b…
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Genevieve P. API & Developers
  • 404 Error - Event data - Smartsheet API
    In API & Developers
    Hi, I am attempting to get event data from the smartsheet api. First, I tried the new api documentation method which suggests a request to the event api url. Traditionally, you don't pass both a parameters variable AND parameters in the u…
    Accepted
    36 3
    Answered ✓ 36 views 3 comments Most recent by Andrée Starå API & Developers
  • Timestamps only match selected date format when clicked on
    In API & Developers
    Hello, I am sending data to a Smartsheet via the API. I have been following the requirements for dates to be in isoformat 8601 per the documentation without any issue for over a year. Recently however, the dates are coming in as their raw …
    Accepted
    19 1
    Answered ✓ 19 views 1 comment Most recent by Kurt Maurer API & Developers
  • How to add Developer Tools to GOV account?
    In API & Developers
    Hi, I want to add Develope Tools to a GOV account so I can than Create New App which will help me in generating a ClientID and ClientSecret. I need those to give users a log in page. I am able to create developers account for non gov acco…
    Answered - Pending Review
    35 3
    Answered - Pending Review 35 views 3 comments Most recent by Andrée Starå API & Developers
  • 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
    36 1
    Answered ✓ 36 views 1 comment Most recent by Umesh Shah API & Developers