I’m tring to use Appsheets SPLIT() function like Googles. I want to split a line of text into 2 column with the sperator being tilde. i.e.
Column A = 123~ABC
Column B = 123
Column C = ABC
Main problem is as soon as it splits, it creates a 2 item list, which has to be in a virutal column.
Whereas =SPLIT(F27,"~") works as expected in Google Sheets
Anyone know how to achieve the above in Appsheet? To keep it simple, the string will only ever be 2 items sperated by a tilde
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |