Can you sum a custom field of cards with the same due date?

[Michael Kleen]

Hello, my team uses trello to keep track of our orders, and move cards to different boards representing our production line.  Each card has a due date, and a custom field for that job.  I want to be able to find the sum of all cards that are due on specific days, but I'm not sure how.  I'm trying to work around it by trying to create a "calendar" board with copies of each card but I'm not sure what the next step would be.  I'm thinking if whenever a card with a due date is copied to the "calendar" board, if there's a way to automate a list creation titled the same as the due date (without duplicating dates), and then moving it into that list would be simple to automate and then I could just sum each list, as each list would have every card due on that day.  If this is confusing, please ask questions, I will happily answer them.

[Arkadiusz Wroblewski]

Hello @Michael Kleen 

No not Native.

Your calendar board idea is inventive, but the sticking point is that Trello Automation can't dynamically create lists named after specific dates, which is what would make that approach work cleanly.

Your options are Rest API, Table view (Manually and play with spreadsheets) or Amazing Fields Power Up.