API & Developers

Archives for March 2020

Smartsheet Live Data Connector ODBC issue with SSIS package
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 token and my own credentials (we use SSO to log in). From my local machine, the package runs…
Connecting to Smartsheet from Oracle Analytics Desktop 12c
Hello, 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 connect directly from a data visualization tool (Oracle's Analytics Desktop 12c) and I am…
In automatic reply, It's possible to add any images in customize reply.
working in auto reminder / alert someone workflow automation. In customize reply it is possible to add any image or pics in mail body.
It's possible to create clone sheet of my main sheet.
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.
search api doesn't pull up partial matches or numeric search
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 sheet ac sheet account sheet account10 These are the issues When I query "a", it returns…
Access level in dynamic view..?
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 dynamic view or will create multiple dynamic view.
how to create / show country wise report in smartsheet dashboard ...?
working on different different countries data , In smartsheet how to show country wise report in dashboard..?
Hide dynamic view columns
Based on approved and not approved criteria how to hide columns in dynamic view.?? using field logic's but does't work..
how to freeze columns in smartsheet
how do we freeze first 4 column in my smartsheet so that we i move to right column 4 columns freeze and visible..
Failed to send a single value to a multi-select dropdown column
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 finished entering on local Excel, they need to send entire row to Smartsheet, however it…

Trending in API & Developers

COUNTIFS and OR
Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = "Planned", {RegSci Review Projections…
When a new row is created in Smartsheet, Create SharePoint List Item
I'm trying to do my first Smartsheet Power Automate flow. I've created a SharePoint list to hold the data. When a new row is added to a Smartsheet, I would like for that row of data to be used to create a new item in a SharePoint List. The part that I need help with is the mapping of the columns from the SharePoint Create…
Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,

API & Developers

Discussion List