Can I filter for Current User in a Sheet Summary Report?

Joe Frazee

I would like to create a Sheet Summary Report that shows summaries for only those sheets where the current user is the project manager. I have a series of sheets and each sheet has a summary field of contact list type and containing the project manager.

When building the summary report, I created a filter where the Project Manager field "is one of" and checked "Current User". However, when the report is run no results are returned. I also tried to select one project manager's name that appears in filter the drop-down box. No results. Strangely, when I go back into the filter builder the Project Manager field is no longer selected in the Select Field drop down box.

Is there a way to have a Current User filter on a Sheet Summary Report?

Thanks.

Debbie Sawyer

Hi Yes, I appear to be able to do it on a test.

I'm happy to jump on a zoom session with you and walk you through it.