Dashboard Hyperlinks

I have a dashboard widget that contains a hyperlink to a form. There is a connected access sheet that we use to create individual hyperlinks for multiple clients using a query string. Currently I am copy/pasting the hyperlink from my access sheet into my dashboard widget. Does anyone know if it is possible to link the hyperlink to the cell in the access sheet? I'm trying to eliminate the need to edit the hyperlink on the dashboard every time it changes in the access sheet. Thank you in advance for any suggestions.

Answers

  • Hi @Michelle Martinelli

    What I would do in this instance is create a very simple Report that only pulls that one specific cell data with the hyperlink in it (either the hyperlink or the full URL). Then you can put this as a Report Widget on your dashboard, which will display the hyperlinks as live links, meaning that they're clickable and they will automatically update as you update the source sheet:

    I hope that helps!

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!