How do I add a condition in Automation that applies to Issues in Future sprints only?

[Kelly Hansen]

Hello!  I have an automation that we remove the sprint when something is marked as invalid.  HOWEVER, we are incorrectly calculating velocity when we do this because we do have pts being worked if its part of the current sprint.  I am trying to figure out how to make my automation ONLY apply to future sprints, however when I select Sprint for Field it only gives me "is empty" or "is not empty" as the two options.

Anyone have any suggestions?

[Jack Brickey]

Hi @Kelly Hansen , you could add a JQL condition and use "Sprint not in opensprints() and sprint is not empty" 

[Kelly Hansen]

Now I feel stupid for not thinking about that. (Hand on face emoji). thank you!

[Jack Brickey]

Glad to assist. Please considering marking the answer accepted to help the accepted answers search gods.