Column Type won't stay, formula to change display text then?

I’m using the beautiful Google Sheets → Coda integration. However, my column types aren’t staying as they should. I’ve mentioned them to that gentleman but thought I’d try another approach.

The date is showing up in Coda as: 2021-08-05T04:00:00.000Z

Is there a way to take this and convert it to MM/DD/YYY (or use dashes)?

Dear @agoodman,

The format of your column should be set to “Date Time”, please can you check that one.

image
And with the options you can set the lay-out format of the provided date-time info

Does this work out for you

Thank you for your help! It didn’t work but I had some bigger issues as the entire workflow blew up. :slight_smile:

I’ll keep digging to see what else I can do.