GOOD EVENING IF SOMEONE CAN HELP ME WANTED ONE = ARRAYFORMULA TO INSERT A LINK OF AN IMAGE FOR WHEN A NEW SECTOR IS INSERTED BELOW THIS FORM ADD THIS IMAGE TO THE NEW SECTOR [SSSSS]

[image] Arrayformula Try this in column C2: =arrayformula(IF(LEN(A2:A) = 0, “”, “image url”)) You may need to use “;” instead of “,” depending on the country you live in.

@gelson If you do use the arrayformula make sure to delete all the empty rows on your sheet. If you don’t when Glide adds a record it will be appended to the last row in the sheet and you will be confused as to where it is.

Hey! Here’s another formula for some fun variety! You’d put this formula into C2: =arrayformula(IF(ISBLANK($A$2:$A),“your image url here”))

Megann has a typo in her formula: =ARRAYFORMULA(IF(ISBLANK(A2:A), "", "your image url here"))

It will work without the quotation marks! :nerd_face:

However there should be double commas!!

[image] George_B: =ARRAYFORMULA(IF(ISBLANK($A$2:$A),“”,“your image url here”)) o meu esta dando e seguinte erro alguem pode me ajudar [ccccc]

I would get rid of the $'s, and replace the comma’s with semicolons ; Depending on the country the spreadsheet is set to you use either comma’s or semicolons to separate parameters in formulas. I prefer to explicitly show the empty string “”, for me it reads a bit clearer and is easier to see if yo…

[image] George_B: =ARRAYFORMULA(IF(ISBLANK(A2:A); “”; “your image url here”)) your formula worked right thank you very much for your help

Formula

Ask for Help

Jeff_Hager October 4, 2019, 10:34pm 2

Topic		Replies	Views
Arrayformula Ask for Help	1	465	October 4, 2019
Help with Arrayformula If is Blank Ask for Help	8	498	December 21, 2020
Issue ARRAYFORMULA & new item Ask for Help	8	374	May 4, 2021
Why are so many lines inserted? Ask for Help	1	598	January 3, 2020
Using ARRAYFORMULA()'s in Row 1 of your Spreadsheet Project Showcase	6	4587	August 8, 2020

Formula

Related topics