Multi-Project Dashboard Template Set

Sldollman

Hi community! 

I am attempting to use the Smartsheet-provided "Multi-Project Dashboard" template set.

I've successfully created a project plan template, but am very confused as to how to roll the individual projects up to a dashboard. 

In the set, there is a rollup report, as well as a project master list.  I'm having trouble figuring out how these 2 are used together to feed the dashboard template.

Has anyone successfully used this template set?  Or, does anyone have any advice on how to (semi-easily) roll up data from multiple project plans to a dashboard?

Thanks for any help you can provide!

Andrée Starå

Hi,

There are a few different ways to structure a solution.

In the Multi-Project template set, I think they used cell-linking to structure it.

More info: https://help.smartsheet.com/articles/861579-cell-linking

I hope that helps!

Let me know if you have any questions!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Cheryl Camacho

Where would I find the Multi Project Dashboard Template set? I don't see it in my Solution Center.

Thank you in advance!

Andrée Starå

Hi @Cheryl Camacho

Here you go!

https://app.smartsheet.com/b/publish?EQBCT=88da2ec2912544208ee53600867a0d60

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!