Hello!
I want to know if there is a way I can separate and show Names separated by a comma; I have a spreadsheet where I have a column with some names, for example, "Diego Sanchez, Brian Smith, Michael Douglas" I need to separate those names by the comma and then show only the first one when grouped on a view.
Thanks for your time and help!
Solved! Go to Solution.
INDEX( SPLIT( [names] , "," ) , 1 )
https://help.appsheet.com/en/articles/2357278-index
https://help.appsheet.com/en/articles/2357340-split
INDEX( SPLIT( [names] , "," ) , 1 )
https://help.appsheet.com/en/articles/2357278-index
https://help.appsheet.com/en/articles/2357340-split
Thank you very much!! It worked like a charm!!
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |