I am trying to get information from one spreadsheet (that’s automatically completed as google forms responses come in but we hate the format). i.e. the date/time stamp when a simple 4/22 is what we are looking for. I can format the initial sheet but it doesn’t stay formatted for new forms responses. Is there a way to format the zap to change the date and phone number formats that come in a different way?
Best answer
How do I format dates and phone numbers from a Google Form to a Google Sheet?
Best answer by Troy TessaloneBest answer by Troy Tessalone
Hi
Good question.
Check out the Formatter app.
Help articles:
https://zapier.com/help/create/format/modify-number-formats-in-zaps
https://zapier.com/help/create/format/modify-date-and-time-formats-in-zaps
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 31507 replies
- Answer
Hi
Good question.
Check out the Formatter app.
Help articles:
https://zapier.com/help/create/format/modify-number-formats-in-zaps
https://zapier.com/help/create/format/modify-date-and-time-formats-in-zaps
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.