How to Display Clickable Links on a Dashboard That Update from a Metric Sheet

I need to add clickable links on a Smartsheet Dashboard that automatically update based on changes made in a Metric Sheet.

I tried using a Metric widget, but the links appear only as plain text and are not clickable.

Is there a way to have hyperlinks on the Dashboard that stay clickable and get updated whenever the Metric Sheet is updated—without allowing end users to manually edit the Dashboard?

Any suggestions or best practices would be appreciated.

Find more posts tagged with

Sheets

Dashboards

Cell linking

Accepted answers

All comments

Paul Newcome

You will have to use a report to pull in the hyperlink row and then use a report widget on the dashboard.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.