Link to home
Create AccountLog in
Avatar of gregholl
greghollFlag for Ecuador

asked on

troubles with images in a Google Spreadsheet

Hey. Please check the this screenshot:

User generated image
Each row is of a different product that we sell, with the corresponding data. I am trying to also include a picture of each of the products.

So far, I have the picture URL in the product, which is great. (Column D)

I would also like to have the actual picture of the product showing in there too.

This is what I did to add the three pictures that you see in the screenshot already:

1: Copy the URL
2: Click the cell where the image should appear
3: Select the menu: Insert > Image > By URL
4: Paste the URL and click "select"

See the screenshot:

User generated image
This is all fine and dandy. EXCEPT for... when I resort the list. D'oh!!! The pictures don't move! The list resorts, but those 3 sample pictures I've done stay on the top. [sigh]

Is there some way around this? Or something else I should do?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of gregholl
gregholl
Flag of Ecuador image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of gregholl

ASKER

I solved it myself. I simply used the =IMAGE() function. Worked like a CHARM.