When running VLOOKUP how to bring over the URL value into (this is to bring over a picture on a cell
I am running VLOOKUP to bring a picture located in a specific row cell over a new sheet cell. The issue is that picture comes as a text (picture name).
My ultimate goal is to pull that picture into a dashboard, when trying that, just the text comes
If I bring picture directly from the smart sheet where picture is located over my dashboard, no problem, image comes along. But not through VLOOKUP
Any ideas?
Best Answer
-
Hi @Gilberto
Unfortunately, at the moment, Smartsheet doesn't have the capability to pull an image stored in a cell from one sheet to another. So, whether you try a VLOOKUP or INDEX/MATCH, it doesn't pick up the value. You can pull the image to another sheet only by way of a cell link, which is similar to what happens when you use the metric widget to pick up the cell's data.
Thanks,
Aravind GP| Delivery Manager
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Answers
-
Hi @Gilberto
Unfortunately, at the moment, Smartsheet doesn't have the capability to pull an image stored in a cell from one sheet to another. So, whether you try a VLOOKUP or INDEX/MATCH, it doesn't pick up the value. You can pull the image to another sheet only by way of a cell link, which is similar to what happens when you use the metric widget to pick up the cell's data.
Thanks,
Aravind GP| Delivery Manager
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
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
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives