Can you add a hyperlink to a cell that's linked in from another sheet?

ro.fei ✭✭✭✭✭
edited 06/22/23 in Formulas and Functions

I'm working on a tracker & we're basically trying to find ways to combine columns. Currently we have a Sheet Link column and a Revenue column. We manually add the hyperlink to the Sheet Link column while the Revenue column links in from another sheet via formula (based on a unique ID in another column).

Our goal is to combine these two columns. We want the revenue to be the value displayed (linking in via formula so all updates are captured) & have it hyperlinked to the sheet. We will still do the hyperlinking manually, or perhaps we could use a helper column. Open to any ideas that can make this possible. As of right now, I'm unable to add a hyperlink because the cell is linking in via the formula I mentioned. Wondering if anyone has a workaround. Is there a way to hyperlink something via formula that I could just add into my existing formula?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!