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. Any idea on how I can ensure this does not happen? BTW, we are actually loading a formula with this method, so the string being passed into Smartsheet is something like "=[FirstCol]1 + [SecondCol]1" and the apostrophe being added breaks the formula.