Consolidate Metrics from multiple existing and new sheets

Juan-JLC

Hey Everybody,

We currently have multiple workspaces for each individual job that we do. Each job will have its own Metrics sheet that brings data from the other sheets for progress. As new jobs come in, new workspaces are created.

I am looking for a way to be able to create a high level Metrics sheet that can look at all the individual Metric sheets on each job.

I can certainly create one and manually link the data but I'm looking for a way that I can create a more automated one where it can look at existing ones and as well as everytime a new job is created.

I know this might be a long shot but is worth a try.

 

Thanks for your help

Andrée Starå

Hi Juan,

Have you looked at the new Summary Sheet and report feature?

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD