In our business we have multiple marketing teams each with their own board. I’m trying to create a business wide social media calendar that picks up the social media posts from each board without adding an extra place for people to update
I’ve connected the boards and have an automation set up with a mirror column to update the status. The only automation I can see that is suitable is to action something when a column changes. The issue we have is that every time the date changes, it creates a new item in the connected board. I tried it with a condition, but that didn’t work as we don’t always have a date for the social media post when starting work on the task.
I need a solution that blocks duplicate items being created in the connected board and a way to ensure that when the date changes on main board, it’s updated on the connected board.
To add complexity to the issue, I also need to replicate the solution across a number of boards that feed into the connected social media calendar board.