Is there any way to track whether a card with a due date has been marked as completed in an export?

[Owen Passmore]

I have a board with several cards on it. Most have due dates. Some are marked as complete, some are not. I want to count how many are marked as complete without going through the board manually. I've got both an excel and a CSV export, and they both tell me what the due date is, but not whether or not the card is complete. This seems like a pretty strange thing to miss, so I'm wondering if I've missed something.

[Iain Dooley]

@Owen Passmore You could do this with the new DashCards power up:

https://trello.com/power-ups/6048e897c73d032a983e2a7c/dashcards

Although there isn't an explicit filter for due date completion yet, if you combined it with a Butler command to add the label "Complete" when the due date is marked complete on a card, you could have a DashCard that showed you how many cards were overdue and incomplete versus those which had been completed.

[Sunny Ape]

hello @Owen Passmore and @Iain Dooley 

Another way to do it is to store all the complete cards in a specific list, like one called 'Complete'. You can create a Butler rule to move cards to that list when the Due Date field is marked as done, and vice-versa.

Trello doesn't store any date that a card was 'completed', but that too can be stored in a custom field that Butler can also populate when the card moves into the Complete list.

Since the export to CSV contains the name of the list the card is in, you can use that information to know the card is complete, then cross reference the other custom field to know the date it was completed.

Make sure you also have Butler rules to do the opposite when someone moves the card out of the Completed list or un-checks the Due Date field to then clear the custom field that stores the completed date.

[Dan Ivory]

Hey @Owen Passmore 

Not too sure which tool you are using to export but as you have an Excel export as well, I'm thinking it might be our Power-Up Board Export for Trello?

Regardless, thanks for flagging this, we don't show completed vs not completed due dates with Board Export currently, but we've added it to our backlog for the near future.

I'll try to remember to post back here once it's live :)

In the meantime, this might help, if you filter (press "f" on your keyboard when looking at your board to open filters) for just the cards that have a due date complete then you could manually count them (not sure if that's reasonable or if you have a massive board!)

Hope that helps,

Dan

[Owen Passmore]

Hey Dan, yes I believe that's what I've got. It'll be possible to count them manually, I just thought there'd be a quicker way. Good luck adding it in.

[Felix]

The CSV board export doesn't include all the card fields - you'll need to use the JSON export (which does) instead.

[Sunny Ape]

Are you sure @Felix ?

The CSV files I export out of Trello contain all the fields, including the custom fields.

[Felix]

My CSV exports definitely don't contain the "dueComplete" field for cards. Yes, they do contain custom fields.

[Sunny Ape]

Hmmm, yes, dueComplete is exported in the JSON export, but not the CSV. You can even read the value of dueComplete via the REST API to see if it's true or false.

It's a shame it's not exported in the CSV, since it would be a really useful field to have. The only work-around at the moment would be to export the board as JSON, then convert it to CSV afterwards.