Data Uploader Tool - New Columns in Attachment not showing on Mapping
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?
Best Answer
-
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.
Answers
-
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.
-
I think that is literally the only thing I didn't try ...
and of course it's the thing that make it work ...
Thanks!
-
Ha! That's always the way it goes.
No problem.
