# Help with Arrayformula If is Blank

**URL:** <https://community.glideapps.com/t/help-with-arrayformula-if-is-blank/20129>\
**Category:** Ask for Help\
**Created:** [December 21, 2020, 9:08am UTC](https://community.glideapps.com/t/help-with-arrayformula-if-is-blank/20129 "2020-12-21T09:08:24Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ragotem](https://avatars.discourse-cdn.com/v4/letter/r/7c8e57/32.png) [@Ragotem](https://community.glideapps.com/u/Ragotem)\
**Post date:** [December 21, 2020, 9:08am UTC](https://community.glideapps.com/t/help-with-arrayformula-if-is-blank/20129/1 "2020-12-21T09:08:24Z")

</div>

Good morning from Spain,

I need help with Arrayformula, I do no know what I am doing wrong with “=ARRAYFORMULA(if(ISBLANK(A2:A), “”,"marie@glideapps.com”))"

![Captura4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/16c7879fc7716cd7aa88a835013a790c75542b2c.jpeg)

Thanks everyone !

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [December 21, 2020, 9:14am UTC](https://community.glideapps.com/t/help-with-arrayformula-if-is-blank/20129/2 "2020-12-21T09:14:30Z")

</div>

Hi @Ragotem

I wonder if you could you use a _if-then-else_ inside of glide instead?

> **[If → Then → Else Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/if-then-else)**
>
> Compute different values depending on other data in your sheet

---

<div class="post-metadata">

**Author:** ![Ragotem](https://avatars.discourse-cdn.com/v4/letter/r/7c8e57/32.png) [@Ragotem](https://community.glideapps.com/u/Ragotem)\
**Post date:** [December 21, 2020, 9:24am UTC](https://community.glideapps.com/t/help-with-arrayformula-if-is-blank/20129/3 "2020-12-21T09:24:00Z")

</div>

Thanks!!!

I need it to make a Row Owner column…

---

<div class="post-metadata">

**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\
**Post date:** [December 21, 2020, 9:28am UTC](https://community.glideapps.com/t/help-with-arrayformula-if-is-blank/20129/4 "2020-12-21T09:28:36Z")

</div>

Hi @Ragotem. The issue lies with your “”. They are the wrong sort of quotes I think (maybe smart quotes have been inserted). Replace with standard quotes like these “” and it’ll be fine.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 21, 2020, 10:03am UTC](https://community.glideapps.com/t/help-with-arrayformula-if-is-blank/20129/5 "2020-12-21T10:03:37Z")

</div>

Possibly this answer is true. I see no other reasons in the syntax to make it not work.

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [December 21, 2020, 10:09am UTC](https://community.glideapps.com/t/help-with-arrayformula-if-is-blank/20129/6 "2020-12-21T10:09:20Z")

</div>

Try using…

=ARRAYFORMULA(if(ISBLANK(A2:A); “”; "[Marie@glideapps.com](mailto:Marie@glideapps.com)”))

The difference is the ‘;’ as separator in most of Spanish settings.

Saludos

---

<div class="post-metadata">

**Author:** ![Ragotem](https://avatars.discourse-cdn.com/v4/letter/r/7c8e57/32.png) [@Ragotem](https://community.glideapps.com/u/Ragotem)\
**Post date:** [December 21, 2020, 10:26am UTC](https://community.glideapps.com/t/help-with-arrayformula-if-is-blank/20129/7 "2020-12-21T10:26:22Z")

</div>

Same error 🤦‍♂️

![Captura](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6acd507a3cbe2fd87216cddb21deb5b44f7c569a.jpeg)

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [December 21, 2020, 10:30am UTC](https://community.glideapps.com/t/help-with-arrayformula-if-is-blank/20129/8 "2020-12-21T10:30:10Z")

</div>

Jeje… no te rindas!!

Tienes ahora un error de sintaxis al final de la fórmula, las comillas dobles (“) no deben ir allí.

> =ARRAYFORMULA(if(ISBLANK(A2:A); “”; "[Marie@glideapps.com](mailto:Marie@glideapps.com)”))

Revisa de nuevo!

---

<div class="post-metadata">

**Author:** ![Ragotem](https://avatars.discourse-cdn.com/v4/letter/r/7c8e57/32.png) [@Ragotem](https://community.glideapps.com/u/Ragotem)\
**Post date:** [December 21, 2020, 10:42am UTC](https://community.glideapps.com/t/help-with-arrayformula-if-is-blank/20129/9 "2020-12-21T10:42:39Z")

</div>

Finally!!! 🥳

Changin lenguage of google sheets to “english” and working now, very strange…

Thanks every body!!! ![Captura](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2f496cadc75817ad066d3caf9f16f5fb0a01601d.jpeg)