Need to skip a column.

[vishalnegi]

Hi. I am pasting column H-K in an output sheet. However, i want to skip copying the J column in the output as in output file this row has a formula. it would be helpful if you can share your workflow

[gautiergodard]

hey @vishalnegi 

one way to do this would be to use a dynamic select in your workflow that would skip any column named "YOY"

[SGolnik]

If you are writing to a template that has a formula in it, I recommend splitting your data into two different output streams using a block until done tool and two output tools to write to a specific cell range. This will allow you to write the data on either side of that column without messing up the formatting of your template. Make sure you check the box in the configuration of your output tools to preserve formatting.

[vishalnegi]

Hi the issue still persists. It is moving replacing "YOY" column with "FY'17"

[binuacs]

@vishalnegi  as @SGolnik mentioned you need to write your results in a specific range