Date field data are not showing correctly in Google Spreadsheets.

  • Profile Image
    sethr
    Asked on December 18, 2016 at 06:27 AM
    the submission date & another date field (tanggal presentasi) in my forms showed incorrectly in my google spreadsheet, what happened? 
  • Profile Image
    Mike_G
    Answered on December 18, 2016 at 07:12 AM

    By default or when you integrate your form with Google Spreadsheet, it should show you the correct format of the date fields in the spreadsheet.

    However, in your case, it's possible that the format was changed for some reason.

    To change it back, select the column that you would like to change (please do not include the headers) then click "Format" from the spreadsheet's menubar, go to "Number", and select the appropriate format for that specific column.

    You can also try to reintegrate (remove integration from present integration and integrate again) your form with Google Spreadsheet using the same Google Account. It would, however, become a different spreadsheet already and connections with earlier integrations will be lost.

    I hope this helps. If you need any further assistance regarding this, please feel free to follow up on this thread and we will be glad to help you.

    Thank you.

  • Profile Image
    sethr
    Answered on December 18, 2016 at 07:31 AM

    Thank you so much! I'll try it