We use an Excel based rubric to calculate a weighted score for each project based on the impact to the organization, the risk, goal alignment, value, etc. It’s currently a 6 question rubric with values assigned based on 3 available answers and multiplied based on weight. Is there a roadmap item to integrate a scoring rubric within a project or task?
I think I could create a form with custom assigned numbers based on the answers but there is no way to tie it back to our actual portfolio other than copy and paste. Direct integration would ideal to keep all the information together.
Simplest approach: Add six numeric custom fields corresponding to the six different scores. You couldn’t use the words you now do, but the description of the custom field could capture High=3, Med=2, Low=1 to make it fairly easy to use. Add one formula custom field to calculate the rubric based on the six numeric inputs and your multiplication of weights.
More complex approach: Keep those six number fields, but add another six single-select fields with your textual choices. Add six rules: When changed, set to corresponding value. The formula field is the same; it operates on the number fields.
Thank you Larry. Unfortunately we already have 14 columns in our portfolio and was hoping for a backend calculation solution that would then output the score. The other concern with this approach is that it would have to be numeric only without the context of how to ‘rate’ each question. Is there anything in the roadmap to do this without adding all the columns and can include the context? And if not, can it be added please?
In the more complex approach, I explained how to do that; the user wouldn’t see the numbers, only the textual choices.
I don’t work for Asana, I’m just a volunteer here, and Asana doesn’t publish a roadmap.
Don’t forget to click the title to scroll to the top and vote by clicking the Vote button; that’s the quickest and most effective way to express your support for a request.