Formula for Scoring a Project (with Weights)
Hello!
I am looking to give my projects a score, based on 8 different options. In one column I have a multiselect to pick from those 8 criteria and then I want to have a column to give a numerical score for the project based on how many of the 8 criteria are selected. One problem is I want to make two of the criteria worth 3 points while are others are 1. I am having trouble with the weighting piece of it. Anyone have experience with this?
Best Answer

Thanks for the guidance! I was actually able to solve it with a coworker's advice of using the following...
=SUM(COUNTM([Scoring Criteria]@row) + IF(CONTAINS("aligns to OKR", [Scoring Criteria]@row), 2, 0) + IF(CONTAINS("student success", [Scoring Criteria]@row), 2, 0))
Have a great day!
Answers

You'll want to check out the HAS() function. Try something like...
= if(has(DROPDOWN@row,"Criteria 1"),1,0) + if(has(DROPDOWN@row,"Criteria 2"),1,0) + ..... + if(has(DROPDOWN@row,"Criteria 8"),1,0)
Swap out the bolded "1" for whatever weight each needs.
If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!

Thanks for the guidance! I was actually able to solve it with a coworker's advice of using the following...
=SUM(COUNTM([Scoring Criteria]@row) + IF(CONTAINS("aligns to OKR", [Scoring Criteria]@row), 2, 0) + IF(CONTAINS("student success", [Scoring Criteria]@row), 2, 0))
Have a great day!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!