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

Options
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?

 

Thanks.

Tags:

Comments

This discussion has been closed.