So I have a Google Form which feeds into my Google Sheet (which feed my Awesome Table). Wondering if anyone can advise on two related questions:
1 - My awesome Table seems to change the date format. The form and Sheet show date data as MM/DD/YYYY, but the Awesome Table displays it as DD/MM/YYYY
2 - If possible, I'd actually prefer a more traditional format: Month Day, Year (ie September 6, 2019). When I apply the format change in Google Sheets, it displays perfectly in the Awesome Table, BUT upon any submission of the form, the format change does not carry over to the new data (see screenshot). Anyone know a workaround either in Google Sheets or how to reformat it in Awesome Tables?
Please sign in to leave a comment.