how to fix ?
my formula =hyperlink(E2,IMAGE("https://docs.google.com/uc?export=download&id="&right(E2,33)))
CodePudding user response：
When I saw your sample Spreadsheet, the value of "E2" is https://drive.google.com/file/d/{fileId}/view. In this case, right(E2,33) is {fileId}/view. I thought that this might be the reason for your issue. In order to show the image, how about the following modification?
Modified formula:
=HYPERLINK(E2,IMAGE("https://docs.google.com/uc?export=download&id="&INDEX(SPLIT(E2,"/"),0,5)))
and
=HYPERLINK(E2,IMAGE("https://docs.google.com/uc?export=download&id="®EXEXTRACT(E2,"d\/(. )\/")))
Note:
- In this case, the image is required to be publicly shared. Please be careful about this.