API & Developers
Archives for March 2020
Discussion List
-
Smartsheet Live Data Connector ODBC issue with SSIS packageUnanswered QuestionFirst post 03/31/20,Last post 03/31/20https://us.v-cdn.net/6031209/uploads/679/9YDP1KCPPOD8.png 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 …API & Developers250David Lam -
Connecting to Smartsheet from Oracle Analytics Desktop 12cAnswered QuestionFirst 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 & Developers131Manish Hathi
-
First 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 & Developers174Yashwant Singh
-
It's possible to create clone sheet of my main sheet.Answered QuestionFirst 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 & Developers224Yashwant Singh
-
search api doesn't pull up partial matches or numeric searchAccepted AnswerAccepted Answer Balamanohar B 25 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 & Developers254Balamanohar B -
Access level in dynamic view..?Answered QuestionFirst 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 & Developers201Yashwant Singh
-
First 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 & Developers81Yashwant Singh
-
Hide dynamic view columnsAnswered QuestionFirst 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 & Developers151Yashwant Singh
-
how to freeze columns in smartsheetAnswered QuestionFirst 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 & Developers103Yashwant 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 & Developers142Roy Yue -
Dynamic View required any licence access for end userAnswered QuestionFirst 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 & Developers262Yashwant Singh
-
First 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 & Developers191lea montfajon
-
Hide details in a sheetAnswered QuestionFirst 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 & Developers2811Yashwant Singh
-
Update all rows with dependency defined (Duration and Predecessors)Answered QuestionFirst 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 & Developers441Joy Biswas
-
SmartSheet API creation of a crosssheet referenceAnswered QuestionAnswered Pawel Andrzejczak 19 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 & Developers192Pawel Andrzejczak
-
How to Add hyperlink or button in smartsheet formsAnswered QuestionFirst 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 & Developers337Yashwant 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 & Developers131Kipdodgr
-
It's possible to create a dynamic dropdown list in smartsheet form.Answered QuestionFirst 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 & Developers333Yashwant Singh
-
First post 03/09/20,Last post 03/11/20https://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 & Developers221Meaghan Dunn
-
Getting Source as "sheet" for every sheet.Accepted AnswerAccepted Answer mukund waghmode 27 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 & Developers276mukund waghmode
-
Accepted Answer Prateek Fulsundar 23 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 & Developers233Prateek 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. https://us.v-cdn.net/6031209/uploads/010/AGEYSZNRDHSW.png The CRD column is Cargo Ready Date, which i…API & Developers223Roy Yue
-
Sourcing drop down listAnswered QuestionFirst 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 & Developers251Natia Akhvlediani
-
Why do Smarsheet webhooks force developers to create webhooks only in a production environment?Accepted AnswerAccepted Answer Cameron Lenartowich 49 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 & Developers494Cameron Lenartowich
-
Close Pending Update Requests when a new update request is sentAnswered QuestionFirst 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 & Developers323Ramsay Zaki
-
GET Pending Update Requests onlyAnswered QuestionFirst 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 & Developers199Ramsay Zaki
