in Trello csv export doesn't have card added dates

Question

I want to export by board with a column for when a card was added, or created, or whatever it's called in the backend.

The only data available is last activity, which is useless for my purpose, which is to track how many cards we added this quarter. Is there a way to get this in an export? Thanks!

Bingham Compton · Answer

=(HEX2DEC(LEFT(A2,8)))/86400+DATE(1970,1,1)+time(5,30,0)
Yes this works well,
Big Thank you for sharing :-)

George Brindeiro · Answer

Nice! Super helpful information, thanks!

If someone wants the final formula, assuming Card ID is in cell A2:

=(HEX2DEC(LEFT(A2,8)))/86400+DATE(1970,1,1)+time(5,30,0)

milynnus · Answer

@Brendan Coon learned this recently. The first 8 characters of the card id can be used to get the card created date.

Card ID=left(B2,8)=hex2dec(C2)=D2/86400+DATE(1970,1,1)+time(5,30,0)5f8959abd072dc81627034c35f8959ab160283690710/16/2020 13:58:27