Working with Pictures and Index/Match Formula

Jason Close

Hi,

I am building a product basket / configurator where I have a printer engine and I want to add accessories using checkboxes. This part is easy, no worries there.

I have a sheet with all the device info I want to use, this is referenced with a cell link, and to start the configuration I select a SKU from the list using the linked cell. Once this SKU populates on the main sheet, Index/Match formulas bring in all the rest of the information. This is also supposed to bring an image of the base printer engine that is populating a cell on the source sheet, using the Index/Match formula. The issue is that it only transfers the image file name and does not show the actual image.

Further to this I want to be able to make it so that image changes when adding accessories so that the image is accurate to the configuration. (extra trays & stands added on the sheet will change the image to the matching configuration using multiple images and changing the reference depending on selection). I haven't even started on this part yet though as I am not sure I can work with the images the way I want to.

Is this possible?

Andrée Starå

Hi @Jason Close

I hope you're well and safe!

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• There might be a 3rd-party service/integration that could help
• Smartsheet API

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!