VLOOKUP to another sheet using images
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?
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.
-
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.
-
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
-
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 EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
-
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!
-
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.
-
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-requestsHave a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hey Andree - any update on this? Sounds like this would be useful for everyone!
-
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 EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Still nothing on this? Come on...
-
Right! Nothing still? This would be a super useful funtion!
-
We would appreciate this feature as well
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!