IMAGE

Inserts an image in a cell by providing an URL.

Parameter List

Syntax
IMAGE(url
[mode]
)
url

The url of the image. Including the protocol (eg. http://)

[optional] mode

The image display mode.

  • 1 - original aspect ratio (default): resizes the image to fit inside the cell, maintaining aspect ratio.

  • 2 - squared: crop to the center creating a mask squared.

  • 3 - rounded: crop to the center creating a mask rounded.

Examples

IMAGE("https://logo.clearbit.com/rows.com",3) returns the image in rounded display mode.