Google Sheets returning image links as images

Question

So I currently have a sheet with links to photos. When I hover over these photos they appear as they are in my Google Drive.

The problem is, that I am trying to figure out a way to pull the images and return them to a cell.

Is there any way to do this?

As you can see, I am trying to figure out a way to pull these images and return the actual image to the desired cell.

Hi, welcome to WebApps. When you say "links to photos", do you mean that you have used the HYPERLINK function? — Tedinoz, Commented Sep 19, 2022 at 12:50
Have you read How find and use direct link to image uploaded in Google Drive from StackOverflow. This is exactly what you need. — Tedinoz, Commented Sep 19, 2022 at 12:51

doubleunary · Accepted Answer · 2022-09-19 13:13:31Z

0

Try getting the link addresses with the RichTextLinks custom function, and then use the image() function in the next column to show the images.

answered Sep 19, 2022 at 13:13

doubleunary

15.7k9 gold badges23 silver badges59 bronze badges

Add a comment |

1 Answer 1