# obtain score based on dropdown list values

Options
✭✭

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.

• ✭✭✭✭✭
Options

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!

Thanks!

Nick Stafford

• ✭✭
Options

It worked! Thank you @NickStaffordPM !

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!