Data Shuttle and Join Collect formulas

gwson ✭✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

Hello, I have a formula JOIN/COLLECT formula that works perfectly fine when referencing a vlookup sheet with manually entered data. Once that sheet is replaced with data shuttle workflow, the JOIN/COLLECT formula no longer displays data, resulting in an empty return (no error). All vlookup references properly reference the columns after complete data replacement.

I used to have these issues when data shuttle was first released when source data column properties were overwritten as a dropdown or date values, but I can confirm that all columns are now properly setup with general/text property. ''

So is the issue with how data shuttle imports the values itself? I can double click into the cell and I do not see any extra spaces or characters. Not sure what is going on.