I am importing an Excel sheet with information about "People" into a Smartsuite table also called "People".
One of my columns Excel is called "Company." It needs to map to a "Linked Record" field in the Smartsuite table.
The Problem:
My data has 174 records that won't import. Smartsuite tells me that these records have bad values in the Company column. The error message says "External Validation Error, Invalid Record Title."
I think it's due to commas, but...
All the bad records have commas, so that is a likely culprit. However, I tried to import with a cleaned version that had no commas, and it sill did not work.
Also, some of my other columns have the occasional comma, but they are not causing an error. It seems like Smartsuite stumbles in importing commas into Linked Record fields.
I also tried importing as CSV rather than XLSS, but doesn't work either.