-
Automated import through the API
Dear Smartsheet-Community, I am doing a semesterthesis in coorporation with a company that has been using Smartsheet for a while. My job is to create an automated order tool for AM parts, which serves as an order backlog including the 3D models and part properties and that enables communication with the supplier. Object of…
-
Looking for a way to auto fill the Label and Description on a form
Is there a way to quickly customize label and descriptions on forms? Like for example reference the field that contains the label and description information so it populates based on the primary value. Example I'm using the form as a voting ballot for prioritizing issues. The primary key is the Issue number then there is a…
-
Can I populate Smartsheet rows from a SQL Database read?
I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
-
Error in adding smartsheet as data source in tableau server
Hi All I am trying to publish a sheet to the tableau server so other people in my team can connect using the tableau desktop by logging into our tableau server. I was able to publish the sheet to the server as a data source, but am unable to connect to it again using the tableau desktop The steps I followed are 1.) logged…
-
Possible bug: Smartsheet adds a trailing space to random cells
I've encountered some strange behavior where Smartsheet automatically adds a trailing space to a cell. Below are two columns. The right column adds a "|" to the value in the left column. You can see that in the penultimate row a trailing space is added to the cell: I am using the COLLECT function to show the contents of a…
-
How to connect Smartsheet with tableau desktop on Mac OS
Hi All, I am trying to create a connection to tableau with my smartsheet to pull data into tableau , I am able to do this in windows os using the smartsheet live data connector, but i am not able to find an equivalent for that on MAC os , is there anyway i can make it work on Mac, any pointer /links would be highly…
-
400 5160 Error Code
I've got a number of GET search sheet requests returning the following error code: REST Connector: The remote server returned an error: (400) Bad Request: { "errorCode" : 5160, "message" : "The characters *, ~, : and \" have special meaning in search. Please ensure that your search contains more than just special…
-
Free Data Shuttle Webinar - March 16
Hello! We will be hosting a free webinar on March 16th "Intro to Data Shuttle." Join us here to learn how to automatically and seamlessly upload, or offload, data between Smartsheet and other tools.
-
CDATA import into Smartsheet cause apostrophe problem
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 from SSIS and the apostrophe is definitely not there, so Smartsheet is doing this.…
