Link to Dashboard on Sheets

09/07/21
Answered - Pending Review

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!! 😁

Answers

  • Paul NewcomePaul 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.

    thinkspi.com

Sign In or Register to comment.