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)

Find more posts tagged with

Formulas

functionality

Cell linking

Enhancement Request

Accepted answers

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!

All comments

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

Tom Murphy

Any progress with this. It has been on the ask list for almost 2 years. Very upsetting that this is not a feature yet.

Julia Bennfors

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.