• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hyperlink in Picture of simplified-project-portfolio-dashboard.xlsm


New Member
We purchased and are using the Dashboard template: simplified-project-portfolio-dashboard.xlsm

In place of a phone number in the "Contact (phone)" on Data Tab, Row 7, we want a hyperlink to a Sharepoint page for each project so they can get the next level of detail by project.
How can we make the link be dynamic/clickable on the dashboard page for each project?
We enter the links into Data tab, Row 7 and they work/clickable to SharePoint page from the Data tab, but the text/link is not clickable when displayed on the Dashboard view.
How can we make the text a dynamic link?
Is there a setting or formula that goes into Calculations Tab, cell C60?