Extract Image using Index and Match/Vlookup
Julia Mazza
✭✭✭✭✭
Hey All -
Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't work in SS. Additionally, I cannot do a direct link, because we are using the "store number" as a "dynamic" lookup. That field will always change. Any help would be appreciated! Thank you!
Julia
Formula
Result
Source Sheet View (Xfinity Retail Store: Store Photo)
Best Answer
-
Andrée Starå
✭✭✭✭✭
Hi Julia,
Unfortunately, it's not possible at the moment to use formula with pictures (to show the picture), but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
5
Answers
Hi Julia,
Unfortunately, it's not possible at the moment to use formula with pictures (to show the picture), but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Any progress with this. It has been on the ask list for almost 2 years. Very upsetting that this is not a feature yet.
Hey Tom,
Unfortunately, Smartsheet still does not have this feature. I came up with a small work-around with automation, 2 sheets and a report. Maybe this will help! Thanks
The automation is simple set to "remind me" to type the Unique identifier (Store number) from Sheet 1 to Sheet 2 when "X" date is met. You could also set it up to just copy the rows, but it brings all the columns with it.
Sheet 1 contains data only and a unique identifier (Store Number)
Sheet 2 contains the photos and Index/Match's to the Store Number to pull some data so I can have it side by side / use it to filter reports
Than I pulled a report based on "x" criteria.
Snip of Sheet 2
Snip of Report