I am attempting to automate my project list by scoring each project based on calculations in another sheet.
I would like to create a "Project Score" based on drop-downs in my project sheet. Sum=Complexity*weight + cost*weight + impact*weight +resources*weight + value*weight. The values of each category and weight are in another sheet. (pics attached for both sheets to reference).
Any assistance would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!