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!
@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) 5f8959abd072dc81627034c3 5f8959ab 1602836907 10/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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.