Hyperlink from Sheet clickable in Metric Widget on Dashboard

crwelch ✭✭
edited 12/09/19 in Smartsheet Basics

We are having people create a hyperlink in a cell on a sheet to a word document saved on our O365 sharepoint. I want this link to then be available on the dashboard. I currently have the cell linked in the Metric Wizard, but when viewing the dashboard, the link is broken and only the words are there. The users are not able to edit the dashboard and this is the only place they can add the hyperlink. Those viewing the dashboard need to be able to access the links. I am an admin myself and cannot get it to function, let alone those with viewer rights.