API/Developers

Discussion List

  • Automatic creation of sheets
    In API & Developers
    Hi, I'm wondering if there is a way to automatically create a tracker from a template when a row is added to a master sheet? So, I'd have a form add rows to a master sheet, then I'd like that to automatically start an individual tracker t…
    Accepted
    34 4
    Accepted Answer 34 views 4 comments Most recent by Tony Cooper API & Developers
  • Updating rows with multi_contact cell?
    In API & Developers
    Hello, I'm using the Python API to update some rows as follows: copy cell values in specific columns from an old row, and append these to an update request as cells in the respective column for a new row. This works for all but a contact c…
    Accepted
    22 4
    Accepted Answer 22 views 4 comments Most recent by nschum API & Developers
  • API Access to Column Formulas
    In API & Developers
    I have been trying to understand how to handle column formulas and all I can see is that you have error messages to let us know that we can modify cells in columns with column formulas but there is no column attribute to indicate that a co…
    Accepted
    37 8
    Accepted Answer 37 views 8 comments Most recent by David Tutwiler API & Developers
  • Card View - Conditional Formatting
    In Using Smartsheet
    Hi all (Andre you about? haha) I am trying to conditional format on the card view, in terms of striking through the Primary Text (Task Name) when the % Complete column = 100% This works on the grid or gantt view however does not carry ove…
    Accepted
    227 5
    Accepted Answer 227 views 5 comments Most recent by coby Using Smartsheet
  • Building A Test Package In SQL Dev That Writes To A Smartsheet
    In API & Developers
    Hello, I am attempting to build a package in SQL Dev that takes data from a table in SQL Server and inserts it into a Smartsheet. For example, I have three lines of data in a table in SQL Server that I need to have added to a Smartsheet ta…
    Answered - Pending Review
    31 1
    Answered - Pending Review 31 views 1 comment Most recent by Genevieve P API & Developers
  • API Load Error with Python Executable
    In API & Developers
    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…
    Answered - Pending Review
    156 2
    Answered - Pending Review 156 views 2 comments Most recent by Genevieve P API & Developers
  • Rolling up multiple projects onto a dashboard
    In Using Smartsheet
    Is there a way to roll up the critical pathways and key milestones for multiple projects / smartsheets into one dashboard?
    Accepted
    33 3
    Accepted Answer 33 views 3 comments Most recent by Bassam.M Khalil Using Smartsheet
  • Can we plot address info from Smartsheet live on to google maps?
    In API & Developers
    Looking to create a live map (Ideally google maps) that updates with Smartsheet address info (Postcodes)
    Answered - Pending Review
    59 3
    Answered - Pending Review 59 views 3 comments Most recent by Andrée Starå API & Developers
  • Search rows API after create rows API from Power Automate/Flow returns incorrect row object ID's
    In API & Developers
    I'm attempting to have a flow in Microsoft Power Automate/Flow create rows in a Smartsheet sheet and update a field once an approval outcome is present. The first part works with no problem - rows are created with a value in one column to …
    Accepted
    24 2
    Accepted Answer 24 views 2 comments Most recent by bsim1130 API & Developers
  • HYPERLINK API
    In API & Developers
    We have been using HYPERLINK("http://website.ws/links", "Click Here") in both excel and google spreadsheet, and since we need jotforms integration for client our current links in smartsheet is very long and creating hyp…
    329 2
    329 views 2 comments Most recent by Chris Brock API & Developers