Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,328,575
Community Members
 
Community Events
168
Community Groups

in Trello csv export doesn't have card added dates

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!

1 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

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)

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

Friday!... but wait!!

It's Friday!!!  I know you want to run away but wait.... I'll tell you what I'm going to do to REST MY MIND for the weekend, in case it might help you: I REVIEW my pending things in...

142 views 2 8
Read article

Atlassian Community Events