API & Developers

Help us design API classes that meet your needs

Announcement Maricel Medina 57 views 1 comment 0 points Most recent by Kevin Minkoff 05/06/20

First post 04/19/20,Last post 05/06/20
Hi, We are preparing new courses related to our Smartsheet API, would you take few minutes to let us know what would you like us to offer by submitting this survey: https://tinyurl.com/ycg7arps? (Image)
API & Developers571
Maricel Medina
Test case Smartsheets

laneski 99 views 2 comments 0 points Most recent by Sandra Healey 08/08/20

First post 08/23/19,Last post 08/08/20
We're going into UAT soon. I've chosen Smartsheets to put all the test cases the testers need to run. Some things I'm wondering about - hopefully all of you ppl smarter then me can help: 1. I imagine that I will need multiple sheets right…
API & Developers992
laneski
Automate io & Deleting Data from SmartsheetQuestion

Answered - Pending Review Alex Lubow 23 views 4 comments 0 points Most recent by Alex Lubow 08/05/20

First post 07/27/20,Last post 08/05/20
I just recently started using automate io and just recently ran into some major issues. Automate io allows you to create a bot with the trigger of 'New Row' so anytime a new row is created on a sheet, it will trigger the bot. Soon after se…
API & Developers234
Alex Lubow
When I scan a barcode using a form, an extra ' is entered before the number.Question

Answered - Pending Review Melissa Richardson 11 views 1 comment 0 points Most recent by Paul Newcome 08/05/20

First post 08/05/20,Last post 08/05/20
I´m using the barcode scan function in a form to enter the barcode. However, when I do the scan an extra character , ', is entered in front of the number. So instead of the number 10345470605 being entered, '10345470605 is entered instea…
API & Developers111
Melissa Richardson
API Demo: Creating a Formatted and Printable View of a Row

leejoramo 677 views 10 comments 0 points Most recent by Sarah Sting 08/03/20

First post 04/03/19,Last post 08/03/20
Here is a demonstration of a feature I created using SmartSheet's API. Let's say you want to print all or some content of a row. Or perhaps you want a nicely formatted and easy to read view of the row. The specific use case addressed here…
API & Developers67710
leejoramo
Populating a Dropdown List

HankBento 2.5K views 13 comments 1 point Most recent by Gauri Sinha 08/01/20

First post 05/21/18,Last post 08/01/20
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
API & Developers253413
HankBento
Is it possible to export a sheet as forms?Accepted Answer

Accepted Answer [email protected] 27 views 3 comments 0 points Most recent by Andrée Starå 07/31/20

First post 07/29/20,Last post 07/31/20
We often need to publish a report pulling data from a selection of columns, for a single row, sequentially on a page, and then the next row, etc (I.e. laid out like a document, not a spreadsheet). We currently use the Smartsheet add-on in …
API & Developers273
[email protected]
Excel and Smartsheet linkingQuestion

Answered - Pending Review anilkrag77641 16 views 1 comment 0 points Most recent by RossL 07/30/20

First post 07/30/20,Last post 07/30/20
Hello I am working on a project wherein I have to extract most of the data from Excel to Smartsheet, is there anyway I can create linking between Excel and Smartsheet in such a way that whenever excel is updated Smartsheet automatically g…
API & Developers161
anilkrag77641
Import Excel Data automaticallyQuestion

Answered - Pending Review Tamizamuthan Vedachalam 20 views 4 comments 0 points Most recent by Tamizamuthan Vedachalam 07/30/20

First post 07/27/20,Last post 07/30/20
Hello Experts, We are currently exporting excel file from SAP to Desktop and the same file is being manually fed in smart sheets to accommodate the existing charts on daily basis to update. As of I don't find any plugin to correct SuccessF…
API & Developers204
Tamizamuthan Vedachalam
CDATA import into Smartsheet cause apostrophe problemQuestion

Answered - Pending Review Chris Savold 21 views 1 comment 0 points Most recent by Ben G 07/29/20

First post 07/22/20,Last post 07/29/20
We are using an external tool from CDATA to import data into Smartsheet from MS SSIS. We have recently run into an issue where the data load inserts an apostrophe in front of the string value we are loading. We've checked the outbound flow…
API & Developers211
Chris Savold
SharePoint to Smartsheet Integration Using Power AutomateQuestion

Answered - Pending Review [email protected] 41 views 3 comments 0 points Most recent by Ben G 07/22/20

First post 07/21/20,Last post 07/22/20
Let me start by acknowledging that I am a complete API/Power Automate novice. However, I am trying to create an automated method to trigger my Smartsheet workflow when my client posts a document to a SharePoint folder (serving as a central…
API & Developers413
[email protected]
Apostrophe added on mass insert thru CDATA

kevanmueller 95 views 5 comments 0 points Most recent by Chris Savold 07/22/20

First post 08/09/18,Last post 07/22/20
Hello, We are currently using a third party tool CDATA to upload excel data to a smartsheet. When any numeric data is entered, an apostrophe is always added to the beginning of the string. Upon checking the logs, CDATA is not sending an a…
API & Developers955
kevanmueller
Azure logic app & Smartsheet webhooksQuestion

Answered - Pending Review Sunil Patel 16 views 1 comment 0 points Most recent by Ben G 07/21/20

First post 07/15/20,Last post 07/21/20
Can you provide sample to register webbooks in logic app? I'm passing below information but on return I get webhook enabled = false.. I again make put call to enable particular webhook but it doesn't seems working (Image)
API & Developers161
Sunil Patel
Smartsheet Integromat IntegrationQuestion

Answered - Pending Review Rivky Emert 27 views 1 comment 0 points Most recent by Ben G 07/21/20

First post 07/17/20,Last post 07/21/20
Hi Community, Does anyone have experience using Integromat to copy an entire Smartsheet folder with everything in it, when a new row is added to a specific sheet? I need help setting the integration up. Thanks
API & Developers271
Rivky Emert
Value for updating a checkboxQuestion

Answered - Pending Review Zac Muir 20 views 1 comment 0 points Most recent by Genevieve P 07/19/20

First post 07/18/20,Last post 07/19/20
Hello, I am trying to pass in values via Zapier to update a checkbox type field. I have restricted the column so that it will only accept checkbox values. What value should I pass in to check/uncheck the box? I have tried Yes, No, True,…
API & Developers201
Zac Muir
Multiple selection on a drop down listAccepted Answer

Accepted Answer Silvia C Rodriguez 955 views 54 comments 0 points Most recent by Genevieve P 07/19/20

First post 07/30/18,Last post 07/19/20
Hi, I read in another tread that the ability to select multiple items in a dropdown list was in development. Does anyone know if that is available now?
API & Developers95554
Silvia C Rodriguez
I have been asked to pull in leads using JSON Hook, can you help?Question

Answered - Pending Review Giuseppe_Coccone 21 views 1 comment 0 points Most recent by Ben G 07/16/20

First post 07/15/20,Last post 07/16/20
Hello, I have been asked to pull in leads using a JSON hook for Home Advisor leads and I am not sure how to do this or who to ask for help. Can you please send me in the right direction? Please see the attached document they sent me with d…
API & Developers211
Giuseppe_Coccone
How to delete all webhooks in bulk?Question

Answered - Pending Review Sunil Patel 10 views 1 comment 0 points Most recent by Genevieve P 07/16/20

First post 07/15/20,Last post 07/16/20
There is an api end point to delete webbooks one by one.. any end point to delete all in once?
API & Developers101
Sunil Patel
vlookup of image

Senando Benig Jr 108 views 8 comments 0 points Most recent by Nino Castro 07/09/20

First post 08/02/18,Last post 07/09/20
Hi, Im Senando Benig Jr, Just Sen for short, Im in manila Philippines, My company start smartsheet from scratch and im the one assigned to develop an application. I explore smartsheet for more than 1 year and i think im in advance now. …
API & Developers1088
Senando Benig Jr
Is there a way to add a new task as a subtask via the api?Question

Answered - Pending Review Thomas Gunn 14 views 1 comment 0 points Most recent by Sean Morgan 07/07/20

First post 07/02/20,Last post 07/07/20
Hi all, I've been working on connecting Teamwork Projects( A project management software) to smartsheets via the API using zapier. I'm curious if someone has found a way to add new tasks in smartsheet under parent tasks as subtasks?
API & Developers141
Thomas Gunn
Search api not finding results consistentlyQuestion

Answered - Pending Review Paul de Villiers 21 views 3 comments 0 points Most recent by Genevieve P 07/06/20

First post 07/02/20,Last post 07/06/20
Hi Guys We are doing an all-sheets search via the API and cannot figure out why, on one of the sheets, it is not including certain rows: (Image) The search is: https://api.smartsheet.com/2.0/search?scopes=cellData&query="97*"…
API & Developers213
Paul de Villiers
Creating an Issue in JIRA from Smartsheet

@RunningBeare 117 views 2 comments 0 points Most recent by Wes Whitlam 06/24/20

First post 05/23/18,Last post 06/24/20
Hi, I'm using the JIRA connector and I'm getting an error - "Invalid response from JIRA. statusCode: 400, reasonPhrase: Bad Request Issue type is a sub-task but parent issue key or id not specified." When I edit the workflow I…
API & Developers1172
@RunningBeare
Get Data from SQL Server and Update Smartsheet in C#Question

Answered - Pending Review Abdikarim Sidow 34 views 2 comments 0 points Most recent by Abdikarim Sidow 06/23/20

First post 06/22/20,Last post 06/23/20
I am trying to connect to SQL server and pull some data and then update Smartsheet based on what i pulled from SQL Server. Can someone please share some sample code? Thanks
API & Developers342
Abdikarim Sidow
Are there Smartsheet Developers for Contract? If so, where?Question

Answered - Pending Review Travis Pryor 36 views 1 comment 0 points Most recent by Andrée Starå 06/22/20

First post 06/22/20,Last post 06/22/20
Hi, My company has been using Smartsheet for the better part of 3 years now. Some staffers have had training but nothing too extensive. My company recently merged both the Communications and Marketing departments and I have been tasked wi…
API & Developers361
Travis Pryor
Multi select column via API shows as a TEXT_NUMBER typeAccepted Answer

Accepted Answer Sean Smith 27 views 2 comments 0 points Most recent by Sean Smith 06/19/20

First post 06/18/20,Last post 06/19/20
I am trying to update the options in a multi select column via API but if fails with 1|bot | [Smartsheet] 2020-06-18T11:12:30.360Z[ ERROR] Request failed after 0 retries 1|bot | [Smartsheet] 2020-06-18T11:12:30.361Z[ ERROR] PUT https://a…
API & Developers272
Sean Smith
What are the allowed characters can be used to create a new Folder in smartsheet?Question

Answered - Pending Review buddhadev.karmakar 31 views 1 comment 0 points Most recent by Ben G 06/18/20

First post 06/18/20,Last post 06/18/20
I am creating Folders within smartsheet workspaces using smartsheet C# SDK. What all characters are allowed to use in folder name?
API & Developers311
buddhadev.karmakar
How do I link a story to an epic via the Smartsheet to JIRA connectorQuestion

Answered - Pending Review Mike White 39 views 2 comments 0 points Most recent by Mike White 06/18/20

First post 06/16/20,Last post 06/18/20
I want to create a workflow that uses a Smartsheet form to populate a sheet that then creates relevant JIRA tickets. I have the connector working, but I can't seem to create a new story and assign it to an existing EPIC. The Epic Name and …
API & Developers392
Mike White
Live Data Connector not finding sheetQuestion

Answered - Pending Review Faith Glass-Wilson 25 views 1 comment 0 points Most recent by Genevieve P 06/17/20

First post 06/16/20,Last post 06/17/20
Hello, I've setup the Live Data Connector and it seems to be working correctly. But the sheet I'm an Admin on is not displaying as a possible connection. Does anyone know how I can fix this?
API & Developers251
Faith Glass-Wilson
Conditional Logic in Smartforms (AKA Cascading Dropdowns)

Richard Rymill SBP 1.4K views 16 comments 0 points Most recent by Richard Rymill SBP 06/17/20

First post 09/10/19,Last post 06/17/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 & Developers138216
Richard Rymill SBP
How do I stop Popup of linked sheetsQuestion

Answered - Pending Review Kathy 21 views 3 comments 0 points Most recent by Paul Newcome 06/15/20

First post 06/15/20,Last post 06/15/20
How do I stop this linked sheets popup? Even if I scroll the sheet the entry cell and the popup travel together. Because the sheets are linked to many of the cells, this happens for every linked cell. (Image)
API & Developers213
Kathy
How to track the days taken by each approvalAccepted Answer

Accepted Answer flashock 21 views 4 comments 0 points Most recent by BrianBosché 06/15/20

First post 06/10/20,Last post 06/15/20
I have a document that require 5 levels of approvals. How can I track how much time (days) taken for each level to approve?
API & Developers214
flashock

API & Developers

API & Developers

Discussion List