DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Please enter at least three characters to search
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Zones

Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Modernize your data layer. Learn how to design cloud-native database architectures to meet the evolving demands of AI and GenAI workkloads.

Secure your stack and shape the future! Help dev teams across the globe navigate their software supply chain security challenges.

Releasing software shouldn't be stressful or risky. Learn how to leverage progressive delivery techniques to ensure safer deployments.

Avoid machine learning mistakes and boost model performance! Discover key ML patterns, anti-patterns, data strategies, and more.

Related

  • Non-Project Backlog Management for Software Engineering Teams
  • Zero to Hero on Kubernetes With Devtron
  • 10 Important Software Development Metrics That Every Project Manager Should Know
  • In-house Tool for Performance Testing

Trending

  • Analyzing “java.lang.OutOfMemoryError: Failed to create a thread” Error
  • Key Considerations in Cross-Model Migration
  • Scaling in Practice: Caching and Rate-Limiting With Redis and Next.js
  • How to Format Articles for DZone
  1. DZone
  2. Culture and Methodologies
  3. Agile
  4. Issue Prioritization Template

Issue Prioritization Template

In this guide, I share a Google Sheet Prioritization template and tell you about the tool my team invented based on it.

By 
Natasha Beseda user avatar
Natasha Beseda
·
May. 28, 20 · Tutorial
Likes (3)
Comment
Save
Tweet
Share
6.0K Views

Join the DZone community and get the full member experience.

Join For Free

Introduction

Many companies have faced the problem of issue prioritization, and my team is no exception. Customers wanted new features, managers offered their ideas, and developers came up with their solutions. Our product backlog in Jira turned into an endless list of issues. The sprint planning meetings took hours and ended up with the sprint still not getting the most significant backlog issues.

Our solution was to create a Google Sheets spreadsheet to prioritize tasks and synchronize the remote team.

  • We adopted a decision matrix or decision matrix analysis—a method that helps make weighted decisions based on different criteria.
  • Came up with criteria from the RICE score and AARRR. 
  • Integrated the spreadsheets with Jira using Automate.io. Tried Zapier as well.

And so we got a prioritization tool for the whole team.

We decided to share our prioritization template and tell you about the tool we invented based on it.

Get a Free Template and read how to create Jira to Google Sheets integration via Zapier.

How to Prioritize with An Issue Prioritization Template

We've left a few of our issues in the spreadsheet as an example. Delete them before configuring the prioritization matrix.

Rename the Teams and Criteria 

  1. Rename the tabs with the teams that will evaluate the issues. We've divided into Product Managers and Devs.
Renaming tabs


Also, change the team names on the Factors tab.

Change factor tab names


2. Rename the evaluation criteria on the same tab or use the suggested ones. The spreadsheet has an example of our criteria. They may differ for different teams. For example, managers can evaluate the impact of a feature on sales, but they cannot determine the development time.

Evaluation criteria

Our criteria examples:

  • Product Managers Team.
    • Money—Influences the money income.
    • Activation—Helps to understand how the product works.
    • Retention—Increase user's motivation to use the product again.
    • Service—Helps us spend on customer support less time without quality loss.
    • Ads—Increase the amount of Facebook Ads a user launches via our product. Important for Facebook Marketing Partnership.
    • Posting—Helps to create more templates or custom posts. Shows the advantage of posting and analysis via the tool. Customers post more via the service.
    • Reach—How many customers or product units or how much money this feature will affect.
  • Developers Team
    • Time—Time spent on development, complexity.
    • Value—Importance for development and product.

Add Criteria Weight and Description

1. Add to each criterion a description using a comment on the cell in the Factors tab and team tabs so that users can see them immediately. Do not put descriptions on separate tabs—no one likes to switch between them.

Add description


2. Add each criterion weight in the Factors tab—a ratio that shows the importance of the criterion compared to others.

Description weight

In our matrix, we used the Time criterion (dev time), which has a negative ratio. Set the required weight for each criterion from -3 to 3.

Add Jira Issue Links

Each issue has a link to Jira so that you can open it and read the description.

Jira issue links


. You must add the link to your Jira domain. Open any issue and copy a part of the link from it.

Add link to Jira domain


2. Add the link to the field on the Factors tab (Jira Domain for links).

Adding to Factors tab

Adding Jira links


Set Up the Total tab

  1. The evaluation results will appear on the Total tab.

The data is taken from the Factors tab from columns A through O by default.

If there are more/fewer criteria, they must be added/removed from the formula.

Setting up the Total Tab

Where the formula is.




1
What should be changed.




 

2. Issues with Done, In Review, Test, Bug, or Epic statuses do not fall into Total by default either. If you need to change this setting, add/remove the required statuses from the formula.

Changing settings

Issues Evaluation in Decision Matrix Template

We evaluated the issues once a week. We chose a specific day for the project prioritization to synchronize.

  1. To start the assessment, go to the tab with the team you belong to.
  2. Start evaluating each issue by existing criteria. In our weighted matrix template, the issues are scored from 0 to 3. Scores value:

0—No impact.

1—Low impact.

2—Medium impact.

3—High impact.

Calculation and Decision Matrix Analysis

After the evaluation, all scores are automatically calculated in the Calculations tab by the formula:

Total volume = Criterion 1*Factor 1 + Criterion 2*Factor 2  + Criterion 3*Factor 3 + Criterion N*Factor N.

The total value and the top priority issues will be calculated in the Total tab. Issues with a high number of scores will be at the top of the list. In the team's opinion, they have the highest priority. We have determined that we can take no more than 20 issues to the future sprint, so we highlight that number in the Total tab of the weighted decision matrix.

Highlighting tasks


You can change the number of top issues using the conditional formatting function.

How to Automate the Weighted Decision Matrix

At first, the Google Sheets spreadsheet seemed perfect, but after a couple of weeks, we started having problems: Jira import was constantly crashing, lots of duplicated or lost data rows, spreadsheets were often freezing when several people were evaluating at once. We had a Google Sheets admin who was continually fixing the formulas. Anyway, the team sometimes forgot to assign the scores.

After two months of suffering, we took this weighted scoring model as a basis and made our prioritization tool—Ducalis. Issues were uploaded automatically, formulas were no longer crashing, and notifications reminded users when it was time to prioritize. We used the service inside our remote team for more than a year and now decided to show it to the world.




1
Example of issues evaluation in Ducalis
Example of issues evaluation in Ducalis.


Template teams Google Sheets Sprint (software development) Matrix (protocol)

Published at DZone with permission of Natasha Beseda. See the original article here.

Opinions expressed by DZone contributors are their own.

Related

  • Non-Project Backlog Management for Software Engineering Teams
  • Zero to Hero on Kubernetes With Devtron
  • 10 Important Software Development Metrics That Every Project Manager Should Know
  • In-house Tool for Performance Testing

Partner Resources

×

Comments
Oops! Something Went Wrong

The likes didn't load as expected. Please refresh the page and try again.

ABOUT US

  • About DZone
  • Support and feedback
  • Community research
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends:

Likes
There are no likes...yet! 👀
Be the first to like this post!
It looks like you're not logged in.
Sign in to see who liked this post!