I'd love to be able to add a hyperlink to a cell that links in a value from another sheet. Currently we're unable to do this as linking cells blocks the ability to add a hyperlink. This would add more versatility, particularly with trackers, as you'd have the ability to pull in valuable information while also linking to a valuable resource in the same cell, reducing the number of columns needed & allowing more freedom.
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.
I often need to pull data into a sheet using formulas on cells with hyperlinks. The hyperlinks are broken and only text is returned.