API & Developers

Connect with other developers using the Smartsheet API.

Discussion List

  • Google calendar tab hyperlink from home page
    In API & Developers
    Mike here from Australia - can you tell me is there a way to hyperlink from the Smart Sheets home page I want to make a google calendar tab that hyperlinks directly to my google calendar and not via a cell in a sheet - see attached image a…
    24 1
    24 views 1 comment Most recent by Andrée Starå
  • Sporatic Error, using the API.
    In API & Developers
    Hello Everyone.  I have another weird error.    the spread sheet I am making is 35 columns across and 270 rows down.   I do batch updates exclusively.  And I also time my updates to the most updates are 160 a minute to not overload the Se…
    337 1
    337 views 1 comment Most recent by IanN
  • A Formatting Glitch, using the API.
    In API & Developers
    Hello.   I have developed a Script (Powershell), that will create a complete smartsheet. This smart sheet is created with colours based on various times on the source data,  (Late, ontime, etc. ).     My problem is when I update it again…
    22 2
    22 views 2 comments Most recent by Steven M
  • Screen blurs for lengthy formulas, or multiple parentheses
    In API & Developers
      Whenever, I try to use if statements or so, the screen blurs and is very irritating to the eye. Could this be fixed ?   Example :   =IF(AND([Total Man hours]7 >= 1, [Total Man hours]7 <= 16), 1, IF(AND([Total Man hours]7 >=…
    11 3
    11 views 3 comments Most recent by Paul Newcome
  • Unrecognized or Invalid Emails??
    In API & Developers
    When sharing sheets between My account and Others(business partners/clients), I often run into unrecognized email accounts warnings/alerts... (and I have to drop what I'm doing and setup a contact in "My Smartsheet Contacts"). …
    299 1
    299 views 1 comment Most recent by Isaac Jose
  • Build cashflow from multiple projects
    In API & Developers
    I would like some help (happy to pay) to enable our company to map task and revenue budgeted for each task and then have the data feed into a cashflow sheet somehow.   Could someone help me
    41 1
    41 views 1 comment Most recent by Andrée Starå
  • Transfer automatic data from SmartSheet to ERP
    In API & Developers
    Hi,  We would like to test SmartSheet for as a order follow up system. Whenever we are entering new orders, we need to transfer the informations to our own ERP system automatic via an API solution. Is that possible with SmartSheet?
    23 4
    23 views 4 comments Most recent by Andrée Starå
  • # of Attachments in a Cell
    In API & Developers
    I would love to log the amount of attachments a line has in a cell.    IE 3 attachments, I would like to have one of the cells read "3" so we can at a glance see how much documentation is added to the line. Does anyone know if …
    11 2
    11 views 2 comments Most recent by Mike Wilday
  • Excel Live Data Connector - Partial Results Returned
    In API & Developers
    Hi, On Smartsheet the report returns all rows. When I export to excel it returns all rows. When I run the connector in Excel, it excludes some rows. It appears that the rows being excluded have a Text/Number value in column X i.e. D21, w…
    105 1
    105 views 1 comment Most recent by Marcin P
  • Cloning a column within a sheet
    In API & Developers
    Has the cloning of a column within the same sheet feature been developed? I saw the discussion back in 2016. Thanks Christi
    417 1
    417 views 1 comment Most recent by Corinne Flanagan