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

Kevin Loo
Kevin Loo ✭✭
edited 12/09/19 in Archived 2016 Posts

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?





This discussion has been closed.