Sign in to submit new ideas and vote
Get Started

Hyperlinks in Linked Cells and Cross Sheet Formulas

ro.fei
ro.fei ✭✭✭✭✭✭

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.

6
6 votes

Idea Submitted · Last Updated

Comments

  • Trang Nguyen
    Trang Nguyen ✭✭✭✭

    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.

  • Steven Sawyer
    Steven Sawyer Overachievers

    I often need to pull data into a sheet using formulas on cells with hyperlinks. The hyperlinks are broken and only text is returned.