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!

It worked! Thank you @NickStaffordPM !
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!