Dashboard Template

I have multiple projects that have their respective project schedule sheets and I created a dashboard of one project. I was wondering if there was a way to make a template of that dashboard so that I could make the same dashboard for all of my individual projects.

Find more posts tagged with

Templates

Project Management

Comments

Stefan 7k

Hi,

not really.

As you may have seen, there is no "Save as template" option. Makes sense, as a dashboard usually connects to multiple project specific reports and data for it's widgets.

On Enterprise plans you can use the Smartsheet Control Center (SCC) to roll-out a set of sheets for a project type, including dashboards. SCC does all the magic link modification in the background. Shure, you need to configure this and you need to setup your templates in a structured way, so that a dumb computer can always identify the correct target for links.

If Enterprise is no option for you, then you could probably start with the set of sheets needed for a project in a "template" folder, make all the links and dashboard connections work there.

This would allow to copy the folder with all its sheets to a new destination. You'll need to make shure, that in the copy dialog the links in the sheets target the new destination.

Hope this helps to get you started.

Stefan

Elvis_P

I've been working with Smartsheet for a few months now and at least having some sort of dashboard themes would be really useful. A color hierarchy could be set up so that titles and charts always start with my companies main color and then cycle through dimmer and dimmer shades before switching to a secondary color.

Could I submit a feature request for that?

Thanks,

Elvis

Andrée Starå

Hi Elvis,

Yes, it's a great idea! That would be a great addition to Smartsheet features.

Please submit an Enhancement Request when you have a moment.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sam Gollon

I actually found a fairly useful work around to this. If you have a dashboard (or any linked docs) that you want to create as a template, try the following:

Take the template dashboard itself as well as the linked sheets, reports, and associated docs that feed into the dashboard and place them all in one folder.

Select the folder, click "Actions", select "Save as New...", and then "Save".

The newly created "Copy" folder should contain the dashboard and all the associated docs which all should be linked to the docs within the new folder.

After this you would really only have to change to document names to reflect the current project.

Rinse and repeat for new projects.

Hope it helps!

Ann Spore

Sam Gollon - Thank you for the suggestion! Using my custom master dashboard as a template, I needed to create individual project dashboards. The thought of setting them each up and customizing with our brand colors was daunting. Thanks for the easy fix. SS should definitely allow for converting a dashboard into a dashboard template.

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…