Link to Dashboard on Sheets

V_Szombathy

Hello!

I'm trying to figure out if there is a way to have a column on a sheet populate a link to a dashboard if the primary column is not blank. I know how to insert a hyperlink to the Smartsheet Dashboard, but it appears that cannot be converted to a column formula. I've tried creating the link as a Summary Field or on a different sheet and pulling that in with an IF statement, but that only returns the text, not the hyperlink. The goal is to use the delivered link to a Smartsheet item so this can be used as a template.

The goal is that I basically want to make it super easy for people to navigate back to the applicable dashboard from the sheet so if there is a different way to approach it, I would love to hear any thoughts/suggestions!

We will have different sub-dashboards too - Ex. Home, Design, Testing, etc.

Thanks for any ideas!! 😁

Paul Newcome

Why not just use the Sheet Summary fields and show the users how to access the Summary so they can click on the link?

To be able to pull a hyperlink via formula, it has to be the actual URL. If you are using something different as the "Display Text" then a formula will only pull the display text as text and not maintain the hyperlink.

Matt Stewart

@Paul Newcome so there is no solution to pulling the dashboard link into a column so that each task has a link to dashboard? people are working from reports that combine 100's of projects across the field, we need to have a quick way to jump from a portfolio wide task report back into a single project dashboard.

how can i force control center to populate actual link instead of display text? or to extract the link?

Matt Stewart

i found a solution that works on a project plan: right click on cell and insert hyperlink and then choose smartsheet item. this link updates with new project provisions.

that being said, this solution does NOT work on a sheet where people add new items, such as a RAID log.

L Darvesh

@V_Szombathy Hi there. I know your post is a couple of years old but I was just wondering if you ever found a way to fix your issue.

I am using the PMO template set and want the project roll-up/tracking dashboard to automatically pull the One Drive folder link into the dashboard from the Metadata sheet....however I cannot find a way to do this.

Any suggestions would be gratefully received. I DO NOT want any of the 100 users to have access to a sheet or Summary. That would defeat the object of having specific project dashboards.

I am using the Business Plan by the way, not Control Centre.

Many thanks