In their infinite wisdom Studio X only does dates in en-us (mm/dd/yyyy) which means I can’t directly use a date value in my spreadsheet and paste it into the date field of the web form.
So I’m trying to format the date in the spreadsheet by copying the existing date (column C) and writing it into the next cell (column D) string.Format("=TEXT(C2,"“dd/mm/yyyy”")") but of course I can’t get the formula to increment for each new row, but it will increment where it writes to:
What you need is to use the AutoFill activity. This replicates what you do in Excel when you double click the bottom-right corner of the selected cell.
The result will be:
As a side note, we are aware of the limitation around “value formatting limited only to en-us”. The new packages will contain a project/scope option which will allow you to use the text in the cell as you see it (display value).
Thanks, that worked to fill the column.
The next issue is that as this is an unnamed column when I use the Type into ‘INPUT’ function the Type this selection doesn’t increment the row value:
For unnamed columns you should see “A”, “B”, “C”, … in the dropdown for the “used range” of the worksheet. If the values don’t appear, you can use “Custom input” to specify the column. Please make you sure you have filled in the range you are iterating on in the “For Each Row” activity.
