Pulling a report from multiple workspaces

edited 12/09/19 in Smartsheet Basics

We are already using personal workload reports to pull tasks from many sheets within one workspace (for us, project).

I would like to build on this by seeing:

1. My tasks from two workspaces/projects in one single report, showing chronologically

2. Tasks from my personal task list sheet within that report too

Bearing in mind that sometimes projects set their column headers up slightly differently, will this work? Would we need to make everything consistent between projects before doing something like this? I'm struggling to get it to behave so want to make sure I'm trying to do something that is possible.