The list from Enum value is weird

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.

0 7 273
7 REPLIES 7
Top Labels in this Space