Hi all, I’m trying to solve an issue and I wonder if any more experienced users could help. Our guests fill in their full name and this populates the item column on our Monday board. I am sending emails automatically when statuses change that I would like to keep very informal. So I only want to send to first name.
Example Item may be:" John Paul Smith" and I want to collect only “John” in another column. I can do this by using “LEFT({Name}, SEARCH(” “, {Name})-1)” in formula column–(Thank you Monday Man), but that can’t be used in Gmail automations.
I tried using General Castor as a workaround, however, it’s just outputting “Name?”
Any suggestions would be much appreciated.
Thank you