Using formulas with images in cells
I have a sheet that has a column with an image in each cell. In another sheet I want to do an Index(Match()) and find the image and pull it into my new sheet. I get the alt text to return. Does anyone know how to get the image to appear? Different formula? Different column type?
Best Answers
-
This isn't possible, forget about it and move on with your day.
-
Hey @Steven Sawyer
As @BullandKhmer mentioned, it isn't currently possible to pull an image in a cell from one sheet into another by using a formula. You could Copy a row which will copy the image, or you could use a Report to display content from two separate sheets together if that helps. Another option could be to house the image in another location (such as Google Drive) and use the Index(match to pull through the URL to that location instead.
Can you explain a bit more about your process? We may be able to come up with a different set-up or solution to achieve your end-goal.
Please also feel free to submit your formula feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
This isn't possible, forget about it and move on with your day.
-
Hey @Steven Sawyer
As @BullandKhmer mentioned, it isn't currently possible to pull an image in a cell from one sheet into another by using a formula. You could Copy a row which will copy the image, or you could use a Report to display content from two separate sheets together if that helps. Another option could be to house the image in another location (such as Google Drive) and use the Index(match to pull through the URL to that location instead.
Can you explain a bit more about your process? We may be able to come up with a different set-up or solution to achieve your end-goal.
Please also feel free to submit your formula feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@BullandKhmer this is both absolutely correct, it would seem, and also completely unhelpful. But thanks for the laugh.
-
@Genevieve P. thanks for the workaround ideas. This is a one off report request. We normally get image cells linked with control center and that meets our needs. I’m going to try the copy row idea. I think that’s the winner in this case. And I’ll submit the feature request… we really should be able to get images with a formula. Thanks.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!