Hyperlink in a value cell with formulas

Peggy Huang

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!  

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