Problem when date arrives to google sheet

What Happen:

when a facebook lead is added and sent to my google sheet, on the date side, the correct date appears for 1 millisecond and then I think it is calculated and gives me other information… I have tried everything but there is no way.

The formula that I apply is this for the date function: {{formatDate(1.dateCreated; “MM.DD.YYYY”)}}

@Coorve This is really straight forward. It is an issue with your Google Sheets Column formatting.

Fix it like this.

Get in touch,
Manish Mandot

1 Like