Run a report against all workspaces?

Mike L.
Mike L. ✭✭✭
edited 12/09/19 in Smartsheet Basics

Is there any way to create a report that checks all workspaces?  For example I want to make a report that shows a project manager everything that is assigned to her. If I make the report today I need to manually select 8 workspaces.  If I update the report it will probably grow to 16 workspaces.  If I make reports for 20 project managers do i need to manually update the "Where" criteria every month?  I'd like to avoid this if possible.  I'm really just looking for a better way to let project managers manage their workload.  This is step one.  Step two is a report where the project manager can look at any assignement for others where they are the active project manager.  Thanks for your suggestions!