Pull milestones from multiple projects into single sheet

stephenspake

Hey all!

I'm managing multiple medium-large scale projects within my org, all on their own project plans, and I'm wanting to build a consolidated enterprise-wide tracker so I can see where I'm at with all my milestones in a single plan / dashboard.

Is there a way / template that would allow me to pull in milestones from multiple projects into a single Smartsheet?

Thanks!

KPH

Have you looked at row reports? You can select multiple sheets and any common columns from them, to display in one place. You can then view the report as is, or create a dashboard and embed the report into it.

https://help.smartsheet.com/articles/2482078-build-a-row-report-with-report-builder