Data Uploader to a Sheet where primary column is calc of system generated

Joseph Cormier

I am trying to use Data Uploader to update a Sheet where the primary column is a calc of a system generated column.

Primary Column =[System Generated@row

Uploader will run but it skips all of the rows on the source spreadsheet.

Is what I am trying to accomplish not possible?

Ben Goldblatt

Hi@Joseph Cormier,

如果the goal is to have the Data Uploader pre-populate the primary column value with a formula result, you should be able to do this with an Expression.

This would actually be set in theMappingsection of the workflow and then once it's set, theExpressionssection can be used to modify what you've set up.

When you get to the Mapping section, rather than mapping a value from the source file to the primary column in your target sheet, choose "New/Expression from the field's dropdown list. In theNamefield, you could list "Primary Column" and in theValuefield you can enter the formula.

More information on working with Expressions can be found in theSync Smartsheet and External Systems With Data UploaderHelp article from the Learning Center.

I hope this helps!

Thanks,

Ben

Joseph Cormier

Ben,

Thanks for the reply.

I followed your suggestion but that did not work.

Here is the mapping for the upload.

Here is the expression that I created.

The uploader runs but it is still skipping all of the rows.