Data Shuttle - Input Expressions
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.