Extract Image using Index and Match/Vlookup
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
-
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 EXPERT CONSULTANT & PARTNER
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 EXPERT CONSULTANT & PARTNER
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 -
Any progress with this. It has been on the ask list for almost 2 years. Very upsetting that this is not a feature yet.
0 -
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
0
