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 !
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 !
Hi @Ragotem
I wonder if you could you use a if-then-else inside of glide instead?
Thanks!!!
I need it to make a Row Owner column…
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.
Possibly this answer is true. I see no other reasons in the syntax to make it not work.
Try using…
=ARRAYFORMULA(if(ISBLANK(A2:A); “”; "Marie@glideapps.com”))
The difference is the ‘;’ as separator in most of Spanish settings.
Saludos
Same error
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!
Finally!!!
Changin lenguage of google sheets to “english” and working now, very strange…
Thanks every body!!!