I have boolean data that is separated by commas that I’d like to split and output into separate google sheet columns. When I use the formatter text split, it keeps each split in one line and I can’t break them up.
Here’s my formatter setup. I just want the first value
After testing, it lists each option even though I set it to only give the first option.
When I go to output to google sheets, I don’t have a way to only select one of the options. It looks like the formatter didn’t do anything.
It gives the same thing when I try to separate as line-items or separate fields instead of trying to only choose the first entry in the split. How do I get the formatter to split around the comma? I’m pulling this from an event registration platform called Mobilize in case that’s helpful.
