Can you add a hyperlink to a cell that's linked in from another sheet?
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?
✅ Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. This will make it easier for others to find a solution or help to answer!
Help Article Resources
Check out the Formula Handbook template!