Resource Management

nick.wilson

Is there a way to create a master agile resource tracker and link it to every other project without having resource management?

Genevieve P.

Hey @nick.wilson

If you're on a Business or Enterprise plan, you can use a Report to look at data across multiple sheets. As long as your Resource columns with contacts are set as single-select, you could Group by the contact column to view each person's assignments across multiple sheets.

Reports can display content in a Gantt view so you could see if any tasks for the same person contain overlapping dates (sorting the Report by the Start Date column).

Cheers,

Genevieve

nick.wilson

Great answer Genevie, how do I tie the one sheet to all the project I have created?

Genevieve P.

Hi @nick.wilson

When you're creating the Report, you can select all the project sheets you want to reference.

Here's a free webinar on reports that you may find helpful:

SmartStart: Reporting | Smartsheet Learning Center

https://help.smartsheet.com/learning-track/onboarding-webinars/smartstart-reporting

Learn how to report on your work at every level with: Sheet Summary to define, organize, and understand sheet data Reports to consolidate rows from multiple sheets into a single view Roll-up metrics by grouping and summarizing report data To attend a live webinar, register here.

Cheers,

Genevieve

nick.wilson

Your a life saver, thx!