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
Solved! Go to Solution.
IFS(IN("arts", [Books]) , 1)
+
IFS( IN("science", [book]) , 1)
+
IFS( IN("math", [book]) , 2)
+
IFS( IN("social", [book]) , 3)
IFS(CONTAINS([Books] , "arts") , 1)
+
IFS( CONTAINS([book] , "science" ), 1)
+
IFS( CONTAINS([book] ,"math") , 2)
+
IFS( CONTAINS([book] , "social") , 3)
IFS(IN("arts", [Books]) , 1)
+
IFS( IN("science", [book]) , 1)
+
IFS( IN("math", [book]) , 2)
+
IFS( IN("social", [book]) , 3)
Thanks @Steve it works 😊 , I always confused when using IN 😅
IFS(CONTAINS([Books] , "arts") , 1)
+
IFS( CONTAINS([book] , "science" ), 1)
+
IFS( CONTAINS([book] ,"math") , 2)
+
IFS( CONTAINS([book] , "social") , 3)
thanks @Suvrutt_Gurjar I did it 😊
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |