obtain score based on dropdown list values
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.
Answers

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

It worked! Thank you @NickStaffordPM !
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 123 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!