Currently, I am using an extraction of issues and test statues to identify in Excel:
- Failed tests linked to closed issues => for testers to update the status of the test
- Failed tests not linked to any issue => for testers to link them to an issue
- Highlight the issues that need to be replied to or retested (e.g. rejected, fixed)

This involves:
- Duplicating lines where tests are linked to several issues
- Vlookups between issue statues and test statuses

My idea would be to have triggers in the UI and perhaps also by email to ensure the test status compared to the issue status is coherent.