Filtering by a Summary sheet field in a Row Report

I am trying to create a report that will include not completed tasks from all my projects with a due date either 5 days in the past or 5 days in the future. This way I can look at it and either get updates or make sure the resources are working on the tasks due soon.

However, I have cancelled projects in my workspace that I would want to filter out. The only field that indicates that the project is cancelled is a Summary Sheet field, and not a column for each task. Is there a way to either filter by this summary field, or somehow bring it as a helper column so it is added to each row?

Any help would be appreciated.

Best Answer