Data Shuttle - Input Expressions

earl_bennett

I am trying to fix an issue that I have with my import.

I have a .csv file that is generated from an MS Project project plan. The issue I have is with the % Complete column. In the .csv file the value is 100%, but when importing it becomes 10,000% in the Smartsheet plan.

I thought I might be able to create an expression like =[% Complete]@row * .001, but I must be doing something wrong because this does nothing.

If I change the .csv file from 100% to 1 things look good in the Smartsheet plan, but not sure this will be a viable solution going forward.

Thanks,

Kelly Moore

Hey @earl_bennett

You will need to first create a column to house this expression in your sheet as the data imports. The csv [% Complete] will map to the helper column. The expression will also be in the mapping list. Map the expression to your final column in your target sheet.

Kelly

Kelly Moore

Hey @earl_bennett

You will need to first create a column to house this expression in your sheet as the data imports. The csv [% Complete] will map to the helper column. The expression will also be in the mapping list. Map the expression to your final column in your target sheet.

Kelly