Count value of a column type Enumlist

[Uk]

Hallo Everybody,

I need a solution of my problem.

I have a table called DataBook,

it consists of two columns, Books and Score 

Type of BOOKS column is set as Enumlist, which has value like this:
Arts has a value 1
Science has value 1
Math has a value 2
Social has a value 3

And the Score is Number Type,

When I check list them all it will appear 7 in SCORE Column, 

I tried this formula but doesn't work

Score
IFS([Books] = "arts" , 1)
+
IFS( [book] = "science" , 1)
+
IFS( [book] = "math" , 2)
+
IFS( [book] = "social" , 3)

I need your help for this formula, thank you friends

[Steve · Accepted solution]

IFS(IN("arts", [Books]) , 1)
+
IFS( IN("science", [book]) , 1)
+
IFS( IN("math", [book]) , 2)
+
IFS( IN("social", [book]) , 3)

IN() - AppSheet Help

[Steve · Accepted solution]

IFS(IN("arts", [Books]) , 1)
+
IFS( IN("science", [book]) , 1)
+
IFS( IN("math", [book]) , 2)
+
IFS( IN("social", [book]) , 3)

IN() - AppSheet Help

[Uk]

Thanks @Steve  it works 😊 , I always confused when using IN 😅

[Suvrutt_Gurjar · Accepted solution]

• Please try

IFS(CONTAINS([Books] ,   "arts") , 1)
+
IFS( CONTAINS([book] ,  "science" ), 1)
+
IFS( CONTAINS([book] ,"math") , 2)
+
IFS( CONTAINS([book] ,  "social") , 3)

[Uk]

thanks @Suvrutt_Gurjar  I did it 😊