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]

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

IN() - AppSheet Help

[Suvrutt_Gurjar]

• Please try

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

[Uk]

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

[Uk]

thanks @Suvrutt_Gurjar I did it