I could have sworn that I have done this before, but I cannot get it to work completely now, so I need help. Via my Control Center configuration, I am currently populating my Project Intake form with a hyperlink to the project dashboard. In addition to that, I want to also send that same hyperlink to my Blueprint Summary, which will allow me to use that link on my executive dashboards.
I am trying to do that by including the dashboard link as Profile Data and it is also checked on the Blueprint Summary config. It appears correctly on the Intake Sheet, but my metadata sheet and Portfolio Summary sheets get the text name of the Dashboard, but not a link.
I have also tried to do this using a INDEX/MATCH formula pulling from the Intake Sheet, but that also returns the text but not a link. Am I missing something simple in the Control Center configuration? I appreciate anyone's assistance with this question.
Steve