I have a table of checkboxes (rows 1-3 and columns a-d) and I'm trying to make a layered image from each column - meaning that if for example, I check A1, B2, C3, and D1, four images will appear on top of each other in one specific cell. (each combination of a row and column has a different image)

I already managed to make it so that if I check a box, an image will appear using one long IFS formula. The problem is that it only shows the checked image that is the highest on the list in the ifs formula, not any other. Is there any way to layer images? In my case, there will be only one image per column, multiple per row.

edit: I want multiple images in one cell, using their transparency

1 Answer 1


Your might want to clarify if by 'layering' you are referring to distributing multiple images in a cell (i.e. in a grid) or overlaying them (i.e. with transparency) as it's not clear to me. In any case if you are using the IMAGE function to attempt this by pulling images from a website then I don't think what you want to do is directly possible in the way you would like as:

  • IMAGE only allows for one image per cell
  • IFS (and IF as well) perform 'short-circuit evaluation', i.e. they stop at the first TRUE encountered

You might be able to achieve what you want with Apps Script, but that's beyond my capabilities.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.