1. What is the problem? Be very detailed.
The date format submitted from a "date" type question from odk collect to google sheets is of the format dd/mm/yy. Is there a way to change this date format to yyyy-mm-dd from the odk collect submission itself. I know you can add another calculate format-date question but this would create a lot of extra columns because I have a lot of date questions in the survey.
2. What app or server are you using and on what device and operating system? Include version numbers.
ODK Collect v1.25.2
3. What you have you tried to fix the problem?
Created a new spreadsheet with different appearance attributes.
4. What steps can we take to reproduce the problem?
Submit a form to google sheets.
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.