Data Uploader Tool - New Columns in Attachment not showing on Mapping

Stefano Ferretti

Hi All,

I'm using the Data Uploader tool with Smartsheet Attachment.

it seems to be working fine, but if the new attachment (excel file) has a new column, I can't seem to be able to map it, even if I have available columns in the Smartsheet sheet where the data is written.

If I try to create a brand New workflow using the same attachment, then the missing column would appear.

I can't be creating new Workflow everytime a new column is added as it would take me way too long

Any ideas?

David Tutwiler

Rather than re-creating the workflow, have you tried just updating the settings in the workflow to see if it will pick up the new columns? At this point you're just trying to get it to read the new sheet to find the new columns, so you could go in and reset the Smartsheet Attachment to something like Google Sheet, then swap back and point it to the right attachment. This should "refresh" the connection and when you go to mapping, should display the new columns.

David Tutwiler

Rather than re-creating the workflow, have you tried just updating the settings in the workflow to see if it will pick up the new columns? At this point you're just trying to get it to read the new sheet to find the new columns, so you could go in and reset the Smartsheet Attachment to something like Google Sheet, then swap back and point it to the right attachment. This should "refresh" the connection and when you go to mapping, should display the new columns.

Stefano Ferretti

I think that is literally the only thing I didn't try ...

and of course it's the thing that make it work ...

Thanks!

David Tutwiler

Ha! That's always the way it goes.

No problem.