Hyperlink in a value cell with formulas

Peggy Huang
Peggy Huang ✭✭
edited 12/09/19 in Smartsheet Basics


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!