API & Developers
Archives for March 2020
Discussion List
-
Answered - Pending Review David Lam 76 views 1 comment 0 points Most recent by Alejandra API & DevelopersFirst post 03/31/20,Last post 04/06/20(Image) Greetings, I installed and configured both the 32 and 64 bit of the Live Data Connector on my machine and created a SSIS package to read from a Smartsheet and write to a SQL Server table. The ODBC connection is made via an access t…API & Developers761David Lam -
Answered - Pending Review Manish Hathi 46 views 1 comment 0 points Most recent by Genevieve P API & DevelopersFirst post 03/30/20,Last post 04/01/20Hello, Has anyone successfully connected to Smartsheet from Oracle Analytics Desktop 12c? I have installed the Smartsheet live data connector, created a 64 bit ODBC Connection (DSN), tested from within Excel. It works. Now I want to conne…API & Developers461Manish Hathi
-
Answered - Pending Review Yashwant Singh 28 views 4 comments 0 points Most recent by Andrée Starå API & DevelopersFirst post 03/28/20,Last post 03/31/20working in auto reminder / alert someone workflow automation. In customize reply it is possible to add any image or pics in mail body.API & Developers284Yashwant Singh
-
Answered - Pending Review Yashwant Singh 28 views 4 comments 0 points Most recent by Andrée Starå API & DevelopersFirst post 03/23/20,Last post 03/25/20i 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 & Developers284Yashwant Singh
-
search api doesn't pull up partial matches or numeric searchAccepted AnswerAccepted Answer Balamanohar B 44 views 4 comments 0 points Most recent by Balamanohar B API & DevelopersFirst post 03/19/20,Last post 03/26/20Hi, 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 & Developers444Balamanohar B -
Access level in dynamic view..?QuestionAnswered - Pending Review Yashwant Singh 26 views 1 comment 0 points Most recent by Alejandra API & DevelopersFirst post 03/19/20,Last post 03/19/20working 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 & Developers261Yashwant Singh
-
Answered - Pending Review Yashwant Singh 19 views 1 comment 0 points Most recent by Andrée Starå API & DevelopersFirst post 03/18/20,Last post 03/18/20working on different different countries data , In smartsheet how to show country wise report in dashboard..?API & Developers191Yashwant Singh
-
Hide dynamic view columnsQuestionAnswered - Pending Review Yashwant Singh 43 views 1 comment 0 points Most recent by Genevieve P API & DevelopersFirst post 03/18/20,Last post 03/19/20Based on approved and not approved criteria how to hide columns in dynamic view.?? using field logic's but does't work..API & Developers431Yashwant Singh
-
Answered - Pending Review Yashwant Singh 95 views 3 comments 0 points Most recent by Andrée Starå API & DevelopersFirst post 03/18/20,Last post 03/18/20how do we freeze first 4 column in my smartsheet so that we i move to right column 4 columns freeze and visible..API & Developers953Yashwant Singh
-
First post 03/18/20,Last post 04/01/20Hi, 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 & Developers282Roy Yue -
Answered - Pending Review Yashwant Singh 55 views 2 comments 0 points Most recent by Andrée Starå API & DevelopersFirst post 03/17/20,Last post 03/17/20hi.... 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 & Developers552Yashwant Singh
-
Answered - Pending Review lea montfajon 73 views 1 comment 0 points Most recent by Andrée Starå API & DevelopersFirst post 03/16/20,Last post 03/17/20Hello, 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 & Developers731lea montfajon
-
Hide details in a sheetQuestionAnswered - Pending Review Yashwant Singh 47 views 11 comments 0 points Most recent by Genevieve P API & DevelopersFirst post 03/16/20,Last post 03/30/20I 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 & Developers4711Yashwant Singh
-
Answered - Pending Review Joy Biswas 47 views 1 comment 0 points Most recent by Alejandra API & DevelopersFirst post 03/15/20,Last post 03/24/20In 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 & Developers471Joy Biswas
-
Answered - Pending Review Pawel Andrzejczak 51 views 2 comments 0 points Most recent by Pawel Andrzejczak API & DevelopersFirst post 03/15/20,Last post 03/16/20I 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 & Developers512Pawel Andrzejczak
-
Answered - Pending Review Yashwant Singh 206 views 7 comments 0 points Most recent by Andrée Starå API & DevelopersFirst post 03/13/20,Last post 03/20/20currently 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 & Developers2067Yashwant Singh
-
Multi Select Field Sync Error Via SalesForce ConnectorAccepted AnswerFirst post 03/12/20,Last post 03/15/20I 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 & Developers261Kipdodgr
-
Answered - Pending Review Yashwant Singh 114 views 3 comments 1 point Most recent by Andrée Starå API & DevelopersFirst post 03/11/20,Last post 03/11/20need 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 & Developers1143Yashwant Singh
-
Answered - Pending Review Meaghan Dunn 31 views 1 comment 0 points Most recent by Genevieve P API & DevelopersFirst post 03/09/20,Last post 03/11/20(Image) 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 a way that I can mimic the chart above? (Image)…API & Developers311Meaghan Dunn
-
Getting Source as "sheet" for every sheet.Accepted AnswerAccepted Answer mukund waghmode 24 views 6 comments 0 points Most recent by mukund waghmode API & DevelopersFirst post 03/09/20,Last post 03/19/20I 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 & Developers246mukund waghmode
-
Accepted Answer Prateek Fulsundar 40 views 3 comments 0 points Most recent by Genevieve P API & DevelopersFirst post 03/09/20,Last post 03/11/20Hello, 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 & Developers403Prateek Fulsundar -
Send date from Excel to SmartsheetAccepted AnswerFirst post 03/07/20,Last post 03/11/20Hi, I found a way to send cell value from Excel to Smartsheet, however the date cell value always has error when sending to Smartsheet. (Image) The CRD column is Cargo Ready Date, which is set as Date property. (Image) In my Excel, I al…API & Developers503Roy Yue
-
Sourcing drop down listQuestionAnswered - Pending Review Natia Akhvlediani 36 views 1 comment 0 points Most recent by Andrée Starå API & DevelopersFirst post 03/07/20,Last post 03/07/20I 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 & Developers361Natia Akhvlediani
-
Why do Smarsheet webhooks force developers to create webhooks only in a production environment?Accepted AnswerAccepted Answer Cameron Lenartowich 59 views 4 comments 0 points Most recent by Cameron Lenartowich API & DevelopersFirst post 03/04/20,Last post 03/09/20In 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 & Developers594Cameron Lenartowich
-
Answered - Pending Review Ramsay Zaki 59 views 3 comments 0 points Most recent by Andrée Starå API & DevelopersFirst post 03/01/20,Last post 03/15/20I 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 & Developers593Ramsay Zaki
-
GET Pending Update Requests onlyQuestionAnswered - Pending Review Ramsay Zaki 49 views 9 comments 0 points Most recent by Genevieve P API & DevelopersFirst post 03/01/20,Last post 03/09/20Is 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 & Developers499Ramsay Zaki
