Report showing resources and assigned projects

frobison14816 ✭✭✭
edited 12/09/19 in Smartsheet Basics

I'm looking for help developing a report. I've got multiple projects and multiple resources working on those projects, and I'd like a simple grid - resources in a column, project names across the top, and an x indicating which project each resource is working on (or something like that). This view will give a snapshot of who is working on which project.

I know the utilization report gives a nice view of projects by person, but I'm looking for that matrix, preferably without a lot of manual manipulation. I'm okay dumping data to Excel and messing with it, but I'll want to do this once a week so I want it easy.

Any thoughts?