I have 2 projects in Jira. They both use the same 'RYG' custom field that tracks if issues are in Red, Yellow or Green status.
I have an automation in one project that looks for anything that is overdue by 2 weeks and turns the RYG status Yellow. If it is overdue by 4 weeks it turns RYG status field Red.
The automation works as expected in the one project. In the 2nd project I input similar logic, i get issues when the query is validated, but when I run the rule it tells me no issues found. I am at a loss. Any ideas?