Upload -Data Shuttle

HZAR

I have follow all the step in setting up the data shuttle upload and do only for 1 mapping buts when I want to Name the workflow it give the error-One or more of your sheet columns names are using the same name. Update the sheet columns in the mapping to only use unique names.

Screenshot 2023-10-31 150112.png

Screenshot 2023-10-31 145923.png

Genevieve P.

Hi @HZAR

Can you post a screen capture of the source file's column names (but block out sensitive data)? Is is possible that some of your columns (even ones not mapped) have the same exact name?

HZAR

Agile LCP1.xlsx

Requests Tracking.xlsx

Hi Attached is the file example-just the header. Rite now I want to map 2 column from Agile.LCP1 to the Request Racking since tthe data from Agile is huge and cannot support with smartsheet sheet. Is this what ur looking for. Pls help to advise

Genevieve P.

Hi @HZAR

In the Mapping part of the workflow, is it possible that you used the +Add a new column button to create a column in the destination sheet instead of using the dropdown list to find that column?

The error message you're seeing will occur if there are two Sheet Columns with the same name:

Does that help?

HZAR

I have added as per suggested but still given me the error when want to save the workflow

Genevieve P.

Hi @HZAR

My apologies for not being clear - the suggestion is to make sure you have not added a column, but instead are using the one that already exists in the sheet.

Did you click "+add a new column" or are you using one that exists?

HZAR

I have using add a new column since my 1st trial out is using the map to existing column from source to target is not working and given me the error. Let me try again and see.

Pranav M

Hi @Genevieve P.
Even I am facing same issue as HZAR and I checked all your suggestions and I vent used add new column feature and my destination sheet does not have any duplicate columns and even mapping does not have duplicate column names from sheet. Can you please help me with this?

Genevieve P.

Hi @Pranav M

Instead of Adding a column, the workflow should already find the column name and then you select it from the dropdown. Is this what you're doing?

If you're still having trouble, you can contact Smartsheet Support with a screen recording showing the mapping and both files (source and destination). They can troubleshoot with you in a private channel. 🙂

Cheers,
Genevieve

Silicon Valley PM

Hello @Genevieve P.:

I am also coming across the same issue. The columns are pre-existing within the target sheet, the corresponding names were selected during the mapping step, and I am receiving the "One or more of the columns in your target sheet are out of date. Please refresh your mapping to retrieve the latest column details." error message. Any recommendations?

Thank you!

Silicon Valley PM

To follow up, I noted that having empty "Sheet Column" text boxes may contribute to the issue. After ensuring all empty fields were selected, I named the workflow; however after saving I received a separate error (An unexpected error occurred. Please contact support if the problem persists.). Is Smartsheet possibly undergoing maintenance?

Genevieve P.

Hi @Silicon Valley PM

Were you able to get this resolved?
If you're still seeing a generic error telling you to contact Support, I would recommend capturing a screen recording and submitting this in the Support Portal along with the sheet URL and a copy of your external file.

Thanks!
Genevieve