I have an automation that runs once a week and ensures that the next 4 sprints are always there and ready for planning (essentially, it just creates a sprint record and sets a start & end date that is 7 days after the latest one).
I have another automation that automatically links a sprint to a release when some of their fields (date & team) match.
But sometimes I want to plan a release far enough into the future, where the sprint that it will be worked on has not even been created yet.
Is there a way to automatically create a record in my sprint database when a record in my release database has a date field that doesn’t match the date field in any existing sprint?
I know I can create a sprint when a release is created, I just don’t want to do that if that sprint already exists for that week.