obtain score based on dropdown list values

MarieM

Hello - I'd like to obtain a score based on weighted items from a dropdown list. For example, "Apple" = +1, "Orange" = -1, "Grape" = +1. So if I have Apple and orange I get 0, but apple and grape will produce 2. Can someone help me with a formula, please?

thank you.

NickStaffordPM

Okay so

I am assuming you are multi selecting Apple and Grape in one column in your example above, correct me if wrong.

Try this out..

=if(CONTAINS("Apple",[Selection Column]@row),+1,0)

+ if(CONTAINS("Orange",[Selection Column]@row),-1,0)

+ if(CONTAINS("Grape",[Selection Column]@row),+1,0)

Basically make a formula for every fruit you could select to add the value if the orginal column contains it, or add 0 to the formula if not.

I have never done this myself but in theory should work.. Let me know!

MarieM

It worked! Thank you @NickStaffordPM !