When a cell is bringing data from another cell using a formula, it can only show the text, but the hyperlink of the other cell is not clickable in this cell. Looking fwd to be able to click the hyperlink in the formula cell as well.
This needs to be added, a glaring lack of functionality within smartsheet. Excel has had the HYPERLINK function for decades.