Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Tableau and SmartSheet - Can't add string and string values
I've enountered an odd error in Tableau while accessing a SmartSheet via the Live Data Connector.
In Tableau, I'm attempting to concatenate a SmartSheet string field with a string contant:
* [Primary Column] + "A" (where Primary Column is defined to be a string).
When I do this accessing the data with the SmartSheet Live Data Connector, Tableau issues an error in the caluculated field editor, "Can't add string and string values".
When I do this accessing the data via an excel spreadsheet created by exporting the SmartSheet sheet, then everyting works fine.
Any ideas why I'm having these issues?