Enumlist - Sheet with multiple values per cell

[Rory_Forde]

Hello all…

First I want to thank this community for the prompt and helpful responses that I have received to previous questions.

I have a google sheet that I want to create an app for. The main problem with this sheet is that some of the columns have multiple values per cell - they have been populated by a multi-select form and all of the selected responses have been inserted into a single row/column. From a traditional DB perspective this doesn’t work too well. These values are currently separated by a period (.).

As trying to rework the structure of this google sheet would be a particularly tricky exercise I want to see if there are any options to work with the data in Appsheet using the current structure. I am aware of the ENUMLIST data type in Appsheet which would appear to be compatible to the data in the sheet. The question is: Is there any way for Appsheet to recognise the multiple values in these cells? For example if they were separated a a semi-colon ( or a comma (,) would Appsheet recognise these multiple values.

Any suggestions would be gratefully accepted. If you want to tell me to restructure the sheet I am looking at that as a (very) last resort.

Thanks,

RoryF