Hyperlinks in Linked Cells and Cross Sheet Formulas

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.

Sign in to vote!

Find more posts tagged with

Sheets

Formulas

functionality

Idea Submitted

Comments

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

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

Quick Links

Trending ideas

Report Widget Capability - Drag & Drop to create Report Widget in Dashboard from Workspace Panel
Hi, I was creating new dashboard and thought it'll be so nice to have easy drag and drop Report widget capability from Workspace Panel since I always group set of reports under one folder (for ease of finding them what goes on the dashboard). I think this would be great time saver especially if you have similar name…
Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
Asset Sharing should default to View, not Edit
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.