Skip to main content

Hey there, brand new to Zapier and I am trying to get entries from Google Sheets to create cards on Trello.

Here is the current flow of my Zap:

  1. Trigger: new row in Google Sheets. Date in spreadsheet is DD/MM/YYYY
  2. Create card in Trello (this ends up setting the date as MM/DD/YYYY)
  3. Date/Time in Formatter (to source the date from the spreadsheet again and to add HH:mm after the DD/MM/YYYY)
  4. Update Card in Trello

Here is the format modification

Updating the Trello card

However the date remains as MM/DD/YYYY

Am I missing something?

Hi @helicopterrave 

In the Formatter step, the To Format and From Format are the same, so you need to adjust the To Format.