Answered

How to keep UK Date format to Google Sheets

  • 12 August 2021
  • 2 replies
  • 90 views
B

Hi, 

We have a date question that is linked to Google Sheets.  

 

On the typeform the format is UK. 

When connected to Google Sheets it inserts as US format, even when the destination column is set at UK format.  

Can anyone help with this.

 

Thanks 

icon

Best answer by Liz 12 August 2021, 17:55

View original

2 replies

Liz
Rank
Userlevel 7
Badge +5

Hi @Ben Curry Thanks for stopping by! Our API sends the data to Google Sheets in the UTC format, which is why you’re seeing the date appear as it is. While we don’t have an option to change the output of the date, you could setup a formula within Google Sheets to change this automatically for you. 

This post here might help you with editing the data: 

Let me know if you think of any other questions!

Life is a series of awkward moments separated by snacks.
A

BIUE

 

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs