Solved: SPLIT function with EnumList doesn't work. - Page 2

maxus68 · 03-20-2025 03:37 AM

Hello everyone,
I can't use the SPLIT function with a column of type EnumList.
I take data from an Excel table in string format (a,b,c), in the AppSheet data I created a virtual column of type EnumList and in the app formula, I inserted the following function: SPLIT([primo],",").
[Primo] is the column with data in string format (a,b,c).
When I open the Form view, I don't see the virtual column, even though it is correctly added to the list of columns.

Thank you for the help

scott192

Can I ask why you want to add a VC column with the split formula onto your form? The normal column that is set to be an ENUMLIST of TEXT will work perfectly fine to display buttons, dropdowns or stacks (I noticed you left it set to Auto in your screenshot). I can also see that you did not set the Item Separator in your screenshot. You should examine your excel column and check whether the item separator is a standard comma or if it is a space comma space.

View solution in original post