VLOOKUP and links in the linked cell
Hey community,
if I use VLOOKUP , and the linked cell (Cross reference to another sheet) itself contains a link, the result in the cell, where the Vlookup formula is inside, returns aonly the text from the link but not the link itself.
Any idea?
Thanks Kay
Answers
-
You would need to be pulling the URL. If it is a link that is being displayed as a text string, then only the text string will pull.
-
Thanks Paul. Any idea, how to split the link in Smartsheet to the text and URL. Currently, it is in one cell.
1st step: I need to split the cell in Text and URL
2nd step: I can link both cells to the target sheet
3rd step: I need to combine this again in one cell with text and link behind.
Hopefully there is a technical way to make this, otherwise, the cross reference integration stops efficient work.
Thanks in advance
Kay
-
You may be able to do something with the API.
-
So there is no function to split Text and URL and combine them again?
-
Not natively within Smartsheet's core app.
-
Hi, I',m having a similar challenge. I need to bring a picture which is on a cell over a dashboard
I am running VLOOKUP to bring the picture ;located in the row I needed into a new sheet. The issue is that picture comes as a text to the VLOOKUP sheet, therefore when pulling that info to dashboard, just text will come
If I bring picture directly from the smart sheet cell, no problem, image comes along.
Any ideas?
-
Hi @Gilberto
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Here's a possible workaround or workarounds
- Smartsheet API
- 3rd-party solution
- Smartsheet Premium App, Bridge
- Cell-linking
Would any of those options work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives