I would like to use the email string and cut of the domain portion - convert jelena.dolic@xxxxx.com into
jelena.dolic
Please help
Unfortunately Glide computed columns do not support sting manipulation functions, so there is no easy way to do that within Glide. The simplest way to achieve that at the moment would be with a GSheet function.
1 Like
Thanks, sound great, but there I would have to figure out how to force a calculation on a newly created line. Would you be able to suggest?
Thanks
=arrayformula(if(A2:A="",,left(A2:A,find("@",A2:A)-1)))
change A2:A if email is not in first column
1 Like
Thanks 