Take value of each column of Google Sheet row and apply formula to it

user_1778367 0
Viewed 25

Imagine I have a column H in which each row consists of a unique image URL which gets updated occasionally programatically.

Is there a way to apply a formula to each row containing the link? I wanna wrap =IMAGE("link_to_img.jpg") around it, but it needs to be dynamic so that the link can be updated dynamically.

google-sheets-formula google-sheets
1 Answers

You would need a script for that.
Still. Since you tagged it under google-sheets-formula you can use a helper column and refer to the cell of the link.

=INDEX(IMAGE(H31:H35))

(Do adjust the formula according to your ranges)

enter image description here

user_15277800
Related