E
E
Evgenia Satonina2020-04-24 16:19:31
Google Sheets
Evgenia Satonina, 2020-04-24 16:19:31

How to transfer an image from one sheet to another so that people who have access via the link can see them?

Hello.
I have two sheets in the table
. One contains data about models, the other contains data about orders.
That is, on one sheet, I enter the name of the model in the cell, and the data for this model is automatically filled in the table (which are loaded from another sheet). The formula looks like this =iferror(QUERY(Sheet2!$A:$K,"select K where A like '"&$C3&"'",0),"")
Images should also be loaded. Here is the formula =image(iferror(QUERY(Sheet2!$A:$M,"select J where A like '"&$C3&"'",0),"")) And they are loaded (I see them). But when I give access by link, other people see everything except images. Where there should be pictures, they see empty cells.
By the way, the images are taken from another sheet, where they are written in the cells with links to these pictures on the Internet. If I insert there not links, but the images themselves, then they are not loaded on another sheet.

https://docs.google.com/spreadsheets/d/1rCuP--Rqyu...

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question