Linking Dashboard to Specific Filtered Column in Masterfile

Roxanne Basgen

Hey guys,

I've created my Smartsheet, but I wanted to link my graph back to certain filtered column in my Masterfile, for example, I want to create a link for my Boss to click on a graph called "Project Not Started" =11 and "Project in Progress" =26 and for the graph to take him specifically to a column filtered to Not Started or in Progress on the Masterfile, is there a way to do this?

EvanShortreed

Hi Roxanne,

This can be accomplished by making reports looking at your masterfile and filtered to Not Started and In Progress. You will than be able to tie the metric widget to that report on a dashboard.

Matt Johnson

Hi @Roxanne Basgen

Yes, that's possible but you would actually link to 2 separate reports. The counts would come from a metric sheet too.

I hope that helps.

Matt