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.