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.
@Owen Passmore You could do this with the new DashCards power up:
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.
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.
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.
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,
Hello Community! My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. In this video, I'll share my favorite Trello templates. Templates mentioned in ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events