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: