I have an application that uses an enum list column. I have inserted a data validation that generates the list options from another table. I would like to load data into the table directly through the google spreadsheet, but I am not able to fill the enum list column properly in the spreadsheet. I thought it was just entering the data comma separated, but the data validation indicates it is invalid.
How can I do this? I need to do this because I already have a dataset to use in the app.
User | Count |
---|---|
26 | |
25 | |
24 | |
22 | |
20 |