API & Developers

In automatic reply, It's possible to add any images in customize reply.Unanswered Question

Question Yashwant Singh 7 views 0 comments 0 points Started by Yashwant Singh 03/28/20

First post 03/28/20,Last post 03/28/20
working in auto reminder / alert someone workflow automation. In customize reply it is possible to add any image or pics in mail body.
API & Developers70
Yashwant Singh
Hide details in a sheetAnswered Question

Answered Yashwant Singh 25 views 10 comments 0 points Most recent by Lititia Briggs 03/27/20

First post 03/16/20,Last post 03/27/20
I am working on a sheet which contain multiple country wise data. i will share sheet to all country wise reviewer to update information.. i want to hide sheet data and show only respected country data to end user.. how's is possible.??
API & Developers2510
Yashwant Singh
search api doesn't pull up partial matches or numeric searchAccepted Answer

Accepted Answer Balamanohar B 23 views 4 comments 0 points Most recent by Balamanohar B 03/26/20

First post 03/19/20,Last post 03/26/20
Hi, I'm using smartsheet integrations and use search API to get the queried sheet name. https://api.smartsheet.com/2.0/search?query=myquery&scopes=sheetNames Example: Assume that these are the sheetnames I have created a sheet a ac she…
API & Developers234
Balamanohar B
It's possible to create clone sheet of my main sheet.Answered Question

Answered Yashwant Singh 21 views 4 comments 0 points Most recent by Andrée Starå 03/25/20

First post 03/23/20,Last post 03/25/20
i want to create 2 dynamic sheets based on same input. but some columns might be visible. so i will create separate view or any clone / copy paste options are available.
API & Developers214
Yashwant Singh
Update all rows with dependency defined (Duration and Predecessors)Answered Question

Answered Joy Biswas 44 views 1 comment 0 points Most recent by Alejandra 03/24/20

First post 03/15/20,Last post 03/24/20
In Smartsheets I have these columns Duration, Predecessors, Start and End Date, When I change my base Start date all my rows for EndDate and StartDate are then populated. I am trying to achieve the same functionality by api but when I upda…
API & Developers441
Joy Biswas
How to Add hyperlink or button in smartsheet formsAnswered Question

Answered Yashwant Singh 32 views 7 comments 0 points Most recent by Andrée Starå 03/20/20

First post 03/13/20,Last post 03/20/20
currently working with smartsheet forms and need to share a form for adding new data in my sheet. so how we use hyperlink or button so that user click in this and form automatically open.
API & Developers327
Yashwant Singh
Access level in dynamic view..?Answered Question

Answered Yashwant Singh 20 views 1 comment 0 points Most recent by Alejandra 03/19/20

First post 03/19/20,Last post 03/19/20
working in report where 4 level of view required.. prepare view all columns reviewer view only first 10 columns. manager view only 5 selected columns top level view and only read only access for all columns. it's possible in only one dyn…
API & Developers201
Yashwant Singh
Hide dynamic view columnsAnswered Question

Answered Yashwant Singh 15 views 1 comment 0 points Most recent by Genevieve P 03/19/20

First post 03/18/20,Last post 03/19/20
Based on approved and not approved criteria how to hide columns in dynamic view.?? using field logic's but does't work..
API & Developers151
Yashwant Singh
Getting Source as "sheet" for every sheet.Accepted Answer

Accepted Answer mukund waghmode 26 views 6 comments 0 points Most recent by mukund waghmode 03/19/20

First post 03/09/20,Last post 03/19/20
I have created sheet from template. While calling sheetList api I have included source for getting source of that sheet. But for every sheet I am getting "Sheet" as source. If I created sheet from template or report, it should re…
API & Developers266
mukund waghmode
Failed to send a single value to a multi-select dropdown columnAnswered Question

Answered Roy Yue 12 views 1 comment 0 points Most recent by Alejandra 03/18/20

First post 03/18/20,Last post 03/18/20
Hi, I have a multi-select dropdown column on my Smartsheet, I am trying to send a row from Excel to Smartsheet. Let me make an example, I have two salespeople John and David working on this project called test123, after salespeople finishe…
API & Developers121
Roy Yue
how to create / show country wise report in smartsheet dashboard ...?Answered Question

Answered Yashwant Singh 6 views 1 comment 0 points Most recent by Andrée Starå 03/18/20

First post 03/18/20,Last post 03/18/20
working on different different countries data , In smartsheet how to show country wise report in dashboard..?
API & Developers61
Yashwant Singh
how to freeze columns in smartsheetAnswered Question

Answered Yashwant Singh 10 views 3 comments 0 points Most recent by Andrée Starå 03/18/20

First post 03/18/20,Last post 03/18/20
how do we freeze first 4 column in my smartsheet so that we i move to right column 4 columns freeze and visible..
API & Developers103
Yashwant Singh
Auto-Delete rows X number of days after these rows have been added on SmartsheetAnswered Question

Answered lea montfajon 15 views 1 comment 0 points Most recent by Andrée Starå 03/17/20

First post 03/16/20,Last post 03/17/20
Hello, I would like to create a workflow for automatically deleting rows X number of days after these rows have been added on Smartsheet. For e.g. I would like to delete any row that has been on the Smartsheet for 15 days. Also in genera…
API & Developers151
lea montfajon
Dynamic View required any licence access for end userAnswered Question

Answered Yashwant Singh 24 views 2 comments 0 points Most recent by Andrée Starå 03/17/20

First post 03/17/20,Last post 03/17/20
hi.... currently working on dynamic view and sharing some data to particular columns mail ids. so when i share my data to others it will required any access or login process to end user , I have only the smartsheet and dynamic view access …
API & Developers242
Yashwant Singh
SmartSheet API creation of a crosssheet referenceAnswered Question

Answered Pawel Andrzejczak 15 views 2 comments 0 points Most recent by Pawel Andrzejczak 03/16/20

First post 03/15/20,Last post 03/16/20
I am getting strange error when creating a crosssheet references via API. { "errorCode" : 1002, "message" : "Your Access Token is invalid.", "refId" : "lj4bwkw3k720" } I do not see why woul…
API & Developers152
Pawel Andrzejczak
Multi Select Field Sync Error Via SalesForce ConnectorAccepted Answer

Accepted Answer Kipdodgr 13 views 1 comment 0 points Most recent by Genevieve P 03/15/20

First post 03/12/20,Last post 03/15/20
I have a multi select field in a SmartSheet doc mapped to a multi select field in SalesForce. All values match, however I receive a sync error. It looks like SmartSheet does not separate values with a semicolon (;). Is this a known issue o…
API & Developers131
Kipdodgr
Close Pending Update Requests when a new update request is sentAnswered Question

Answered Ramsay Zaki 31 views 3 comments 0 points Most recent by Andrée Starå 03/15/20

First post 03/01/20,Last post 03/15/20
I need to send out an automated Update Request weekly. However, I have noticed that whenever someone does not action last week's Update Request and this week's gets sent, Smartsheet now thinks there are two update requests pending. So, eve…
API & Developers313
Ramsay Zaki
Notification with Attachments

katherinehall 153 views 11 comments 0 points Most recent by Andrée Starå 03/12/20

First post 02/01/19,Last post 03/12/20
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 & Developers15311
katherinehall
New to API/python dvlpment- need help with directory path nameAccepted Answer

Accepted Answer Prateek Fulsundar 20 views 3 comments 0 points Most recent by Genevieve P 03/11/20

First post 03/09/20,Last post 03/11/20
Hello, I'm looking to develop a use-case using the smartsheet-python sdk. Can anyone give me an example for this line and how it should appear in the code block to successfully pull a sheet as csv from smartsheet to a local/shared folder- …
API & Developers203
Prateek Fulsundar
Send date from Excel to SmartsheetAccepted Answer

Accepted Answer Roy Yue 22 views 3 comments 0 points Most recent by Genevieve P 03/11/20

First post 03/07/20,Last post 03/11/20
Hi, I found a way to send cell value from Excel to Smartsheet, however the date cell value always has error when sending to Smartsheet. https://us.v-cdn.net/6031209/uploads/010/AGEYSZNRDHSW.png The CRD column is Cargo Ready Date, which i…
API & Developers223
Roy Yue
Is there a way to have a Donut Chart Diagram show a negative percentage?Answered Question

Answered Meaghan Dunn 21 views 1 comment 0 points Most recent by Genevieve P 03/11/20

First post 03/09/20,Last post 03/11/20
https://us.v-cdn.net/6031209/uploads/301/DL39D8N399T4.png I'm trying to mimic the donut chart above in a dashboard but can't get the chart to show the negative number. When I select the columns the donut chart shows the following. Is there…
API & Developers211
Meaghan Dunn
It's possible to create a dynamic dropdown list in smartsheet form.Answered Question

Answered Yashwant Singh 21 views 3 comments 0 points Most recent by Andrée Starå 03/11/20

First post 03/11/20,Last post 03/11/20
need to create a dynamic dropdown list in my Smartsheet form so that data automatically pull from data sheet into my form when user click any location or year.
API & Developers213
Yashwant Singh
Why do Smarsheet webhooks force developers to create webhooks only in a production environment?Accepted Answer

Accepted Answer Cameron Lenartowich 48 views 4 comments 0 points Most recent by Cameron Lenartowich 03/09/20

First post 03/04/20,Last post 03/09/20
In the docs, the following is stated: Smartsheet webhooks do not support callbacks to servers using self-signed certificates. The callback server must be using a signed certificate from a certificate authority. The callbackURL cannot be a …
API & Developers484
Cameron Lenartowich
GET Pending Update Requests onlyAnswered Question

Answered Ramsay Zaki 19 views 9 comments 0 points Most recent by Genevieve P 03/09/20

First post 03/01/20,Last post 03/09/20
Is there a more efficient way to get all Pending Update Requests for a sheet? The only way I can figure to do it is to pull ALL Sent Update requests on a sheet (regardless of status) and then filter the array for a Status of Pending in my …
API & Developers199
Ramsay Zaki
Sourcing drop down listAnswered Question

Answered Natia Akhvlediani 21 views 1 comment 0 points Most recent by Andrée Starå 03/07/20

First post 03/07/20,Last post 03/07/20
I saw that people had questions about 'sourcing drop down list' from 2015... why it hasn't been implemented yet? will this feature ever be added ? I found one suggestion to "link another sheet", but it can not be dragged to pa…
API & Developers211
Natia Akhvlediani
Linux Python 3.6 script example to download a Smartsheet?Answered Question

Answered Michael Tuccillo 42 views 1 comment 0 points Most recent by Alejandra 03/06/20

First post 02/28/20,Last post 03/06/20
I've been searching for several days for a Python SDK script to download a Smartsheet that I have previously created. I have an existing Smartsheet with 5 columns, and 2690 rows. I only want to download the first column which is a number…
API & Developers421
Michael Tuccillo
Mass Attachments from Sharepoint OnlineAnswered Question

Answered Spencer Orlin 31 views 1 comment 0 points Most recent by Alejandra 02/28/20

First post 02/25/20,Last post 02/28/20
I am trying to figure out if there is a way to create attachments from Sharepoint URLs in mass. I have thousands of files saved on Sharepoint that have a standardized URL path and naming convention that is derived from values in my Smartsh…
API & Developers311
Spencer Orlin
Field Rules on Forms

jaquisha.redd64971 19 views 7 comments 0 points Most recent by Andrée Starå 02/25/20

First post 05/01/19,Last post 02/25/20
Hello, Will smartsheet look to implement field rules on the forms? For example: Show field: New employee email When field: employee type: New Employee is selected It would be very helpful to show or hide fields on the forms. …
API & Developers197
jaquisha.redd64971
Can I embed smartsheet's functionality onto my website?Answered Question

Answered Karthik Vasudevan 35 views 1 comment 0 points Most recent by Alejandra 02/24/20

First post 02/21/20,Last post 02/24/20
Hello all, I know smartsheet has node.js SDK for its APIs. But, I am looking to embed smartsheet onto my website. Also, looking to convert users action into code. is it currently possible? Is there a proper JS SDK for browser? Many thanks
API & Developers351
Karthik Vasudevan
What is the maximum number of sheets user can get from List sheet api response?Accepted Answer

Accepted Answer mukund waghmode 14 views 1 comment 0 points Most recent by Genevieve P 02/24/20

First post 02/21/20,Last post 02/24/20
I want to know max number of sheets I can get from list sheet api. Is there any limit?
API & Developers141
mukund waghmode

API & Developers

API & Developers

Discussion List