Hyperlink in a value cell with formulas

Hi,

I have a hyperlink question and wonder if someone can help me out....

I have a cell with values auto calculated by a formula to show the number of task done. In this cell, I would like to add a hyperlink to a report so when I click the number I can see details in the report.

However, it seems formula and hyperlink cannot work together in a cell. When I created a hyperlink n the cell, then the formula is removed and value cannot be refreshed with changes.

Is there any workaround for this? Thank you!

Find more posts tagged with

Comments

Andrée Starå

Hi Peggy,

Unfortunately, it's not possible at the moment to use links and formulas at the same time, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

A possible workaround except having it in another cell could be to use a Dashboard with a Metric Widget showing the information, and if you click on it, the link will open.

Would that work/help?

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

Request for Update Report (or something like it)
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…
Time Zones
Hi, I am getting conflicting information from Chat GPT and Copilot on whether I can change the time zone for my system time stamps. I have Pacific time showing up. We are in Eastern Standard Time. I have my setting in my profile set for Eastern Standard time, but it doesn't seem to change the created time stamp and the…
Smartsheet Performance Issue
By when the issue will be resolved?