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

ro.fei

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?

Ray Lindstrom

Hi @ro.fei,

That's a great idea, and would be nice to have. Unfortunately it's not something you can do currently. I would recommend submitting a Product Idea here https://community.smartsheet.com/categories/smartsheet-product-feedback-&-ideas?sort=top

An inbound cell-link blocks you from being able to manipulate the data unless you remove the link.

BRgds,

-Ray

ro.fei

Thanks, that's what I'd gathered. I just submitted an idea as you suggested.

Do you have any ideas for workarounds? Is there possibly some crazy way to make it work with a helper column or something like that?

Genevieve P.

Hey @ro.fei

The only way to have a clickable link in the same cell as other content is to have it be the fully URL displayed. This means you could have a link to a sheet and the contents from your cell-linked column if the link was the URL to the sheet:

Cheers,

Genevieve