# Formula **URL:** \ **Category:** Ask for Help\ **Created:** [October 4, 2019, 10:24pm UTC](https://community.glideapps.com/t/formula/898 "2019-10-04T22:24:02Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 4, 2019, 10:24pm UTC](https://community.glideapps.com/t/formula/898/1 "2019-10-04T22:24:02Z")
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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/25bdcde56a26be0390a4b3d34eb000c1a6f7c4d2.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 4, 2019, 10:34pm UTC](https://community.glideapps.com/t/formula/898/2 "2019-10-04T22:34:22Z")
> [@Arrayformula](https://community.glideapps.com/t/arrayformula/897/2): > > 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. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 5, 2019, 1:19am UTC](https://community.glideapps.com/t/formula/898/3 "2019-10-05T01:19:42Z")
@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. ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [October 5, 2019, 4:06am UTC](https://community.glideapps.com/t/formula/898/4 "2019-10-05T04:06:20Z")
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”)) ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 5, 2019, 2:43pm UTC](https://community.glideapps.com/t/formula/898/5 "2019-10-05T14:43:15Z")
Megann has a typo in her formula: ```auto =ARRAYFORMULA(IF(ISBLANK(A2:A), "", "your image url here")) ``` ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [October 5, 2019, 2:54pm UTC](https://community.glideapps.com/t/formula/898/6 "2019-10-05T14:54:51Z")
It will work without the quotation marks! 🤓 ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [October 5, 2019, 2:55pm UTC](https://community.glideapps.com/t/formula/898/7 "2019-10-05T14:55:25Z")
However there should be double commas!! ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [October 5, 2019, 2:58pm UTC](https://community.glideapps.com/t/formula/898/8 "2019-10-05T14:58:27Z")
Here’s an example: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/4db5789744cb8a69f220bbf1f4ed81e9dc9afea5.jpeg) ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 5, 2019, 4:10pm UTC](https://community.glideapps.com/t/formula/898/9 "2019-10-05T16:10:37Z")
> [@George\_B](#): > > =ARRAYFORMULA(IF(ISBLANK($A$2:$A),“”,“your image url here”)) o meu esta dando e seguinte erro alguem pode me ajudar ![ccccc](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/4ecb0c10dfdee6ea7dbf17b751dfbb490baa4b65.png) ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 5, 2019, 4:52pm UTC](https://community.glideapps.com/t/formula/898/10 "2019-10-05T16:52:35Z")
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 you left out a comma (or semicolon in your case), but as @MegannLock points out, it will work without them. Eu me livraria dos $ e substituiria a vírgula por ponto e vírgula; Dependendo do país, a planilha está definida para você usar vírgula ou ponto e vírgula para separar parâmetros em fórmulas. Eu prefiro mostrar explicitamente a string vazia “”, para mim ela fica um pouco mais clara e é mais fácil ver se você deixou uma vírgula (ou ponto e vírgula no seu caso), mas como o @MegannLock aponta, funcionará sem elas. ```auto =ARRAYFORMULA(IF(ISBLANK(A2:A); ""; "your image url here")) ``` ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 5, 2019, 5:02pm UTC](https://community.glideapps.com/t/formula/898/11 "2019-10-05T17:02:37Z")
> [@George\_B](#): > > =ARRAYFORMULA(IF(ISBLANK(A2:A); “”; “your image url here”)) your formula worked right thank you very much for your help