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] =...

I want to create Audit form that have 4 Audit Classification each Audit Classification have 5 Audit condition. each Audit condition have 3 choice of answer. Auditor have to select all 4 of Audit Classification 20 Audit condition with 1 answer but whe...