Is it possible to have the ability to have hyperlinks in cross sheet formulas?
We created an environment through SCC and at times, Portfolio Managers wanted to be able to have a field in their reports, dynamic views, etc. that had a link to the templates. Based on functionality and user feedback, users had to use a grid (not a report) and sometimes with reports, to maintain control/access we created dynamic views especially to have the ability to have column help text.
It would be nice to have the ability to keep hyperlinks active across sheets, reports and dynamic views without giving people access to rollup summary reports or source grids.