Auto-Populate Master Task List

Dema A

Hello,

I am managing several projects for our team. Each project has its own task list and project elements. I would like to create a master task list that is a combined list of all the project task lists and I would like for it to automatically populate when there are any updates to the project tasks lists. Is there a way to do that?

Thank you,

Dema

Paul Newcome

Have you looked into creating a report?

Dema A

Hi Paul,

I have not. I am still new to Smartsheets so still getting the hang of things. I have reports created for each project but don't have a master one combined.

Thank you,

Dema

Paul Newcome

You can create a report that looks at multiple sheets and pulls in the same columns and applies the same filters.