Display images in google sheet cell by using file urls from google drive -2021

[@efraimbasilio]

=image(SUBSTITUTE(TRIM(J11),"open?id","uc?export=download&id")) - This is the correct formula ...
But please don't forget to share the image folder for the images to be loaded in the google sheet.
Go to you google drive folder and in the image folder click ---> Share

[@comsortecomvoce4865]

Brabo, tamo junto.

[@JonalynOgalesco]

Thank u sir. :)

[@MatthewScott-xg1ho]

This is a really good demonstration, but it would be helpful if you could also link the sheet on your website so people can see the finished version.

[@RajeshSharma-gu7do]

Hi! Nicely explained everything but I am facing the same issue as Donna Johnson. URL converted into thumbnail but it doesn't appear in the image cell. Please help. Thanks.

[@kerinahrgang3087]

After several times of trying with no photo appearing, I looked at the formula in the photo frame area. I changed the formula to
=image(SUBSTITUTE(TRIM(J11),"thumbnail?id","uc?export=download&id"))
since there was no "open?id" in cell J11. The photo appeared!

[@jraanvaini]

Even after sharing the folder i am not getting the photo

[@anveshanaclothing]

Tried using this formula. Still no response yet. Can you help me out

[@itsallraphq]

it works!

[@mohdshahjahan8054]

would you pla give a funtion code for editing or modifing searched data

[@saurabhyadav5529]

Great video 👍👍
Create more adavance videos like this...

[@unuskpm]

Hi Tek Rayz, Image not showing even after applied formulas in Image Sheet for URL Edit. please help

[@saadelias3992]

Fixed it!!!!
Hi, I did everything exactly, corrected this formula as well '=image(SUBSTITUTE(TRIM(J11),"open?id","uc?export=download&id"))'. Even though it is not showing the image....... What could be the reason???? it is not showing any errors as well. Please someone help.

[@alexanderseguraaltamira6461]

Does anybody has an idea what the image is not shown in the range, eventhough I am using the correct formulas? Do we have to configure something in the J3:J9 range?

[@chatchavaditssimaraks3751]

hi sir - when i paste the image formula into cell .. the formula become "=image(SUBSTITUTE(TRIM(J11),"open?id",üc?export=download&id"))"))" .. there are extra "))" which i cannot remove

[@chatchavaditssimaraks3751]

found the error .. the given formula missing " in front of uc.

[@jedsantos9773]

This helped me! Thank you so much! I’m also looking for a way to easily print a Google Sheet range to PDF. Maybe you have a solution? Thanks again!

[@jorgehuttherrera5276]

In order to make it work and display the image you have to share the folder that contains the images

[@JonalynOgalesco]

Thank you sir'! finally it works! :)

[@jhunplerazon0306]

hi sir, i don't know why the formula =image(SUBSTITUTE(TRIM(J11),"open?id",üc?export=download&id")) didn't work for me huhu

[@tekrayz5602]

Ensure to convert the url format by applying formula in image sheet as well. Check 7:20

[@DailyChannel]

Thank you so much. I did it.

[@bobijuliansah4412]

This is awesome!, thank you so much !

[@wajahat449]

I am getting this error, how to i can fix this ?
Exception: Unexpected error while getting the method or property getFolderById on object DriveApp.

[@comsortecomvoce4865]

super like bro!!

[@PARMODKUMAR-bd3pc]

Image not seen in J3 to J9