Help with Arrayformula If is Blank

[Ragotem]

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”))"

Thanks everyone !

[Rosewebstudio]

Hi @Ragotem

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

If → Then → Else Column

[Ragotem]

Thanks!!!

I need it to make a Row Owner column…

[V88]

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.

[ThinhDinh]

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

[gvalero]

Try using…

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

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

Saludos

[Ragotem]

Same error

[gvalero]

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”))

Revisa de nuevo!

[Ragotem]

Finally!!!

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

Thanks every body!!!