How do each enumlist value is an column in google sheet?

[Dũng]

Hello everyone,

After we enter the value on the appsheet in the enumlist field.

The googlesheet will receive a number of values ​​separated by commas ",". I want each value to be a column like Google Form. Please help.

[Lynn]

Hi @Dũng 

Have you tried using SPLIT ?

[Dũng]

Do you mean to use directly the SPLIT function contained in the appsheet?

[TeeSee1]

An ENUMLIST column stores multiple values in one column. Since you cannot create columns dynamically, you need to initially create the max number of columns you would need and set each one as ENUM rather than ENUMLIST.