Filtering by a Summary sheet field in a Row Report

Maurizio Caputo

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.

Leibel S

Create a helper column.

Column Formula would be:

=[summary sheet field name]#

Leibel S

Create a helper column.

Column Formula would be:

=[summary sheet field name]#

Maurizio Caputo

Thank you. This worked. I just need to make sure that each one of the sheets has this helper column.