I'm trying to create an email automation.
I have a custom field called "Contract expiry" - I would like an email of all the cards where Contract expiry is in the past. For the life of me I can't get this to work!
I first set this up - it sends an empty email (no cards listed):
every month on the 15th, create a report in variable "upcoming_renewal" with all cards with custom field "Contract expiry" set to a date less than 1 days from now, and send an email notification to "me@somewhere.org" with subject "Orgs with overdue renewals" and message "{$upcoming_renewal}"
Would appreciate any help! The Trello documentation is not very helpful in this regard.
