Skip to Main Content

Share your product feedback

Status Future consideration
Categories Reports
Created by Guest
Created on Apr 1, 2019

Perform calculations on data in columns

This is probably on a roadmap somewhere, but in case it's not and I'm brilliant: 

Currently, calculation columns allow us to apply equations across a row of a list report (e.g., if Feature A's due date is before today(), display text "Behind schedule.").

But we can't perform calculation on data in columns of that list report, as you typically could in a spreadsheet. 

Use cases:

  • Average the effort estimations in a column
  • Sum the resource cost for all features in this release
  • Attach files
  • Guest
    Reply
    |
    Dec 22, 2022

    Will you be adding this capability? It would be super helpful.

  • Taimur Ahmed
    Reply
    |
    Feb 3, 2022

    Ditto for summing up scores

  • Guest
    Reply
    |
    Apr 15, 2021

    Creating a "total" row that sums up all cell values in a column is extremely fundamental capability that everyone uses in Excel.

  • Bob K
    Reply
    |
    Mar 26, 2020

    I would propose a third possible use case:

    • The calculated column would be a running total based on another column

    This would be helpful for lists showing potential work with an estimate of effort to get to that point (to assist with gauging resource needs, etc.).