VLOOKUP to another sheet using images

02/12/18 Edited 12/09/19

I love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the image.

This would be so useful to actually pull in the image itself as a cross-reference. Is this functionality on the radar for a future release? 

Previous1

Comments

  • Thanks Caroline. This isn't on the near-term roadmap, but we'd love to know more about how you would want to use this.

  • krista.galyenkrista.galyen ✭✭✭✭✭

    I was trying to do this today. We are tracking individuals projects as well as clients. I want to pair the logos and profile pictures with names across projects, mainly because (1) it's more visually appealing, and (2) people are much more visual than they are able to read lots of text when getting an idea of who, where, and to what degree. Having vlookup with images allows us to pair profile images, logos, and other visual statuses that we store in another page in order to help users to be more efficient and get more out of the sheets. 

     

  • Chris McKayChris McKay ✭✭✭✭✭

    Hi Daniel,

    Any update on this? Seems like a no-brainer that using VLOOKUP or Cross-Sheet Reference to a cell containing an image should pull the image, not the name. As far as how it could be used, I can give you 2 straight off the bat:

    • Dynamically pulling out a different image based on a cell value (e.g. company logo)
    • Custom status symbols (instead of RYG balls)

    If I put my mind to it, I could come up with many more.

    Honestly, who thought that pulling the file name out was a good idea? A quick survey of your customers (perhaps before designing future functionality) would no doubt show that pretty much everybody wants to see an image in the new cell not the filename. We have hundreds of Smartsheet users at work and so far nobody has seemed interested in seeing filenames.

  • Hello 

    I'm also interested in this topic. i need to pull employee personal pictures on different applications that they fill through forms. So this feature will be very helfull for my company

    Best 

  • Is there any workaround for this? I have users insert images using the mobile app into a given cell, and then I need to populate that image in other sheets for review and other functionality... 

    Thank you

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Joshua,

    Unfortunately, not that I know.

    Please submit an Enhancement Request when you have a moment.

    I hope this helps you!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    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.

  • I've submitted an enhancement request for this functionality. Would be useful for our construction company to populate item Schedules (e.g. Schedules of fixtures and fittings etc) and would think that any product based business would benefit from this functionality. 

     

  • edited 12/21/18

    Hello. I am rallying to have Smartsheets work on having the VLOOKUP command so allow you to import an image from one sheet into another. Currently it only imports the image name which is not useful.

    If this would help your workflow please submit a Product Enhancement Request via this link. The more requests, the higher on the to-do list this feature will become. 

    UTILISATION: I have one Smartsheet which is my 'inventory' list. I have another 'order' sheet on which I use VLOOKUP command so that when I enter the product code / SKU the rest of the product information will auto-fill. Once of my columns of information is an image and it would be useful for the image to also import. I am in the constrcution industry and we use this for our fixture, materials, appliance schedules. 

    I can see this functionality aiding a wide range of businesses - please let your voice be heard if this would help Smartsheets become more useful for your business!

    Thanks!

  • Michael HalveyMichael Halvey ✭✭✭✭✭

    Would love to have this feature! Using VLOOKUP to look up a image in a cell would be GREAT! We use a columns with images as references and would be great to have all the product name on another sheet an have their respected images in the column next to it. Then just use a VLOOKUP function to generate the image on the required main sheet.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi everyone,

    Please submit an Enhancement Request when you have a moment to have your vote added

    A New Way to Submit Your Feature Requests

    To make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.

    Original Post: https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests

    Have a fantastic day!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    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.

  • Hey Andree - any update on this? Sounds like this would be useful for everyone!

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Meagan Harte

    Unfortunately, I don’t have any news.

    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.

  • Still nothing on this? Come on...

  • Right! Nothing still? This would be a super useful funtion!

  • We would appreciate this feature as well

Sign In or Register to comment.