I want to match the value of enum list and then return the number that I want to the Comment column. So I use the
IFS(
([K-Planet] =INDEX(SORT(การตอบแบบฟอร์ม 1[K-Planet]),1)),5
,([K-Planet] =INDEX(SORT(การตอบแบบฟอร์ม 1[K-Planet]),2)),3
,([K-Planet] =INDEX(SORT(การตอบแบบฟอร์ม 1[K-Planet]),3)),0
)
My enum column contain value like this
But when i run the code above they didn’t index to 1 , 2 , 3 properly.
So i check what the list that by use
SELECT(การตอบแบบฟอร์ม 1[K-Planet],TRUE)
and the result I got is look like this
The value in enum list is not list the way i think.
Can anyone tell me what should i do to get the score(the return number) for each index.
User | Count |
---|---|
21 | |
15 | |
4 | |
3 | |
3 |