Project Score Assessment Classification

sanchezf
sanchezf ✭✭✭✭✭

Has anyone used SMARTSHEET to assign a project level utilizing a scoring system? I've done it in Excel but can't seem to find one similar in SMARTSHEET? At the end it totals the score and then assigns a Level from 1-4 based on the score.


Answers

  • Brian_Richardson
    Brian_Richardson Overachievers

    You can do this fairly easily by rotating the scoring sheet. Here's how:

    1) Create a dropdown column for each question, with the answers.

    2) Create a score column for each question, to get the score. I like to include the score after the question (ie "Clearly defined - 01" and then use a simple =RIGHT([Requirements and Scope]@row,2) formula to pick up the number, but you could also use an IF statement for each question like =IF([Requirements and Scope]@row="Clearly defined",1,if([Requirements and Scope]@row="Some ambiguity",5,if([Requirements and Scope]@row="Vague or undefined",10)))

    3) Add a "Score" column to total up the score values from each question. If you picked up the score from the question text then your result is still text, so you have to use a VALUE function to get the number: =SUM(VALUE([Requirements and Scope Score]@row), VALUE([Estimated Time to Complete Score]@row), VALUE([Estimated Effort Score]@row)). If instead you used nested IF statements you will have a number and can simply add the cells.

    4) Make your scoring columns to be formula columns, that way they will apply to all new entries

    5) Create a form to present the users with a nicely formatted survey to collect the answers. Send the link out and you're ready to go!




    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN