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?
Answers
-
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
-
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?
-
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!