Apology for the late reply. From what I am reading it can be done using a power-up. "Zapier" is one you can read more about and see if it meets your needs.
PS: I am not advertising for any vendor. I am just suggesting. You may find a different power-up. I don't think it can be done directly from Trello without the use of a power-up.
Please click here to read more on how it can be done.
If you had to thrive a new habit during a lockdown, what would it be? Trello
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